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:///quotes
import 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

Taught in

References

Certification courses