📝 How to Use SQLite in Python (Without Installing a Database Server)

base 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 2. Connecting and Creating a Table When you connect to a database file, if the file doesn't exist, SQLite will automatically create it for you.

# Connect to the database (creates 'app.db' if it doesn't exist) conn = sqlite3.connect('app.db') cursor = conn.cursor() # Create a table cursor.execute(''' CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT NOT NULL UNIQUE ) ''') # Save (commit) the changes conn.commit() 3. Inserting Data Safely Never use f-strings to insert data into SQL! It leaves you open to SQL injection attacks. Always use the ?

placeholder. # Insert a new user cursor.execute(''' INSERT INTO users (name, email) VALUES (?, ?) ''', ('Ezenwa', 'ezenwa@example.com')) conn.commit() 4. Fetching Data Once your data is saved, you can query it using fetchall() or fetchone(). cursor.execute('SELECT id, name, email FROM users') rows = cursor.fetchall() for row in rows: print(row) 5.

Always Close the Connection When you are done with your script, make sure to close the connection to free up system resources. conn.close() Why use SQLite? If you are building a mobile app, a CLI tool, or an AI script running on a local machine, SQLite is perfect. It is zero-configuration, incredibly fast for local data, and doesn't consume the memory that a full database server like PostgreSQL would.

Have you used SQLite in your Python projects? Let me know below!