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.
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.
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.
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.
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.
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.
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.
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.
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.
Learn how to do percentage calculations in one-pass. Sample data and queries for basic use of window functions.
PGO now supports streaming replication between clusters which can be used for disaster recovery or cloud migration. Read about how to set up streaming replication in a declarative cloud-native way. This example includes code samples for setting up two clusters, one in EKS, and one in GKE.
Connection pooling with pgBouncer is great. For some our customers with high transaction loads, we can run multiple PgBouncers. Read about running multiple connection poolers and how we approach scaling out this part of your infrastructure.
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
Get under the hood of the Crunchy Bridge platform. We dig into some of the development codebase with Ruby, Sorbet, Parlour, and the Sequel ORM. Read about why we’re using these tools and what they bring to the table for the long term.