Go full serverless and take the complexity out of PostgreSQL database operations.
Why the Fuss About Serverless? | HackerNoon
To explain this, I’m going to have to recap on some old work with a particular focus on co-evolution.
Featherless - Serverless LLM Hosting
Freedom to reliably deploy any open model effortlessly.
PostgreSQL 14 Internals
Postgres Professional is a PostgreSQL company delivering Postgres Pro DBMS and all kinds of PostgreSQL professional services worldwide
ParadeDB — Search without a second system
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.
Episode 1 - Mongo DB Is Web Scale
PowerSync: Backend DB - SQLite sync engine | For Postgres, MongoDB, MySQL, SQL Server
Automatically sync your backend database with in-app SQLite and avoid the complexities of using APIs to move app state over the network.
API Platform Unkey Ditches Serverless After Performance Struggles
Developer Platform Unkey has written about rebuilding its entire API authentication service from the ground up, moving from serverless Cloudflare Workers to stateful Go servers after re-evaluating the constraints of their serverless architecture. The move resulted in a sixfold performance improvement and eliminated the workarounds that had become a dominant part of its engineering efforts.
Dialog DB "Serverless" Replication Demo
PostgreSQL Extensions or Protocols: Architecture Roulette
Should new infrastructure use PostgreSQL as a query engine, or aim for protocol compatibility instead?
Peer to Peer Databases
Peer to peer and decentralized applications have been popular lately, but almost all of them rely on synchronizing append only logs of operations (or an equivalent). This leads to performance degredation over time as data accumulates and needs to be processed on new peers before they can start querying and updating data within an existing swarm. This post will talk about how pre-indexed peer to peer databases can be built and how they can sidestep the need to process operation logs and query data more efficiently. The short of it is that with this new data structure, the network becomes your database instead of needing to build a database after loading everything from the network.
TigerFS
A filesystem backed by PostgreSQL, and a filesystem interface to PostgreSQL. TigerFS mounts a database as a directory. Every file is a real row. Writes are transactions. Multiple agents and humans can read and write concurrently with full ACID guarantees, locally or across machines. Any tool that works with files works out of the box.
Against SQL
But SQL is the only widely-used implementation of the relational model, and it is:
pgsky 0.2.0 — the Bluesky client that lives inside PostgreSQL — is now public OAuth, DPoP, timeline, posts, replies, threads, all as SQL procedures and views. Plus a Rust TUI styled like a database admin tool It's early, but we got this :)
GitHub - FormerLab/pgsky: An AT Protocol / Bluesky client implemented as a PostgreSQL extension. The database is the application
github.com