Latest posts
Using 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 readIntro to Postgres Custom Data Types
A quick primer on the two main ways to create custom data types in PostgreSQL - DOMAINs and user-defined custom data types. Get some quick examples and learn which tools are recommended.
Stateful Postgres Storage Using Kubernetes
How can Kubernetes be the foundation of a stateful database? Ben takes us through the basics of Persistent Volumes, Volume Claims, and Postgres storage.
11 min readHow to Solve Advent of Code 2022 Using Postgres - Day 14
Day 14 of AOC we have new hands on SQL for the Distress Signal. This one uses lag(), sequencing, regexp_replace(), and overlay().
10 min readHow to Solve Advent of Code 2022 Using Postgres - Day 13
Day 13 of AOC we have new hands on SQL for the Distress Signal. This one uses lag(), sequencing, regexp_replace(), and overlay().
8 min readHow to Solve Advent of Code 2022 Using Postgres - Day 12
Day 12 of AOC we have new hands on SQL for the Hill Climbing Algorithm. This one uses parsing, an IDENTITY column, functions, and text arrays.
7 min readFun with Letters in PostGIS 3.3!
Check out the new PostGIS function, ST_Letters. We're making words, putting words on a map, increasing convexity with ST_ConcaveHull, and making letters from polygons with ST_TriangulatePolygon.
4 min readHow to Solve Advent of Code 2022 Using Postgres - Day 11
Day 11 of AOC, Greg uses SQL for playing Monkey in the Middle. This one uses sequences, string functions, and window functions.
13 min readTimezone Transformation Using Location Data & PostGIS
Need to convert UTC timestamps to local time and store them? We have a fast way to do this with PostGIS by importing a shape file, doing a quick join, and creating a new local time field.
4 min readHow to Solve Advent of Code 2022 Using Postgres - Day 10
Day 10 of AOC we have new hands on SQL for reading signals. This one uses sequences and the OVER() function.
9 min readHow to Solve Advent of Code 2022 Using Postgres - Day 9
Day 9 of AOC we have new hands on SQL for looking at a rope bridge. This one uses a custom function and colored ASCII art.
11 min readHow to Solve Advent of Code 2022 Using Postgres - Day 8
Day 8 of AOC we have new hands on SQL for reviewing treetop views. This one uses includes PL/pgSQL, row_number window functions, sequences, and regexp_split_to_table.
8 min readCrunchy Postgres for Kubernetes 5.3 Release
Announcing PGO support for Postgres 15, Kubernetes 1.25, IPv6, Helm charts, and more!
3 min readHow to Solve Advent of Code 2022 Using Postgres - Day 7
Day 7 of AOC we have new hands on SQL for reviewing terminal commands. This one uses recursive queries, text arrays and so many functions. Bonus, there are functions for regexp_count, regexp_replace, and regexp_substr which are new in Postgres 15.
13 min readHow to Solve Advent of Code 2022 Using Postgres - Day 6
Day 6 of AOC we have new hands on SQL detecting markers in datastreams. This one uses regexp_split_to_table, strpos, lag() functions and COUNT(DISTINCT). Also, a great example of using a DO function with RAISE NOTICE.
5 min readLog Export Examples Using Crunchy Postgres for Kubernetes
Using sidecars you can export Postgres logs a few different ways. Bob has some examples for exports including sending errors to stderr, stdout, and S3.
14 min readHow to Solve Advent of Code 2022 Using Postgres - Day 5
Day 5 of AOC we have new hands on SQL for helping stack crates. There are some cool PL/pgSQL for moving things around. Plus generate_series(), upsert ON CONFLICT, and backwards sequencing.
13 min readHow to Solve Advent of Code 2022 Using Postgres - Day 4
Day 4 of AOC we have new hands on SQL for helping the Elves cleaning up camp. Postgres solutions include the function split_part(), the int4range data type, and range operators.
5 min readPostgres + Tailscale – A database you can trust with a simple VPN
We are excited to announce that Crunchy Bridge has integrated with Tailscale to provide easy and secure access to your database from any of your devices.
3 min read
