Introduction to SQLite in Python

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 […]

Read More

Advanced SQLite Usage in Python

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 […]

Read More