SQLite
A small relational database that runs as a library inside your program and keeps the whole database in one file.
In more detail
SQLite has no separate server: the application process reads and writes the database file directly, which makes it ideal for local tools, tests, phones and learning. It serialises writers, so only one write transaction runs at a time, and its typing is loose unless you ask for STRICT tables. The current major version is SQLite 3, whose command-line program is sqlite3.
Examples
The course uses Python's built-in sqlite3 module with an in-memory database so every injection demonstration is self-contained.sqlite:///quotesimport sqlite3
con = sqlite3.connect("notes.db")The course uses SQLite, through Python's sqlite3 module, to stand in for a SIEM's index and to express detection logic in SQL.Every runnable example in the SQL course uses SQLite 3.SQLite 3.37 added STRICT tables; 3.39 added RIGHT and FULL OUTER JOIN.Related terms
- SQL — The standard language for defining, querying and changing data in a relational database.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
- dev/prod parity — Keeping development, staging and production as similar as possible in timing, people and tools.
- Entity Framework Core — Microsoft's object-relational mapper for .NET, which lets code query and save database data as C# objects and translates LINQ into SQL.
- connection string — A text value that tells a database client where the database is and how to log in, such as Data Source=catalog.db.
- standard library — The collection of modules that ships with a programming language, available without installing anything extra.
- index — A separate, sorted structure a database keeps alongside a table so it can find matching rows without reading them all.
- full-text search — Searching for words anywhere in stored text, using an index of every token rather than named fields.
- embedded database — A database that runs as a library inside the application's own process instead of as a separate server.
- sqlite3 shell — The command-line program that opens a SQLite database file and lets you type SQL and see the results.
- type affinity — SQLite's rule that a column's declared type is only a preference: values are converted when sensible and otherwise stored as they are.
Taught in
- Ingest And Transform: Streams, Lakes And Partitions — AWS Certified Solutions Architect – Associate (SAA-C03) Exam Prep
- Data States: Security at Rest, in Transit, and in Use — Cybersecurity Fundamentals, GRC & Cryptography
- Privacy Principles, GDPR Subject Rights & Minimization — Cybersecurity Fundamentals, GRC & Cryptography
- Asset Lifecycle Management & Media Sanitization — Cybersecurity Fundamentals, GRC & Cryptography
- Business Impact Analysis, RTO & RPO Modeling — Cybersecurity Fundamentals, GRC & Cryptography
- Disaster Recovery Sites: Hot, Warm & Cold — Cybersecurity Fundamentals, GRC & Cryptography
- Config And Backing Services — DevOps & Site Reliability Engineering
- Disposability, Dev Prod Parity And Logs — DevOps & Site Reliability Engineering
- Admin Processes And The Open Source Update — DevOps & Site Reliability Engineering
- The Options Pattern: Strongly Typed Configuration — Modern .NET Core, C# & Enterprise Microservices
- A Standard Library Tour — Hands-on Python: Complete Video Course & Book
- SIEM Architecture: Ingestion Pipelines & Indexing — Security Operations & Threat Hunting (SOC)
- Post-Incident Review & Root Cause Analysis — Security Operations & Threat Hunting (SOC)
- Injection In All Its Forms — Application Security & Threat Modeling for Engineers
- SQL Injection: The Exploit — Application Security & Threat Modeling for Engineers
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling
- Where PostgreSQL Differs From SQLite — PostgreSQL, Indexing & Relational Data Modeling
- Literal Types: String, Number, Boolean Literals And const — Production TypeScript
References
- SQLite: about
- Python docs: sqlite3
- SQLite EF Core database provider
- SQLite: appropriate uses
- PostgreSQL: PREPARE