Modern Python Standard Library Cookbook

Reading/writing a database

Python is often referred to as a language that has batteries included, thanks to its very complete standard library, and one of the best features it provides is reading and writing from a full-featured relational database.

Python ships with the SQLite library built in, meaning that we can save and read database files stored by SQLite.

The usage is pretty straightforward and most of it actually just involves sending SQL for execution.