PostgresMar 05, 2026Ctrl-C in psql gives me the heebie-jeebiesThere are a few different reasons to hit the brakes on a Postgres query. Maybe it’s taking too long to finish. Maybe you realised you forgot to create an index that will make it orders of magnitude quicker. Maybe there’s some reason the results are no longer needed. Or maybe you,...
PostgresJan 12, 2026Zero-ETL lakehouses for Postgres peopleNeon is made by Postgres people. Since Neon became part of Databricks, we Postgres people also find ourselves part of a larger organisation of enterprise data people. This post is about what I’ve learned as a result. It aims to explain ‘data lakehouses’ and related enterprise dat...
PostgresOct 20, 2025Handling Time-Variant DAGs with Constraints in PostgresManaging dynamically changing directed acyclic graphs (DAGs) with constraints in Postgres enables robust tracking of relationships that evolve over time. At traconiq, this pattern is central to how we manage our vehicle fleet, where trucks and trailers attach and detach constantl...
PostgresSep 26, 2025Implementing a Kalman Filter in Postgres to Smooth GPS DataModern GPS datasets are notoriously noisy satellites drift, buildings scatter signals, and consumer devices introduce frequent errors. When working with millions of position samples from vehicles, smartphones, or IoT devices, this noise makes analysis unreliable. Routes jump, tr....
PostgresSep 24, 2025Introducing Elephantshark, a tool to monitor Postgres network trafficElephantshark helps you monitor, understand and troubleshoot Postgres network traffic that’s Postgres servers, clients, drivers and ORMs talking to Postgres servers, proxies and poolers. Elephantshark sits between the two parties in a Postgres protocol exchange, forwarding messa....
PostgresSep 16, 2025Easier Postgres fine-tuning with online_advisorYou’ve heard this many times before – in order to keep your Postgres database working smoothly, you need to have proper index planning. Too few indexes, and your query performance suffers. Misestimated row counts can also trick the planner into poor choices, and if you’re not usi...
PostgresJul 25, 2025Postgres as Your Platform: Building Event-Driven Systems with Schema ChangesFor years, we’ve built elaborate scaffolding around our databases message queues to broadcast changes, cron jobs to sync schemas, webhooks to notify downstream systems. We needed this scaffolding because Postgres was “just” a database, a place to store rows and run queries. The.....
PostgresJul 14, 2025How to fix missing table errors in pg_cron“Timing is everything.” Some say that’s a quote from Shakespeare, but imho, the true bards of time are the 52 contributors to the pg_cron extension. The concept being pg_cron is simple run scheduled jobs directly within Postgres using familiar cron syntax. The simplicity belies.....
PostgresJul 07, 2025Build Your Own Full-Text Search CMS with Neon and pg_searchA CMS is a “must have” for building a website. And your choices are many. If you want full stack, you can go with WordPress or Webflow. If you want headless, you can go with Sanity or Contentful. Heck, with the aid of a GitHub Action, you can just turn your Notion pages directly....
PostgresJul 02, 2025Neon Joins TanStack: Instant Postgres Integration for Faster JavaScript DevelopmentIt’s no secret that Neon loves TanStack, and we’re proud to support Tanner and the team as they prepare TanStack Start for its much anticipated 1.0 launch. Vite’s popularity is hard to ignore at this point. It’s everywhere! We believe that part of its success is the amazing devel...
