I Built Litestream

• seamless

  1 106 2.3 Go

  Seamless restart / zero-downtime deploy for Go servers

You can do zero-downtime deploys on a single node with tools like seamless[1]. That works for Go but I'm sure there are other options for other languages. I'm not sure if/how you can do it with a containerized workload on a single node though. I haven't tried that.

[1] https://github.com/rs/seamless

• litestream

  165 9,964 7.5 Go

  Streaming replication for SQLite.

I haven't tried Backblaze B2 but I agree with you on engaging in AWS hell. Litestream should work with any S3-compatible API. I've added an issue to add guides for B2 & Minio[1].

Regarding Postgres vs SQLite, I've found that I can use much simpler SQL calls with embedded databases when I don't need to worry about N+1 query performance issues. That makes many of the query features moot. That being said, there is a JSON extension for SQLite[2] although I haven't tried it.

[1] https://github.com/benbjohnson/litestream/issues/41

[2] https://www.sqlite.org/json1.html

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• Hugo

  548 72,452 9.8 Go

  The world’s fastest framework for building websites.

  

Thanks! The site is a Hugo[1] site with a modified version of the Doks template[2]. I changed some colors and the font and I hired a designer on Fiverr to do a logo for $99.

[1]: https://gohugo.io/

• raze

  1 171 0.0 Crystal

  Discontinued Modular, light web framework for Crystal (by samueleaton)

none. I had built a Crystal web framework that i retired[1]. I created something else that I use that's faster than the popular ones. Not open sourced.

[1]: https://github.com/samueleaton/raze

• pysqlite3

  3 162 5.4 C

  SQLite3 DB-API 2.0 driver from Python 3, packaged separately, with improvements

Lastly, use a modern version of SQLite. Many default installations come with versions from a few years ago. In Python for example, you can use pysqlite3[0] to get the latest SQLite without worrying about compiling it (and it also comes with excellent compilation defaults).

[0] https://github.com/coleifer/pysqlite3

• Bedrock

  23 1,044 9.4 C

  Rock solid distributed database specializing in active/active automatic failover and WAN replication (by Expensify)

  

This is great. I love all of the work being done around SQLite.

If bedrockdb ( https://bedrockdb.com/ ) replicated to object storage like litestream, I’d be in heaven.

Suggest a related project