Discover Blogs
A reference implementation for building Retrieval-Augmented Generation (RAG) pipelines using local LLMs, PostgreSQL, and pgvector. Real embeddings, semantic search, and end-to-end tests you can trust—all in a pgpm workspace.
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.
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.
Discover how pgsql-test brings TypeScript-native testing to PostgreSQL with ephemeral databases, instant feedback loops, and powerful RLS testing capabilities. Making database testing feel as smooth as testing your frontend code.
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.
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.