When developers think of databases, they usually think of PostgreSQL, MySQL, or MongoDB. They think of servers, ports, and complex installations.
But if you are building a lightweight app, a local script, or an AI tool on constrained hardware (like an Android phone via Termux), you don't need a database server.
You need SQLite.
SQLite is a C library that provides a lightweight disk-based database. It doesn't require a separate server process, and it allows you to access the database using a nonstandard variant of SQL. Best of all? It is built directly into Python.
Here is how to use it in 30 seconds.
1. The Built-in Module
Because sqlite3 is part of the Python Standard Library, you do not need to pip install anything. Just import it.
import sqlite3
Enter fullscreen mode
Exit fullscreen mode
2.β¦