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.
This is a continuation of my post on getting started with Bpipe. In this post I followed the paired end alignment example from the documentation, with a few adjustments. This pipeline generates a random reference sequence, generates paired end reads from the reference, and aligns these reads back to the reference using BWA.