telexed ~ c / 761e4068-306radar:80 · infra_saasLIVE
← back
NO.
#761e4068
Topic
INFRA & SAAS
Source
Hacker News · Bootstrapped
Published
2024-08-12 13:43:30
Importance
★ 8/10 — radar 80
`Postgres.new`: browser Postgres sandbox with AI control
FIG-7611:1

`Postgres.new`: browser Postgres sandbox with AI control

A full Postgres sandbox now runs entirely in the browser with PGlite, and the LLM gets unrestricted DB access to retry SQL until it works. Useful as a zero-setup playground for schema, SQL, CSV, charts, and lightweight RAG flows before deploying anything.

[ KEY POINTS ]
  1. PGlite shrinks Postgres-in-WASM from roughly 30MB to under 3MB, which changes browser startup and shareability.
  2. The LLM can run back-to-back SQL with full permissions and use Postgres errors as feedback, so natural-language tasks complete more reliably than one-shot query generation.
  3. CSV upload creates tables automatically, then the same session can query them in plain English and generate charts with editable colors.
  4. pgvector works in-browser, and embeddings are generated locally with transformers.js, making small RAG demos possible without external infra.
  5. A read-only deployment path via pg-gateway and S3 is next, which opens a clean handoff from local browser sandbox to sharable Postgres endpoints.
Originalsupabase.com/blog/postgres-newRead original →

// related