Latest posts from Craig Kerstiens
Announcing the Scheduler for Crunchy Bridge
Crunchy Bridge has a new feature that lets you create automated cron tasks through our user interface.
1 min readRow Level Security for Tenants in Postgres
Craig shows you how to use Row Level Security to isolate and secure data in a multi-tenant application.
3 min readMigrate from Heroku Postgres to Crunchy Bridge
Craig announces a new tool for automatically migrating Heroku Postgres databases to Crunchy Bridge.
4 min readCrunchy Bridge: Announcing Postgres Insights in Your CLI
Craig announces a suite of useful queries for Postgres in our command line tool. Quickly find cache hit ratio, table sizes, locks, long running queries, indexes, and more in the new query menu for Crunchy Bridge.
5 min readCitus for Postgres on Any Cloud: Announcing Citus Support for Crunchy Bridge
We are now supporting Citus on Crunchy Bridge. Craig walks through how to set it up and what to know before you get started.
3 min readThe Postgres Playground: BYOS (Bring Your Own SQL)
Craig has tips for using our Postgres playground with your own SQL.
2 min readPostgres + Citus + Partman, Your IoT Database
Craig digs into the architecture behind a slick IoT data platform including Postgres, the Citus extension, and pg_partman partitioning. Add these together with columnar compression and you've got a fully open source and scalable IoT data stack.
8 min readDesigning Your Postgres Database for Multi-tenancy
Craig digs into multitenancy applications, sharding, and the Citus extension. He gives several approaches to the data design so that you're ready to scale if and when that time comes.
6 min readWhen Did Postgres Become Cool?
Craig takes a look at the history of Postgres. From the origins of the project through some of the key production features that make Postgres what it is today.
10 min readIntroducing Database Insights: Effortless Postgres Management with Crunchy Bridge
Crunchy Bridge now has database insights to keep track of key performance indicators for your Postgres database. From database tools like slow queries and cache hit ratio, to machine stats like CPU and IOPS, and a production check. We are making database management easier than ever.
2 min readAnnouncing Crunchy Postgres for Kubernetes 5.4
We are excited to release version 5.4 of Crunchy Postgres for Kubernetes with support for ARM processors, pgvector, huge pages, Postgres tablespaces, and more.
5 min readPractical AI with Postgres
Use some of the newest AI tools for Postgres! Craig shows you how to use ChatGPT for schema creation, data creation, query writing, indexing and more.
9 min readBuilding Customer-Facing Real-Time Dashboards with Postgres
Postgres can be a great back end to powering your customer-facing analytics. Craig gives an overview of getting started with a metrics schema and then powering up to performance.
5 min readThinking Fast vs. Slow with Your Data in Postgres
Craig gives us an introduction to working with Postgres in expanded contexts like analytics, metrics, log storage, and event data.
4 min readIs 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 read
