Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Jean-Paul Argudo
Jean-Paul Argudo
With PostgreSQL 15 comes a new SQL Command called MERGE . has been in the SQL standard for quite a while, but it just made its way into the PostgreSQL codebase. Prior to , if you wanted to refresh a target table from a source table , prior to Postgres 15, you could use the "upsert" method with the clause . Now, can be used instead! Some situations where makes a lot of sense are: • data loading from external sources, thru foreign data wrappers • staged and batched process jobs data l...
Read MorePaul Ramsey
Paul Ramsey
The end is nigh! PostgreSQL has substantially tightened restrictions on the use of the "public" schema. Here, a standard login user (not superuser) tries to make a table, as one does: NoooO! Why can I not write a table into public? For developers and experimenters, one of the long-time joys of PostgreSQL has been the free-and-easy security policy that PostgreSQL has shipped with for the "public" schema. • "public" is in the default , so you can always find things in it; and, • any user can cr...
Read MoreJean-Paul Argudo
Jean-Paul Argudo
With Crunchy Data's focus on Postgres we often talk with people that are looking to reduce their dependency on other databases and modernize their data stack. A big portion of that is migrating and building new apps on Postgres . One common tool in migration from an Oracle database is Orafce which imitates many Oracle functions inside PostgreSQL. Using a tool like Orafce can assist greatly with the migration process. Long term, however, it is likely good practice to slowly refactor your appli...
Read MorePaul Ramsey
Paul Ramsey
By combining triggers, the PostgreSQL system, and the pg_eventserv service, you can build a real-time application that keeps your web application state perfectly in sync with your database state. pg_eventserv converts events from the PostgreSQL event bus to standard WebSockets messages that any web client can handle. For multi-user real-time applications (like a fleet tracker, or auction system, for example), this setup can be a boon! The database is the central source-of-truth, and all ap...
Read MoreDouglas Hunley
Douglas Hunley
We are excited to announce some big improvements for Crunchy Postgres for you available today. Crunchy Postgres provides everything you need for production ready Postgres in an opinionated distribution built fully on open source, upstream Postgres. Crunchy Postgres powered by our automation provides simple provisioning, backups, high availability, monitoring, and more. Existing Crunchy customers can download this from our Customer Access Portal today. If you’re not using Crunchy Postgres yet...
Read MoreCraig 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 MoreDavid Christensen
David Christensen
At Crunchy we talk a lot about memory, shared buffers, and cache hit ratios. Even our new playground tutorials can help users learn about memory usage. The gist of many of those conversations is that you want to have most of your frequently accessed data in the memory pool closest to the database, the shared buffer cache. There's a lot more to the data flow of an application using Postgres than that. There could be application-level poolers and Redis caches in front of the database. Even on th...
Read MorePaul Ramsey
Paul Ramsey
Ha ha, made you look! This post is not a crazy scam (you be the judge) but just a practical description of using cryptographical algorithms to encrypt and decrypt data inside PostgreSQL. There's already a lot of encryption in Crunchy Bridge ! First, your data are "encrypted at rest". That means that the "volumes" (what in an earlier era would be called the disk drives) your data is saved to are encrypted. Also all the backup files generated by your server are encrypted. In practice, this means...
Read MoreGreg Nokes
Greg Nokes
We are excited to announce the release of Crunchy Postgres for Kubernetes version 5.2. We have been hard at work on a lot of new features we cannot wait to get into your hands. You can get started on version 5.2 from our container portal or the get started tutorial . We have decided to highlight a few of our favorite features today. First, we are very excited to release the first iteration of our CLI for PGO v5, . Our CLI is designed as a plugin. You can get it here and you can use it...
Read MoreJesse Soyland
Jesse Soyland
At Crunchy Data we spend a lot of time helping customers migrate their databases. Migrating Postgres tends to be a very straightforward process. Yet there can still be a few gotchas that can catch you off-guard if you are not prepared to deal with them. From some recent experiences with customers migrating to Crunchy Bridge we found most customers had not considered the underlying collations. These customers ran a risk of data corruption by not handling collation review and updates as part of...
Read More