Python SQLite Database: Store Data in a Local File

SQLite Database

Python includes sqlite3, so you can practice database storage without installing a server.

Use SQLite for learning SQL, small apps, local tools, prototypes, and project data that should survive after the program stops.

Connection and Table

A connection opens the database file. SQL statements create tables and query data.

Create Table

import sqlite3

with sqlite3.connect("tasks.db") as conn:
    conn.execute("""
        CREATE TABLE IF NOT EXISTS tasks (
            id INTEGER PRIMARY KEY,
            title TEXT NOT NULL
        )
    """)

Insert and Select

Save and Read Task

import sqlite3

with sqlite3.connect(":memory:") as conn:
    conn.execute("CREATE TABLE tasks (title TEXT)")
    conn.execute("INSERT INTO tasks (title) VALUES (?)", ("Learn SQLite",))

    rows = conn.execute("SELECT title FROM tasks").fetchall()
    print(rows[0][0])

Output

Learn SQLite

Before you move on

Can You Use SQLite Database?

5 checks

You can create a SQLite connection.
You can create a table with SQL.
You can insert values using placeholders.
You can select rows and read results.
You can choose SQLite when a local file database is enough.

SQLite Decisions

0 of 2 checked

Q1. Why use placeholders in SQL statements?

To keep values separate from SQL syntax To make strings mutable To skip commits forever To rename every column

Q2. What is SQLite especially useful for in beginner projects?

A local file database without a separate server Replacing every Python list Drawing UI buttons Installing Python

Database Write Traps

Building SQL with string concatenation
Use placeholders for values to avoid broken queries and unsafe input handling.
Forgetting to save changes
Use a with block or call commit after inserts, updates, and deletes.
Using SQLite as a full server replacement
Use it for local and small apps. Choose a database server for heavy multi-user workloads.

Try this next

Store Rows Locally

0 of 3 completed

Create notes table
Create a notes table with title and body columns, insert two rows, and select them.
Parameterize a lookup
Ask for a task title and search using a ? placeholder.
Add completed status
Alter the table design in a fresh script so each task can be complete or pending.

Questions About SQLite Database

For basic Python use, no. The sqlite3 module is included with Python.

Yes. It is excellent for local task apps, notes apps, small reports, and learning SQL.

Placeholders keep values separate from SQL syntax, which avoids many quoting mistakes and unsafe query patterns.

Python SQLite Database: Store Data in a Local File

SQLite Database

Connection and Table

Create Table

Insert and Select

Save and Read Task

Can You Use SQLite Database?

SQLite Decisions

Q1. Why use placeholders in SQL statements?

Q2. What is SQLite especially useful for in beginner projects?

Database Write Traps

Building SQL with string concatenation

Forgetting to save changes

Using SQLite as a full server replacement

Store Rows Locally

Create notes table

Parameterize a lookup

Add completed status

SQLite Database Learning Path

Questions About SQLite Database

Do I need to install SQLite separately?

Is SQLite good for beginner projects?

Why use placeholders?

Python Resources

Popular Tutorials