Kyle

Notorious Gen. Soleimani's sultry grandniece led lavish lifestyle touring US hotspots, as her mom promoted Iranian regime trib.al/y38evjw

What if we could run Postgres as a single file, and take advantage of the best SQLite has to offer? Today I am announcing pg-micro, a crazy experiment I've been undertaking to make this happen. pg-micro is different than other approaches because it is fully local, and expected to be fast: there is no concurrency limitation and no statement translation. Here's how it works: we use the actual postgres parser to parse the statement, but compile that to the Turso AST. The Turso AST is then compiled do bytecode, and from there everything executes natively, as it'd do in SQLite. This makes it a perfect target to run in any environment. There is traditionally a mismatch between Postgres and SQLite in terms of functionality. But @tursodatabase has been hard at work to close this gap: things like MVCC and a rich, strict type system are present in Turso. There are PRs for things like lateral joins, etc. This means that the gap can be closed until it theoretically reaches zero. What you could do with it? Just imagine for example a primitive like Durable Objects by @Cloudflare, but with a postgres interface? Or imagine you could use the same pattern of local databases for agents that SQLite gives you, totally ephemeral and free, but with a Postgres interface? Or even that you could execute remote postgres in platforms like @vercel but with the unmatched density of the Turso Cloud? Expect lots not to work at this point. But as usual, this is done in the full spirit of OSS, so PRs welcome! To get started: npx pg-micro