Latest posts
Writing Data from Postgres to MongoDB
Chris has some sample code for synching data from Postgres to MongoDB using Foreign Data Wrappers and Triggers.
7 min readFun with PostgreSQL puzzles: Finding shortest paths and travel costs with functions
Greg is still working on some of the puzzles in the Advent of Code series. In this one he tackles some routes, shortest paths, and cost. These are great sample PostgreSQL functions withs some bonus tips on using pg_stat_user_functions to look at recursion.
22 min readPostgreSQL Unlogged Sequences - Look Mum, no WAL!
New in Postgres 15, sequences can be unlogged. Greg reviews unlogged sequences and provides some details about using them.
9 min readEasy Mongo from your Postgres
To continue to provide developers with the best Postgres experience, Crunchy Bridge now offers easy connectivity between managed Postgres and MongoDB.
4 min readIs your Postgres ready for production?
Craig gets you ready for production with this quick checklist of Postgres essentials.
5 min readEasy PostgreSQL Time Bins
Paul has some fast and easy tricks to show you how to get time series data into nice reportable data charts. Using functions like floor(), generate_series(), width_bucket(), and date_bin() you can bin your data in groups any way you like and retrieve charts in a flash.
7 min readIntroduction to Postgres Backups
A high level overview of the backup options in Postgres. Including pg_dump, pg_basebackup, and pgBackRest.
9 min readThe Integer at the End of the Universe: Integer Overflow in Postgres
Integer overflow can happen if you have a sequencing data type exceeding integer limits. Jesse has a query to help you spot it and recommendations for a short term and long term fix.
7 min readGeocoding with Web APIs in Postgres
Jacob walks you through the steps on how to set up a geocoder with the US census geocoding API inside your database with a plpython function and triggers.
3 min readPostgres Raster Query Basics
Paul takes us through how rasters are stored and queried in Postgres/PostGIS. He gives us the must have tips for dealing with rasters inside a database using digital elevation mode (DEM) examples.
6 min readWhat's Postgres Got To Do With AI?
Chris is cooking up some examples for us on how to use AI inside Postgres. We have a simple demo of using pgvector and Open AI to grab relationships and query for other similar items.
7 min readPostgreSQL Unlogged Tables - Look Ma, No WAL!
Unlogged tables in Postgres can give you a big performance improvement but beware of the drawbacks. Here are some tips on how to safely give it a try.
11 min readPostgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_wal_switch.
7 min readTemporal Filtering in pg_featureserv with CQL
Dive into some examples of temporal filtering in pg_featureserv.
6 min readExposing Postgres Performance Secrets
Craig lays out four basic things to set up today to make finding and fixing performance faster in the future.
3 min readPostgres GitOps with Argo and Kubernetes
Curious about using Argo for application and database maintenance? Bob takes us through how to set up Argo with Crunchy Postgres for Kubernetes. The end results are some easy and simple GitOps for everyday tasks.
11 min readSQL Tricks for More Effective CRUD
Level up your SQL skills with this quick tutorial of some simple and not-so-simple create, read, update, and delete (CRUD) statements.
7 min readHow to Solve Advent of Code 2022 Using Postgres - Day 15
Day 15 of AOC we have new hands on SQL for the Beacon Exclusion Zone. This one uses CTEs, sequences, regexp_substr() / regexp_match(), int4range, range_agg(), and an upsert.
18 min readUsing Postgres FILTER
Craig dives into using FILTER and shows a query example using CTEs, CASE WHEN, and FILTER.
5 min readWill Postgres Use My Index? Hypothetical Indexing for Postgres
HypoPG is an extension to create hypothetical indexes and test if Postgres will use them. We think this tool is a good one to use in combination with our other favorites like EXPLAIN and pg_stat_statements.
3 min read
