Latest posts
Timezone 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 plpgsql, 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.
13 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 plpgsql 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 readHow to Solve Advent of Code 2022 Using Postgres - Day 3
Day 3 of AOC we have lots of great SQL for organizing a rucksack. Postgres solutions for this one include functions for length(), left(), right(), regexp_replace(), COLLATE commands, window function lag(), and more.
7 min readHow to Solve Advent of Code 2022 Using Postgres - Day 2
Day 2 of AOC we have sql for transforming raw data into game analysis of paper, rock, scissors. Included is a nice custom function and great examples for IF/ELSE, CTEs, and more.
10 min readHow to Solve Advent of Code 2022 Using Postgres - Day 1
Greg is doing the Advent of Code using PostgreSQL and he is going to share a few of his tricks. Day 1 he uses file_fdw to connect to the text file provided. Along with a couple grouping and sum queries, he has a quick solution for you.
4 min readPostgres support for JSON is 10 years old!
JSON in Postgres is now 10 years old. Chris recently published a JSON tutorial and offers some thoughts on the past and future of JSON, and what developers need to be aware of.
5 min readEnums vs Check Constraints in Postgres
Enums or check constraints, which one is better? Craig breaks down why enumerated types aren’t common in Postgres.
3 min readPostGIS Day 2022
Catch up on what’s happening in the open source geospatial world with an overview of the PostGIS Day 2022 talks and videos.
Postgres Strings to Arrays and Back Again
Time to have some fun with strings and arrays. Learn how to separate strings into arrays, find array size, and turn comma separated lists into individual rows.
4 min readPercentage Calculations Using Postgres Window Functions
Learn how to do percentage calculations in one-pass. Sample data and queries for basic use of window functions.
3 min readPostgres Query Boost: Using ANY Instead of IN
Let’s show some love for the ANY Operator! Read about how to use = ANY(array) in place of the IN(list) so you can send all your parameters securely with prepared statements.
4 min read
