SQLite – The Session Extension

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • Mergify - Updating dependencies is time-consuming.
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • rqlite

    The lightweight, distributed relational database built on SQLite

    This exists already with rqlite: https://github.com/rqlite/rqlite

    As much as I love the idea, Raft is not a silver bullet and can break in strange and inconspicuous ways that may be difficult to fix. It can also lead to subtle inconsistencies in the data depending on what data you are putting in it. Overall it may be good in some situations, but I doubt it will dislodge Postgres in any meaningful way.

  • dqlite

    Embeddable, replicated and fault tolerant SQL engine.

    rqlite is nice but it's got limitations that made me look elsewhere. https://dqlite.io/ does it in C and allows for transactions and can be used for the Go sql.DB object.

  • Mergify

    Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.

  • citus

    Distributed PostgreSQL as an extension

    I mean... why wait? SQLite + Paxos already exists: https://bedrockdb.com/

    As a cherry on top, Postgres + Raft/Paxos already exists, too. It's called Citus: https://github.com/citusdata/citus

    While I enjoy the spirit of your comment the meat of it is hand wavy. Many of the reasons people enjoy SQLite so much vanish the moment you introduce a consensus protocol or any sort of replication algorithm between online nodes. A better investment would be tooling and systems that guide us on how to operate multi-node stateful systems and inform of us of probabilities of bad things happening.

  • Bedrock

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

    I mean... why wait? SQLite + Paxos already exists: https://bedrockdb.com/

    As a cherry on top, Postgres + Raft/Paxos already exists, too. It's called Citus: https://github.com/citusdata/citus

    While I enjoy the spirit of your comment the meat of it is hand wavy. Many of the reasons people enjoy SQLite so much vanish the moment you introduce a consensus protocol or any sort of replication algorithm between online nodes. A better investment would be tooling and systems that guide us on how to operate multi-node stateful systems and inform of us of probabilities of bad things happening.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts