Discover Blogs

Putting Postgres in package.json

Apr 30

Part 3 of our PostgresConf 2026 series. Inside the second talk: pgpm, modular databases, and why test-driven database development is a survival requirement for AI-generated code.

When Trust Becomes Infrastructure: Secure-by-Default Postgres

Apr 29

Part 2 of our PostgresConf 2026 series. A recap of the keynote on why human code review can't keep up with AI-generated code—and why trust has to move down the stack into a secure-by-default database.

From Berkeley to AI: Reflections on PostgresConf 2026

Apr 28

Part 1 of our PostgresConf 2026 series. Sitting down with original Berkeley Postgres developers Greg Kemnitz and Curt Kolovson, and dbtune's Luigi Nardi, on how a forty-year-old database became the foundation for the AI era.

Agentic DB: The Open-Source Brain for Your Agents

Apr 16

Introducing agentic-db — a full-stack Postgres knowledge base and personal CRM, installable in one command via pgpm. The open-source schema gives you vector search, full-text search, and auto-embeddings.

Agent Orchestration Doesn’t Solve Trust

Mar 18

The multi-agent future just got real. Here's why it needs a trust layer at the database — and why orchestration frameworks alone can't solve the data and authorization problem.

Agents Are Probabilistic. Your Business Can’t Be

Mar 4

AI agents are inherently probabilistic, but businesses run on deterministic systems. Constructive is building secure-by-default Postgres infrastructure so the database becomes the trust boundary for the agentic era.

What We Mean by Secure-by-Default Postgres

Feb 11

Security settings and secure architecture are not the same thing. Constructive introduces the first secure-by-default Postgres platform—where RLS policies are compiled and enforced at table creation, not bolted on after the fact.

100 Million Downloads

Feb 10

Constructive's open-source ecosystem has officially crossed 100 million npm downloads. A milestone built nearly a decade of work—and a community that made it possible.

Trusted LLM RAG Pipeline: Ollama & Postgres

Dec 29, 2025

A reference implementation for building Retrieval-Augmented Generation (RAG) pipelines using local LLMs, Postgres, and pgvector. Real embeddings, semantic search, and end-to-end tests you can trust—all in a pgpm workspace.

Introducing Modular Postgres: Announcing pgpm

Dec 17, 2025

Introducing pgpm and a new category: Modular Postgres. Build composable, application-layer database modules that can be installed from npm, tested in CI/CD, and deployed with idempotent migrations and automatic dependency resolution.

Introducing Constructive — A Trusted Open-Source Platform Built to Last

Dec 11, 2025

After a decade of building open-source database tools used by Supabase, Binance, and platforms with billions in enterprise value, we're unifying everything under one name: Constructive—a secure-by-design platform for composable Postgres backends.

The Future of Postgres Testing: A Complete End-to-End TypeScript Approach with pgsql-test

Nov 24, 2025

Discover how pgsql-test brings TypeScript-native testing to Postgres with ephemeral databases, instant feedback loops, and powerful RLS testing capabilities. Making database testing feel as smooth as testing your frontend code.

Build Safer Supabase Apps with supabase-test

Nov 20, 2025

Unlock faster Supabase development with instant test feedback, modular workflows, and reliable RLS validation. Explore Constructive's new supabase-test library, example test harness, and tutorials for building secure, high-velocity Postgres apps.

KubernetesJS: The React Moment for Cloud Infrastructure

Jul 16, 2025

Introducing KubernetesJS, a fully typed TypeScript client that replaces YAML and Helm with real code. Learn how this revolutionary tool brings React-like composability to Kubernetes, enables browser-based infrastructure management, and transforms DevOps with testable, modular infrastructure components. Discover why this is the React moment for cloud infrastructure.