4 ms·

Is there a local-first postgres solution?

• malux85 2y ago
  What do you mean local first? Postgres is an executable that you can run on your machine if you wish
  • anonzzzies 2y ago
    I mean storing data in your https://localfirstweb.dev https://localfirstweb.dev . Sqlite allows that so you can work fully in our client (browser/mobile) without internet potentially and then later sync (rqlite, pouchdb, etc for instance). If I get to do 'everything' with postgres, I need that too, so I was wondering if it exists.
    • paulgb 2y ago
      https://electric-sql.com/ https://electric-sql.com/ does this, running a stripped-down version of postgres on the client. https://www.powersync.com/ https://www.powersync.com/ is a similar approach, but using sqlite on the client. https://zero.rocicorp.dev/ https://zero.rocicorp.dev/ also deserves a mention, but I believe it’s more of a read cache with writes going directly to the server. I’m not sure if it supports SQL client-side or has its own ORM.