Browse Teach Curate

Querying a SQLite Database from Python with the sqlite3 Module

Opening a connection to a SQLite file, obtaining a cursor, and executing SELECT, INSERT, UPDATE and DELETE statements with parameters to store and retrieve rows from a Python program.

Questions this Concept answers

Why does parameter binding matter for speed and not only for safety?

jeremy Text

sqlite3 â DB-API 2.0 interface for SQLite databases

Python ships with a module that talks to a SQLite database file directly, with no server to install. You open a connection to the file, ask it for a cursor, and then run SQL statements through that c…

Querying a SQLite Database from Python with the sqlite3 Module

Questions this Concept answers

sqlite3 â DB-API 2.0 interface for SQLite databases

sqlite3 â DB-API 2.0 interface for SQLite databases