Getting started with SQLite

SQLite is an embedded relational database engine that is self-contained, meaning that it has everything it needs to run. You don't need to configure anything because it's serverless and it has a transactional SQL database engine. To get started all you need to do is download the relevant binary file. My motivation for checking out SQLite is that I wanted to organise a bunch of Excel files a collaborator has sent me. I've played around with MySQL a while ago but I wanted something much lighter and then I came across SQLite.

Continue reading