Sqlite3

• https://devdocs.io/python~3.9/library/sqlite3

import sqlite3
conn = sqlite3.connect("example.db")
c = conn.cursor()
c.execute('create table Persons (id int, name text, city text)')
c.execute('insert into Persons VALUES (1, "smith", "dallas")')
conn.commit()
conn.close()

import sqlite3
conn = sqlite3.connect('example.db')
c = conn.cursor()
x = c.execute("select * from Persons")
x.fetchall()
[(1, u'smith', u'dallas')]

---

Children

1. CLI
2. Tools

---

Backlinks

• 25 (DevLog)
• 28 (DevLog)
• Sql Alchemy (DevLog)