Python · Theory

SQLite in Python

Theory

121/268

SQLite in Python

SQLite is a file-based SQL database in the standard library. import sqlite3 — no separate server for practice. Connect to a .db file, CREATE TABLE, INSERT, SELECT with a cursor, commit, close. Perfect for learning SQL and small apps. Not every production scale. Same placeholder rule: don’t + user text into SQL.

Connect → execute → commit → close. That four-step line plus “stdlib, file-based” is the fresher sqlite answer.

SQLite in Python — output — Asha. In-memory SQLite — real SQL, no extra install.

Exam tip

Connect → execute → commit → close.

Example

# sqlite3
import sqlite3
con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.execute("create table t(id integer, name text)")
cur.execute("insert into t values(1, 'Asha')")
con.commit()
print(cur.execute("select name from t where id=1").fetchone()[0])
con.close()

SQLite in Python — output: Asha. In-memory SQLite — real SQL, no extra install.

Short notes

Defsqlite3 stdlib. File DB.
RuleNo server needed for basics.
Remembercommit after write.

# sqlite3 import sqlite3 con = sqlite3.connect(":memory:") cur = con.cursor() cur.execute("create table t(id integer, name text)") cur.execute("insert into t values(1, 'Asha')") con.commit() print(cur.execute("select name from t where id=1").fetchone()[0]) con.close()

SQLite in Python

Example

Short notes

Questions

SQLite in Python

Example

Short notes

Questions