SQLite3 is a very easy to use database engine. It is self-contained, serverless, zero-configuration and transactional. It is very fast and lightweight, and the entire database is stored in a single disk file. It is used in a lot of applications as internal data storage. The Python Standard Library includes a module called “sqlite3″ intended […]
Series: Python SQLite Tutorial
A guide to what the SQLite database is, and how it works with Python. Including selecting, inserting and updating rows.
Following the SQLite3 series, this post is about some advanced topics when we are working with the SQLite3 module. If you missed the first part, you can find it here. Using SQLite’s date and datetime Types Sometimes we need to insert and retrieve some date and datetime types in our SQLite3 database. When you execute […]