Course contentsShow
← Data Science
Lesson 1089 of 2,14528. Working with Databases from PythonFree lesson

Establishing a Connection with sqlite3

Creating connections to SQLite databases and understanding the lightweight file-based database approach.

Establishing a Connection with sqlite3

What you'll learn: How to create your first connection to a SQLite database using Python's built-in sqlite3 module.

Now that you understand connection strings and database drivers, it's time to actually connect to a database. SQLite is perfect for getting started because it's lightweight, file-based, and requires no separate server installation—everything lives in a single file on your computer.

The File-Based Approach

Unlike traditional databases that run as separate server processes, SQLite stores your entire database in a single .db file. Think of it like opening a Word document: you point to the file, work with it, then close it when done. No server setup, no configuration headaches.

Making Your First Connection

Python's sqlite3 module comes pre-installed, so you can start immediately. Here's how to establish a connection:

import sqlite3

# Connect to a database file (creates it if it doesn't exist)
conn = sqlite3.connect('my_database.db')

# Your database work happens here...

# Always close when done
conn.close()

If my_database.db doesn't exist, SQLite automatically creates it. If it does exist, you'll connect to the existing database.

The In-Memory Option

For testing or temporary work, you can create a database entirely in RAM:

conn = sqlite3.connect(':memory:')

This disappears when your program ends—perfect for experiments without cluttering your file system.

Connection Objects

The conn object you receive is your gateway to everything database-related. You'll use it to create cursors for executing queries, manage transactions, and eventually close the connection to free resources.

Key Takeaway: Establishing a SQLite connection with sqlite3.connect() is simple and file-based—either point to a .db file or use :memory: for temporary databases, and always remember to close connections when finished.