YouTipWhat is SQLite?
SQLite is a self-contained, serverless database stored in a single file.
sqlite3 mydb.db
CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO users (name) VALUES ("Alice");
SELECT * FROM users;Python Integration
import sqlite3
conn = sqlite3.connect("mydb.db")
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")
print(cursor.fetchall())Summary
- SQLite requires no server installation
- Perfect for embedded apps and development