Crunchy Data joins Snowflake. Read the announcement
Craig Kerstiens
Craig Kerstiens
Postgres is an awesome database for a lot of reasons, put simply it's a really feature rich, powerful, and reliable database. One of those rich areas is the many built-in functions in Postgres. Let's take a look at a few of my favorites. First, let's start with one of the most simple built-in ones but when doing things with time is quite handy. Want to know what time it is according to your database? Want to know the biggest date in your data? Now let's look at one that is a little bit more int...
Read MoreCraig Kerstiens
Craig Kerstiens
Today I'm excited to introduce a new place for devs to polish their Postgres skills, a Postgres Playground and Tutorials from Crunchy Data. What is the playground? Put simply it is: 1. Postgres running in your local web browser 2. With canned datasets you can load 3. Guided tutorials to follow along to learn about the power of Postgres Postgres running in your local web browser With canned datasets you can load Guided tutorials to follow along to learn about the power of Postgres Wait?!?!? Pos...
Read MoreCraig Kerstiens
Craig Kerstiens
Today, I'm excited to announce the public beta of Postgres Container Apps for your Postgres databases on Crunchy Bridge. 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. Let's take an immediate look of how we can spin up a Postgres featureserv: It's as simple as that, and now I can connect directly to my pg_featureserv at: http://p.3fqs3ruv2vfq3malzedvtog4xq.db.postgresbri...
Read MoreCraig Kerstiens
Craig Kerstiens
It's been a busy year building Crunchy Bridge and we've shipped a lot of new awesome things. Instead of doing a wrap-up of all the growth and exciting features, instead I wanted to take the time to try to teach a few more things to those that follow us. While onboarding customer after customer this year I've noted a few key things everyone should put in place right away - to either improve the health of your database or to save yourself from a bad day. Long running (usually unintentionally so)...
Read MoreCraig Kerstiens
Craig Kerstiens
Whether you are starting a new development project, launching an application modernization effort, or engaging in digital transformation, chances are you are evaluating Kubernetes. If you selected Kubernetes, chances are you will ultimately need a database . While many have success with Kubernetes-native database deployments, others prefer the benefits of a managed database. When it comes to databases, at Crunchy Data we believe the answer is more often than not Postgres, and the question is h...
Read MoreCraig Kerstiens
Craig Kerstiens
Many years ago a group of colleagues and I latched onto this idea of flow and what it means for developer experiences. Flow was one of those things that was always hard to measure, but you could tell when it was right or wrong. It wasn’t about KPIs or deploy metrics, but it was about the overall efficiency of the process. A big part of flow when it came to DX was a great CLI experience. A great CLI is intuitive, it allows you to work efficiently while building on simplicity. A great CLI can be...
Read MoreCraig Kerstiens
Craig Kerstiens
It's been a little over a year since we launched Crunchy Bridge. We've been busy over the past year, focusing on the foundations of Crunchy Bridge , ensuring solid resiliency, reducing our high availability failover times, making upgrades seamless and smooth. There has been a lot of activity over the past few months so we thought it was time for an update. Consider this the first of many more to come on what we're up to. First, a little on how we think about Postgres and databases in general....
Read MoreCraig Kerstiens
Craig Kerstiens
A lot of years Postgres will have some big pillar or theme to the release. Often this is thought of after the fact. Everything that is committed is looked at and someone thinks, "This is the key thing to talk about." In Postgres 9.2 it was JSON , in 9.4 it was JSONB, in 10 it was logical replication , 12 was a broader performance theme. While I look forward to each of these big highlights, in each release I'm equally excited to browse through and pull out the small things that simply make my l...
Read MoreCraig Kerstiens
Craig Kerstiens
Postgres has had " JSON " support for nearly 10 years now. I put in quotes because well, 10 years ago when we announced JSON support we kinda cheated. We validated JSON was valid and then put it into a standard text field. Two years later in 2014 with Postgres 9.4 we got more proper JSON support with the datatype. My colleague @will likes to state that the B stands for better. In Postgres 14, the JSONB support is indeed getting way better. I'll get into this small but pretty incredible cha...
Read MoreCraig Kerstiens
Craig Kerstiens
Reality is messy, and for every, "We've standardized on cloud Amazon, Azure, or GCP" announcement, there are tens or hundreds of apps hidden within an organization running on the "other" cloud. Most workloads don't span across clouds, but every large organization has workloads on each cloud vendor. And for everyone's favorite database (Postgres) we're excited to say you don't have to compromise quality when it comes to which cloud vendor you're running on. Today we're announcing Crunchy Bridge...
Read More