pip install PyDBLitewebpy
python
from pydblite import pydblite
python
pydb = pydblite.Base('mydatabase.db')
pydb.create('mytable', 'name', 'age', 'email')
pydb.connect()
python
pydb.insert(name='John Doe', age=25, email='john@example.com')
pydb.update(pydb.mytable.name == 'John Doe', age=26)
results = pydb(pydb.mytable.name.startswith('John')).select()
pydb.delete(pydb.mytable.name == 'John Doe')