🗃️SQLite
Also known as SQLite3, Sqlite
A tiny SQL database in one file. There is no server to run.
Think of it like
Think of it like a notebook in your pocket. It is small, but it is always with you.
Example
Emma's phone app keeps its notes in an SQLite file. Python can open the same kind of file with no extra install.
Why it matters
Definition
Example code
python
import sqlite3
con = sqlite3.connect("shop.db") # makes the file if needed
print(sqlite3.sqlite_version)
# 3.46.1Common mistake
Key takeaways
- 1One file. The whole database is a file.
- 2No server. The app opens it directly.
- 3One writer at a time. Fine for apps, not big sites.