Latest posts
How 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 readMulti-Cloud Strategies with Crunchy Postgres for Kubernetes
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.
5 min readPostgres at Scale: Running Multiple PgBouncers
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.
Security and Team Management in Crunchy Bridge
Crunchy Bridge has a suite of features for managing teams, auditing team actions, data isolation, and single sign on. Read on about our approach to data safety and team management.
5 min readPostgres Insider Terminology
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.
7 min readCrunchy Bridge's Ruby Backend: Sorbet, Tapioca, and Parlour-Generated Type Stubs
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.
11 min readData Loading in Postgres for Newbies
This post covers many ways to get data in Postgres including csv, json, backup files, foreign data wrappers, and generating data with queries. Examples include simple steps you can copy and reuse.
Postgres Databases and Schemas
Instances, database, and schemas are all ways to talk about your database. We have a deep dive into understanding these core fundamentals and what they really mean.
5 min readEasier Upgrades and Image Management for Postgres in Kubernetes
We are showing off some of the newest features in Crunchy PostgreSQL for Kubernetes and related images. Learn how to upgrade Postgres minor and major versions and even pause the upgrade in process.
7 min readMoving Objects and Geofencing with Postgres & PostGIS
A hands on demonstration for building real-time maps and geofences for moving objects. We will use the newly announced pg_enventserv for eventing along with pg_featureserv for a web API to build a fully functional web application.
5 min readMaking Postgres More Affordable - New Low Cost Plans on Crunchy Bridge
We’re excited to announce our new hobby plans. Postgres instances now start at $10 per month. No charges for $5 or less a month. Get started on Crunchy Bridge today.
3 min readA Look at Postgres 15: MERGE Command with Examples
We’re excited about the MERGE command in PostgreSQL 15. We have some ideas about using it for data loading with an example use case for remote sensors.
4 min readBe Ready! Public schema changes in Postgres 15
Big changes are coming to the public schema settings in Postgres 15. There is no more global write privilege to public. Paul breaks down best practices on how to easily give permissions by role.
4 min read
