Python datasets:dataset databases for lazy people! Bumped into this project that provides a simple abstraction layer removes most direct SQL and an export mechanism to export data in JSON or CSV formats.

Why datasets?
Say if you have opted to use sqlite, the below is how normal operations would look like:

1234567891011121314151617181920212223242526

importsqlite3# open connection and get a cursorconn=sqlite3.connect(':memory:')c=conn.cursor()# create schema for a new tablec.execute('CREATE TABLE IF NOT EXISTS sometable (name, age INTEGER)')conn.commit()# insert a new rowc.execute('INSERT INTO sometable values (?, ?) ',('John Doe',37))conn.commit()# extend schema during runtimec.execute('ALTER TABLE sometable ADD COLUMN gender TEXT')conn.commit()# add another rowc.execute('INSERT INTO sometable values (?, ?, ?) ',('Jane Doe',34,'female'))conn.commit()# get a single rowc.execute('SELECT name, age FROM sometable WHERE name = ?',('John Doe',))row=list(c)[0]john=dict(name=row[0],age=row[1])