litestream-base
rapid-cg
| litestream-base | rapid-cg | |
|---|---|---|
| 1 | 1 | |
| 32 | 8 | |
| - | - | |
| 0.0 | 0.0 | |
| about 2 years ago | almost 2 years ago | |
| Dockerfile | TypeScript | |
| - | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
litestream-base
-
Fly.io Buys Litestream
Litestream does a couple of things. It started as a way to continuously back sqlite files up to s3. Then Ben added read replicas – you can configure Litestream to replicate from a "primary" litestream server. It's still limited to a single writer, but there's no s3 in play. You get async replication to other VMs: https://github.com/fly-apps/litestream-base
We have a feature for redirecting HTTP requests that perform writes to a single VM. This makes Litestream + replicas workable for most fullstack apps: https://fly.io/blog/globally-distributed-postgres/
It's not a perfect setup, though. You have to take the writer down to do a deploy. The next big Litestream release should solve that, and is part of what's teased in the post.
rapid-cg
-
Fly.io Buys Litestream
I agree with this article! I even went so far as to write a Prisma-like SQL client generator that uses better-sqlite3 under the hood, so you get the nice API of Prisma and the synchronous performance of better-sqlite3. I’ve been using it for a few small projects, but I just released it at 1.0 yesterday.
https://github.com/CGamesPlay/rapid-cg
What are some alternatives?
Prisma - Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
chiselstore - SQLite + Little Raft = 🚀
sqlite_fdw - SQLite Foreign Data Wrapper for PostgreSQL
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
rqlite - The lightweight, distributed relational database built on SQLite.
actordb - ActorDB distributed SQL database
honeysql - Turn Clojure data structures into SQL
exqlite - An SQLite3 driver for Elixir