Dataset is a Python library which is basically a wrapper around SQLAlchemy. It claims to be so easy to use that even lazy people like it.
Install dataset as follows:
$ pip3 install dataset
Create a SQLite in-memory database and connect to it:
import dataset
db = dataset.connect('sqlite:///:memory:')
Create a table called books:
table = db["books"]
Actually, the table in the database isn't created yet, since we haven't specified any columns. We only created a related object. The table schema is created automatically from calls to the insert() method. Give the insert() method dictionaries with book titles:
table.insert(dict(, author='Ivan Idris')) table.insert(dict(, author='Ivan Idris')) table.insert(dict(, author='Ivan Idris'))
Print the rows from the table as follows:
for row in db['books']: print(row)
The following will be printed:
<dataset.persistence.util.ResultIter object at 0x10d4bf550>
OrderedDict([('id', 1), ('title', "NumPy Beginner...