Python SQLite Tutorials

Introduction

SQLite databases are a powerful form of persistent file storage that are a great alternative to CSV files.

Advantages

• Very powerful – you can do advanced queries ( like searching and sorting) very quickly
• You can create relational databases which are brilliant for larger or more complex projects
• Easy to manage the databases.
• Great for learning SQL queries that you will need in the GCSE Exam.

Disadvantages

• More code at the start of a project to get started
• A little bit harder to learn than simple text files.