Blog

Discover Blogs

Your Next Database User Won't Be a Human

Oct 14

Your Next Database User Won't Be a Human

Recap of Frontier Research Club #26 at Pebblebed during a16z SF Tech Week, which Constructive co-hosted and sponsored. Zep and the UC Berkeley Sky Computing Lab on what changes when AI agents become users of production databases: memory that knows when it's stale, and data systems built for agents that speculate instead of query.

PGlite + pgpm: End-to-End Postgres Testing in Your Test Runner

Jul 11

PGlite + pgpm: End-to-End Postgres Testing in Your Test Runner

Run real Postgres migrations and tests entirely in-process with PGlite. No server, no Docker, no CI services—just install and test. Explore Constructive's new pglite-test library, reference suite, and hands-on tutorials for fast, secure, services-free Postgres testing.

Software for San Francisco

Jul 7

Software for San Francisco

This summer Illuminate lit up San Francisco with WELCOME on Market Street and 7X7 at Civic Center. We donated our time to build the AwePad, the iPad app that lets anyone paint the lasers.

From Vibe Coding to Agentic Engineering

May 1

From Vibe Coding to Agentic Engineering

Notes from the May 1 panel at SVB Experience Center with DeepMind, Mastra, and Constructive. As AI drives the cost of code toward zero, the bottleneck shifts to trust — and the engineer's job is no longer writing code, it's designing systems that produce code we can rely on.

Putting Postgres in package.json

Apr 30

Putting Postgres in package.json

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.

From Berkeley to AI: Reflections on PostgresConf 2026

Apr 28

From Berkeley to AI: Reflections on PostgresConf 2026

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

Agentic DB: The Open-Source Brain for Your Agents

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

Agent Orchestration Doesn’t Solve Trust

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

Agents Are Probabilistic. Your Business Can’t Be

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

What We Mean by Secure-by-Default Postgres

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

100 Million Downloads

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

Trusted LLM RAG Pipeline: Ollama & Postgres

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 Modular Postgres: Announcing pgpm

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.

Build Safer Supabase Apps with supabase-test

Nov 20, 2025

Build Safer Supabase Apps with supabase-test

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

KubernetesJS: The React Moment for Cloud Infrastructure

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.