2026-04-09 13:49:44
#PostgreSQL running in the browser with an S3 storage backend - that's pretty impressive
https://www.zerofs.net/postgresql-in-the-browser
#PostgreSQL running in the browser with an S3 storage backend - that's pretty impressive
https://www.zerofs.net/postgresql-in-the-browser
📐 #PostgreSQL types auto-generate #TypeScript clients — no manual type mappings, no DTO layers, no impedance mismatch. Types flow outward from DB to frontend automatically.
🔁 RESTful path params like /products/{id}, reverse proxy endpoints (passthrough or transform), HTTP custom types letting #PostgreSQL functions call external APIs directly
🛡️ Enterprise-ready out of the box: authentication, authorization, rate limiting, caching, SSE streaming & full #OpenAPI
If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a
#Directus layers a blazingly fast #NodeJS API on top of any existing SQL database. No schema changes needed, works with what you already have.
🗄️ Database Freedom:
#PostgreSQL,
Set up HA to sent a metrics to Prometheus over MQTT so I can scale the PostgreSQL server I have on my home cluster for development down when my PC is off:
#MQTT #HomeAssistant #PostgresQL
📖 Automatic API documentation:
PostgREST generates #OpenAPI specs automatically from your schema. Hook up Swagger-UI − interactive, always up-to-date docs for your API. No more manual doc maintenance.
🏗️ Versioning through DB schemas:
Instead of managing API versions in code, PostgREST uses #PostgreSQL
#NpgsqlRest turns your #PostgreSQL database into a blazing-fast standalone #REST #API server …
🐘 PostgREST turns your #PostgreSQL #database into a fully #RESTful #API — instantly. No back…