A file database survives a second connect in the same run, and shows up as a download chip.

Goal

Write kiosk.db, reopen it, print cities.

import sqlite3
con = sqlite3.connect("kiosk.db")
con.execute("CREATE TABLE IF NOT EXISTS cities (name TEXT UNIQUE)")
con.execute("DELETE FROM cities")
con.executemany("INSERT INTO cities VALUES (?)", [("Nairobi",), ("Kisumu",)])
con.commit()
con.close()
con = sqlite3.connect("kiosk.db")
print(con.execute("SELECT * FROM cities").fetchall())
con.close()

from pathlib import Path
print("kiosk.db exists", Path("kiosk.db").exists())
print("size", Path("kiosk.db").stat().st_size if Path("kiosk.db").exists() else 0)

import sqlite3
con = sqlite3.connect("kiosk.db")
print(con.execute("SELECT name FROM sqlite_master WHERE type='table'").fetchall())
con.close()

import sqlite3
con = sqlite3.connect("kiosk.db")
print(con.execute("SELECT COUNT(*) FROM cities").fetchone())
con.close()