ngosangns Knowledge Base

#postgres

  • PGX
    PGX (pgrundev/pgx, AGPL-3.0) is a Rust runtime that serves hundreds to thousands of isolated Postgres databases from one process by keeping a single Postgres 18.6-compatible engine, minting databases on connect and branching them with ZFS copy-on-write — built for CI, previews and agent sandboxes, explicitly not production.
  • PostgreSQL
    Guide to PostgreSQL, the extensible open-source RDBMS, covering data types, JSON/JSONB, arrays, full-text search, index types, window functions, CTEs, and best practices.