Latest posts
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 readOracle to Postgres Post-Migration Improvements
Jean-Paul shows some easy tricks for changing from Orafce functions to native PostgreSQL.
6 min readReal-time Database Events with pg_eventserv
Introducing our newest open-source project, pg_eventserv! pg_eventserv takes events generated by the PostgreSQL NOTIFY command and passes the payload along to waiting WebSockets clients.
5 min readExciting updates for Crunchy Postgres: Enhancements to TLS, Firewall Management, Monitoring and More
We just released a new version of Crunchy Postgres. Packed with security, access management, and monitoring updates. Giving you more flexibility and options for running production Postgres.
4 min readFun With Postgres Functions
Craig has pulled out some of his favorite functions from the Postgres toybox. He shows off date functions, aggregations, text functions, and math.
5 min readPostgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
7 min read
