Latest posts from Craig Kerstiens
Is your Postgres ready for production?
Craig gets you ready for production with this quick checklist of Postgres essentials.
5 min readExposing Postgres Performance Secrets
Craig lays out four basic things to set up today to make finding and fixing performance faster in the future.
3 min readUsing 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 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 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 readSecurity 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 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 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 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 readLearn Postgres at the Playground
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
3 min read
Announcing Postgres Container Apps: Easy Deploy Postgres Apps
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
6 min readFive Tips For a Healthier Postgres Database in the New Year
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
5 min read
Fully Managed Postgres for Kubernetes with Crunchy Bridge
Crunchy Bridge can now be deployed through the new Red Hat OpenShift Database Access (RHODA).
3 min read
Introducing the Crunchy Bridge CLI
We are excited to announce the release of our CLI tool for easy provisioning, instance management, and a new tool called cb scope to get additional insights on your database.
5 min read
Crunchy Bridge: UI Refresh, In-place Upgrades, Postgres 14
A few highlights of the last couple months include an updated front end, in place upgrades, Postgres 14 support, and maintenance windows. Plus a bonus preview of what's coming soon.
4 min read
Postgres 14: It's The Little Things
Today I wanted to call some extra attention to those little things, the ones that don't get the spotlight, but simply make a developer's life better.
5 min read
Better JSON in Postgres with PostgreSQL 14
A feature highlight of the new JSON subscript support within PostgreSQL 14.
5 min read
Announcing Google Cloud Support for Crunchy Bridge
Crunchy Data, the leading provider of trusted open source PostgreSQL, is proud to announce the addition of Google Cloud Platform (GCP) to its list of providers supported on Crunchy Bridge.
4 min read
Your Guide to Connection Management in Postgres
Connection pooling and management is one of those things most people ignore far too long when it comes to their database. As you grow into the hundreds, better connection management is a quick and easy win. Let's dig into the three variations of connection pooling and how to identify if you can benefit from a connection pooler and where.
5 min read
