Engineering posts about PostgreSQL
Curated summaries and key learnings for engineers working with PostgreSQL.
Take your PostgreSQL-backed apps to the next level
The article explores the capabilities of PostgreSQL as a robust database engine, particularly within the Microsoft ecosystem. It emphasizes the integration of PostgreSQL with Azure services,...
Faster Queries and New Capabilities with the Open-Source Databricks JDBC Driver
The article outlines significant enhancements to the open-source Databricks JDBC driver, emphasizing improved performance with up to 30% faster large result retrieval compared to the legacy driver....
How lakebase architecture delivers 5x faster Postgres writes
The article discusses the lakebase architecture, which separates compute and storage to enhance Postgres performance significantly. By decoupling these layers, the architecture eliminates traditional...
PGKeeper: Building the bouncer we needed for Postgres
The article details the creation of PGKeeper, a custom connection and load management service designed to replace PgBouncer for PostgreSQL at Figma. As Figma's database workload increased, the...
Inside one of the first production deployments of Lakebase: LangGuard's agentic workflow governance engine
The article explores the production deployment of LangGuard's agentic workflow governance engine, which addresses the challenges of safely scaling autonomous AI agents in enterprises. It highlights...
Operational databases: How they work and when to use them
Operational databases, also known as online transaction processing (OLTP) databases, are essential for processing real-time transactions that support daily business operations. They are designed for...
Take Control: Customer-Managed Keys for Lakebase Postgres
The article discusses Lakebase Customer-Managed Keys (CMK), which empower customers to control their encryption keys using their own cloud Key Management Services (KMS) rather than relying on...
Snap Cloud: A Backend for Spectacles, Powered by Supabase
Snap Cloud is a backend platform designed specifically for Spectacles developers, leveraging Supabase to provide essential backend services such as databases, file storage, and real-time...
What is pgvector?
pgvector is an open-source PostgreSQL extension designed to facilitate vector storage and similarity search directly within Postgres, eliminating the need for separate vector databases for AI...
Deploy Postgres and MySQL databases with PlanetScale + Workers
This article discusses the integration of PlanetScale databases with Cloudflare Workers, allowing developers to deploy Postgres and MySQL databases directly through the Cloudflare dashboard. It...
Take your PostgreSQL-backed apps to the next level
This article explores the integration of PostgreSQL with Microsoft Azure, emphasizing its capabilities for building robust applications. It highlights the PostgreSQL Like a Pro video series, which...
Database Branching in Postgres: Git-Style Workflows with Databricks Lakebase
The article presents an innovative approach to database management through the concept of database branching in Databricks Lakebase Postgres. This technique utilizes copy-on-write storage to create...
How agentic software development will change databases
The article explores the transformative effects of agentic software development on database systems, emphasizing the shift from traditional development practices to a rapid, evolutionary approach...
Deploy Smarter with AI: Introducing App Platform Skills on DigitalOcean
The article introduces App Platform Skills, a set of AI-native playbooks designed to enhance AI coding assistants' capabilities in deploying applications to DigitalOcean's App Platform. By...
Azure Databricks Lakebase is Generally Available
Azure Databricks Lakebase is a managed, serverless PostgreSQL service designed to enhance data architecture by integrating operational capabilities directly into the lakehouse environment on Azure....
Supabase Template is Now Available on DigitalOcean App Platform
The article announces the availability of a Supabase template on DigitalOcean App Platform, enabling developers to deploy a complete backend solution with minimal effort. Supabase serves as an...