For years, every serious Haskell PostgreSQL driver has been chained to the same C library - libpq - with no clean way out. I tried to cut it loose twice, and both times I failed at the finish line. They say the third time’s the charm. I hope it will be - not because I’ve tried harder, but because I’ve changed the goal. Read more ›
Connect PostgreSQL and run SQL with built-in AI operators through samtSQL. Read more ›
Recently, I how common polymorphic associations actually are in relational databases — a performance-hostile pattern built around a discriminated foreign key that ORMs (Rails, Django, Hibernate), CRM platforms (Salesforce), and 1C generate automatically. The front page of a typical online store, or the activity feed of a CRM, is built by exactly this kind of query: a base table is LEFT JOIN-ed to every possible subtype through a (type, id) pair of columns.That earlier article answered the que... Read more ›
PostgreSQL 18 finally made extensions truly relocatable by adding `extension_control_path` to match the long-existing `dynamic_library_path`. Read more ›
A real-time order analytics pipeline built on CDC from Postgres to ClickHouse on the Brazilian Ecommerce Dataset - el10savio/ecommrt Read more ›
Analysts say Redmond still has billions of reasons to keep backing its flagship DBMS, even as Azure, Postgres, and AI hog the spotlight Read more ›
Taipei, Taiwan - Sat 20 Jun HypoPG 1.4.3 I'm pleased to announce the release of the version 1.4.3 of HypoPG, an extension adding support for Hypothetical Indexes, compatible with PostgreSQL 9.2 and above. Changelog Bug fixes: Fix long standing Int8GetDatum bugs (Julien Rouhaud) Misc: Add support for PostgreSQL 19 (Julien Rouhaud) Links & Credits Thank to the users who reported bugs, they are all cited in the CHANGELOG file. HypoPG is an open project. Any contribution to build a better tool is... Read more ›
pgAgent has been my go to scheduling solution for quite some time. Sadly in 6 months it will be completely retired and the pgAgent UI in pgAdmin will be gone. The main reasons I liked pgAgent were: Cross Platform: I have a lot on windows and linux customers, so this was important. Nice UI in pgAdmin, so I could do all work with PostgreSQL and schedule things at the same time as well as check status of jobs. The database backend is PostgreSQL, my favorite database Supports Multiple Agents with... Read more ›
Every backend system eventually needs something to run on a schedule. Old sessions need deleting, summary tables need rebuilding, materialized views need refreshing, and maintenance tasks need to happ Read more ›
This is Part 1 of a two-part series covering the key features in PostgreSQL 18. In this post, we focus on performance enhancements: skip scan optimization for multicolumn indexes, enhanced EXPLAIN output, automatic removal of unnecessary self-joins, and several vacuum and autovacuum improvements that help keep your database running efficiently. Read more ›
Our team is excited to announce pgEdge ColdFront v1.0.0-beta1: open-source, transparent data tiering for PostgreSQL that unites OLTP, analytics and AI workloads, with no application code changes required. The headline feature: a fully writable cold tier. Jimmy Angelakos is the lead engineer, and it’s available on .Moving aging data off primary PostgreSQL storage is economically obvious. Keeping it fully operational once it’s there is where things get complicated.The trade-off nobody wants to ... Read more ›
🚀 Create Quick Nest A Quick Setup for NestJS 11 + Prisma 7 + PostgreSQL backend in seconds. The fastest way to start a NestJS + Prisma database project. Skip boilerplate, skip setup start building real features in minutes. Create your project instantly: bunx quick-nest my-app # or npx quick-nest my-app npm/bun pacakge : Your NestJS + Prisma database is ready to go. ✨ Features 🏗️ NestJS 11 — Modern, opinionated Node.js framework 🗄️ Prisma ORM v7 — Type-safe PostgreSQL ORM with auto-migrations ... Read more ›
Instant (InstantDB) is an open-source, real-time backend platform (a self-hosted alternative to Firebase) built around a PostgreSQL store with relational queries, authentication, and live sync. This guide deploys Instant using Docker Compose with PostgreSQL and Traefik for automatic HTTPS. By the end, you'll have Instant serving its backend API securely at your domain. Set Up the Directory Structure 1. Create the project directory and clone Instant: $ mkdir ~/instant $ cd ~/instant $ git clon... Read more ›
Discover the top PostgreSQL 19 features, including built-in REPACK CONCURRENTLY, SQL property graph queries (SQL/PGQ), and logical replication updates. Read more ›
For context, this is based on a recent freelance contract in a Django/React TS/React Native codebase size: 20-person team. I have 17 years' experience with w... Read more ›
Embed Everruns harnesses directly in your Rust process with the everruns-runtime crate — in-memory by default, no PostgreSQL, server, or worker required. Read more ›
At PGDay France (2018 or 2019, I honestly can’t remember which one), I shared my method for evaluating a Postgres extension: read the source code, and ask yourself whether you understand it well enough to fix a small bug. Someone in the audience replied: “That’s only valid for Lætitia Avrot.” I’ve been thinking about that comment ever since. It’s not magic. It’s not some rare gift. It’s a method. Read. Understand. Read more ›
U.S. Cybersecurity and Infrastructure Security Agency (CISA) adds Splunk Enterprise flaw to its Known Exploited Vulnerabilities catalog. The U.S. Cybersecurity and Infrastructure Security Agency (CISA) added a Splunk Enterprise flaw, tracked as CVE-2026-20253 (CVSS score of 9.8), to its Known Exploited Vulnerabilities (KEV) catalog. The flaw CVE-2026-20253 is an improper authentication vulnerability in the PostgreSQL sidecar service of […] Read more ›
#653 — June 17, 2026 Web Version Postgres Weekly Scaling Postgres to 226k TPS: A Christmas Day Retrospective — A meaty post-mortem and tactical walkthrough of how a digital photo-frame company went from having its Postgres deployment crash out during the 2024 holiday season to handling 2025 without a hitch. Andrew Atkinson Learn How CERN Runs 40% Faster Queries on 95% Less Storage — CERN's 800+ SCADA systems generate hundreds of GB of time-series data daily. See how their engineers achieved ... Read more ›
Member: TysonPaul | Microsoft Community Hub Triggering Azure Functions from Blob Storage Using Event Grid Team Blog: Core Infrastructure and Security Author: AndrewCoughlin Published: 05/11/2026 Summary: The article explains how to trigger Azure Functions from Blob Storage events using Azure Event Grid for real-time file processing. It outlines a step-by-step approach: create and deploy an Azure Function with an Event Grid trigger, set up an Event Grid subscription for BlobCreated events, and... Read more ›