SQLite-based databases on the Postgres protocol? Yes we can

• marmot

  33 1,628 8.6 Go

  A distributed SQLite replicator built on top of NATS

So while working on Marmot (https://github.com/maxpert/marmot) I considered something similar, and the thing that stood obvious with my benchmarks was readers can go really fast if I let them do things in process vs over some protocol (be HTTP or Postgres). I had the same problem with rqlite and dqlite, so I made a very conscious design choice to build Marmot into a side-car and not a layer on top. This idea is so tempting and goes against ethos of SQLite IMO.

• postgres

  42 6,704 8.2 JavaScript

  Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)

I don't think this should turn in to an ORM or not debate, but there are plenty of reasons, especially for the crowd that would do anything to avoid ORMs. Just try to take a peek into the multitude of "ORMs are bad" articles / discussions.

For instance - I would love to be able to use https://github.com/porsager/postgres with sqlite.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• mORMot

  1 771 6.5 Pascal

  Synopse mORMot 1 ORM/SOA/MVC framework - Please upgrade to mORMot 2 !

Damn my dyslexia I read marmot and thought you meant this unrelated project https://github.com/synopse/mORMot

• PostgresApp

  58 7,111 9.2 Makefile

  The easiest way to get started with PostgreSQL on the Mac

  

And if you're on a Mac, Postgres.app makes it even easier: https://postgresapp.com/

Suggest a related project