SQLite is an embedded relational database engine that stores a database in a local file.
SQLite is an embedded relational database engine that stores application data in a local file. A single-container to-do app can use SQLite without running a separate database service. section 7.4
Use SQLite when:
The application is small and can keep its database file with the app container. section 7.4
Container volumes preserve and manage the database file beyond the container lifecycle. section 7.4
Larger applications need a separate PostgreSQL database running as another service. section 7.4
A containerized to-do app
Run the to-do application as one container and store its data in an SQLite file inside that container. Attach a volume to manage the file; later, configure the application to use a remote PostgreSQL database when the project grows. section 7.4
How Learn Docker in a Month of Lunches, Second Edition covers it
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.
How it connects
Connects SQLite with containers, Docker volumes, relational databases, and PostgreSQL.
Python How-ToSQLite is an embedded relational database engine that stores an application's data in a local disk file without requiring a separate server process.
Logs and TelemetrySQLite is an embedded relational database engine that stores a complete database in a local file without requiring a separate server process.
Code Like a Pro in RustSQLite is an embedded relational database engine that stores database state in a file and operates within the application process.
Go by ExampleSQLite is an embedded relational database engine that stores data in a local file or in memory without requiring a separate server process.
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.
This explainer was generated by Manning's knowledge graph from the text of Learn Docker in a Month of Lunches, Second Edition. The section links point to the parts of the book it draws on.
