Exploring Write Ahead Logs and Streaming Sqlite to S3
May 25, 2022I've been using sqlite in production for some of my personal projects for the last few months. It's an incredible, simple and powerful tool for saas-type workloads. It's embedded within the application so is incredibly fast. One of the challenges is that it's a single point of failure which can make recovering or making the database more available a pain. Enter [Litestream](https://litestream.io/). Using litestream I've been able to solve a lot of these concerns. Litestream streams sqlite to S3. I've been wanting to dive deep into write-ahead logs and streaming them to S3.