Introduction

We will use SQLite because:

• SQLite requires no installation, configuration or server... and it's free!
• An SQLite database is all contained within a single file, which makes for easy:
  • duplications (think backups)
  • portability (think movement or deployment)
• an SQLite database file works easily with Python (and many other languages)
• We can use a free cross-platform GUI tool - DB Browser for SQLite - which is simple, easy, light-weight and can manage our SQLite database files
• There is no mention of Microsoft Access in the Digital Solutions syllabus, however SQLite gets a mention page 27 of 93
• more reasons why here

recommended for SQLite: DB Browser for SQLite