SQLite
SQLite is a self-contained, serverless relational database engine implemented as a software library that stores and queries databases in files or memory.
A Pythonic Adventure: From Python basics to a working web app
SQLite is an embedded relational database engine that stores a database in a self-contained file.
- How it is used
- Replaces JSON-based order loading and saving with database-backed storage and queries.
- How deep it goes
- Explains connections, cursors, tables, inserts, commits, SELECT queries, and fetched rows through a working order application.
- Examples
- Uses an orders.db file, drink orders, an orders table, insertion, retrieval, and an HTML order list.
- What you can do after
- Operate SQLite through Python to persist new orders and retrieve them for display.
Read how A Pythonic Adventure: From Python basics to a working web app explains SQLite →
Coding with AI
SQLite is a lightweight embedded relational database engine that stores a database in a local file.
- How it is used
- Uses SQLite to store and retrieve a small practice-question pool for a Flask application.
- How deep it goes
- Walks through CSV import, primary-key setup, browsing, connection prompting, and context-managed retrieval, without explaining SQLite internals.
- Examples
- Demonstrates a questions CSV, a questions.db file, DB Browser inspection, and a Flask route rendering fetched question data.
- What you can do after
- Operate/configure it by importing question data, validating the table, connecting from Python, and rendering retrieved rows in Flask.
Data Analysis with LLMs
SQLite is a lightweight relational database engine that stores an entire database in a self-contained file and supports SQL.
- How it is used
- Stores tabular data for SQL analysis and supplies database structure to a natural-language query interface.
- How deep it goes
- Walks through installation, table creation, CSV import, query execution, and schema extraction without exploring database-engine internals.
- Examples
- Uses video-game records, a CSV import, a row-count query, a Colab query notebook, and Python schema-extraction code.
- What you can do after
- Operate/configure it to load tables, run SQL queries, and retrieve table definitions for a query interface.
Practices of the Python Pro
SQLite is a lightweight relational database engine that stores an entire database in a single file.
- How it is used
- Supports the persistence layer by storing and retrieving application data through Python's sqlite3 module.
- How deep it goes
- Explains single-file storage, connections, SQL statements, and CRUD methods, but stops before advanced database packages.
- Examples
- Uses a bookmarks table, parameterized inserts, record deletion, selection, filtering, and title sorting.
- What you can do after
- Operate/configure a SQLite database through Python connections, tables, parameterized queries, and CRUD methods.
The Well-Grounded Python Developer: How the pros use Python and Flask
SQLite is an embedded relational database engine that stores a complete database in a local file.
- How it is used
- Provides persistence for users, transactions, and posts without requiring a separate database server during application development.
- How deep it goes
- Explains the in-process deployment choice and one SQLite-specific modeling limitation, while leaving detailed SQLAlchemy usage for later.
- Examples
- Uses persisted login users, a transaction database, and a post sort-key function that works around SQLite’s nonprimary-key autoincrement limitation.
- What you can do after
- Apply it via SQLAlchemy to persist application data and recognize when a model needs a SQLite-specific workaround.
Read how The Well-Grounded Python Developer: How the pros use Python and Flask explains SQLite →
.NET MAUI in Action
SQLite is an embedded, open-source relational database engine implemented as a self-contained library.
- How it is used
- Persists structured application data locally in .NET MAUI apps, including records that must survive later launches.
- How deep it goes
- Builds a working database-backed app with models, packages, paths, encryption, table creation, and asynchronous retrieval.
- Examples
- Uses the MauiTodo application, TodoItem model, encrypted database, title entry, date picker, and displayed task list.
- What you can do after
- Build it from scratch as a persistent, optionally encrypted data store in a .NET MAUI application.
Python How-To
SQLite is an embedded relational database engine that stores an application's data in a local disk file without requiring a separate server process.
- How it is used
- Persists task-app data in a lightweight database instead of relying on a CSV file.
- How deep it goes
- Works through connection and table creation, filtered retrieval, updates, and deletion; limits field examples to text and integers.
- Examples
- Uses a task table and methods for loading, editing, and deleting task records.
- What you can do after
- Build it from scratch as a local task database, then retrieve, update, and delete its records through sqlite3.
.NET in Action, Second Edition
SQLite is an embedded relational database engine that stores a complete database in a local file or in memory.
- How it is used
- Provides SQL-backed storage for EF Core application code and lightweight in-memory databases for integration tests.
- How deep it goes
- Works through configuration, connection lifetime, schema creation and asynchronous queries, without descending into SQLite engine internals.
- Examples
- Uses a book catalog with ratings and a comic-search integration test with faked HTTP responses.
- What you can do after
- Apply it via EF Core to configure SQL storage, keep an in-memory database alive and isolate parallel tests.
Logs and Telemetry
SQLite is an embedded relational database engine that stores a complete database in a local file without requiring a separate server process.
- How it is used
- Tracks file-read progress so restarted Fluent Bit tail inputs avoid reingesting logs from long-running processes.
- How deep it goes
- Explains DB-file configuration, locking, source isolation, worker effects, and journaling-related options without detailing SQLite internals.
- Examples
- Demonstrates a tail configuration that reads a local file, stores progress in tracking-file-read.db, and writes events to stdout.
- What you can do after
- Operate/configure persistent file-tail progress with DB and DB.locking settings for restart recovery and source isolation.
Latency
SQLite is an embedded relational database engine that stores and processes database contents within an application process.
- How it is used
- Deploys an embedded database inside a REST API to colocate data and computation and reduce request latency.
- How deep it goes
- Demonstrates connection sharing, query execution, and HTTP benchmarking, but does not detail SQLite storage internals or schema design.
- Examples
- Compares SQLite and PostgreSQL through a Rust /hello endpoint, wrk measurements, and latency-distribution analysis.
- What you can do after
- Builds a Rust REST endpoint backed by SQLite and evaluates it with wrk latency and throughput measurements.
Code Like a Pro in Rust
SQLite is an embedded relational database engine that stores database state in a file and operates within the application process.
- How it is used
- Provides the stateful database layer for a horizontally scalable Rust HTTP API.
- How deep it goes
- Explains configuration, pooling, file creation, migrations, and schema choices, while deferring broader database complexity.
- Examples
- Uses a db.sqlite file, an init_dbpool function, and a todos table migration with timestamp and primary-key defaults.
- What you can do after
- Apply it via SQLx to initialize a SQLite database, manage pooled access, and run schema migrations.
Go by Example
SQLite is an embedded relational database engine that stores data in a local file or in memory without requiring a separate server process.
- How it is used
- Provides persistent storage for a Go link service without requiring a separately installed database server.
- How deep it goes
- Explains driver registration, connection establishment, pool reuse, and pool tuning, while leaving schema and query implementation to subsequent steps.
- Examples
- Uses a persistent link server, links.db, a Dial helper, HTTP endpoints, and curl requests to demonstrate storage across restarts.
- What you can do after
- Build it with database/sql and a SQLite driver, then configure a link service to preserve records across process restarts.
Learn Docker in a Month of Lunches, Second Edition
SQLite is an embedded relational database engine that stores a database in a local file.
- How it is used
- Provides local persistence for a small application running in a single container.
- How deep it goes
- Defines SQLite as a local database file and addresses volume management, but stops short of internals or query syntax.
- Examples
- Uses a containerized to-do app whose SQLite file is managed with a volume.
- What you can do after
- Operate small containerized applications with local SQLite persistence and recognize when PostgreSQL is more suitable.
Read how Learn Docker in a Month of Lunches, Second Edition explains SQLite →
DuckDB in Action
SQLite is an embedded relational database library primarily used for transactional data storage in applications.
- How it is used
- Queries existing SQLite files through DuckDB for analytical work without persisting an intermediate DuckDB storage model.
- How deep it goes
- Explains extension loading, attachment, inspection, type mismatches, and view-based casting, but not SQLite internals.
- Examples
- Uses a 300 MB European soccer SQLite database, Player views, schema inspection, and latest-player-rating queries.
- What you can do after
- Operate/configure SQLite access through DuckDB, inspect tables, diagnose type mismatches, and build casted analytical views.
Grokking Statistics
SQLite is a self-contained, serverless relational database engine that stores an entire database in a single file.
- How it is used
- Supports local relational storage, SQL retrieval, and practical data analysis without requiring a database server.
- How deep it goes
- Introduces SQLite’s role and basic workflows but stops short of database internals or detailed implementation guidance.
- Examples
- Uses a flight-schedule query, a pandas tornado database workflow, and a resumable batch-download workaround.
- What you can do after
- Apply it via Python and SQL to retrieve data, load results into pandas, and build simple local workflows.
Related concepts
- FluentBitused by · Fluent Bit is a lightweight, open-source telemetry agent for collecting, processing, enriching, and forwarding logs and other event data.
- databasekind of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- MySQLalternative to · MySQL is an open-source relational database management system that stores, manages, and queries structured data using SQL.
- sqlite3used by · sqlite3 is Python’s standard-library module providing an interface for creating, accessing, querying, and manipulating SQLite databases without a separate server.
- PostgreSQLalternative to · PostgreSQL is an open-source object-relational database management system that implements SQL and supports transactional data storage and extensibility.
- SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.