Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Christopher Winslett
Christopher Winslett
For many developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected. Disclaimer : it is okay to break the rules. Sometimes, you may choose to have slow database interactions, because you know they are rare events. Assuming a well-designed database infrastru...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Recently, there has been a bit of a debate here at Crunchy Data around SQL editors. While some members of the Crunchy Team such as Elizabeth ( @e_g_christensen ) prefer pgAdmin 4, others such as Craig (@ craigkerstiens ) prefer using psql . And one the great things about the PostgreSQL ecosystem is that there is no right answer to this debate! Instead, you have choice and flexibility when it comes to finding and using the tools that meet your specific database development and/or management need...
Read MorePaul Ramsey
Paul Ramsey
A couple weeks ago, I came across a blog from Retool on their experience migrating a 4TB database. They put in place some good procedures and managed a successful migration, but the whole experience was complicated by the size of the database. The size of the database was the result of a couple of very large "logging" tables: an edit log and an audit log. The thing about log tables is, they don't change much. They are append-only by design. They are also queried fairly irregularly, and the qu...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Whether upgrading PGO itself, or upgrading the PostgreSQL databases PGO manages, seamless upgrades should be a core feature for any cloud or Kubernetes-based database solution. As a result, one of the goals when we set out to build version five of PGO, the Postgres Operator from Crunchy Data, was to provide a seamless and user-friendly upgrade experience. Today we’re excited to introduce support for major version PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessl...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
A colleague of mine recently tweeted the following, highlighting the challenges often associated with database upgrades: Last week had 3 calls before noon of people having difficulty with database upgrades and connection scaling. Two things that should be staples for a database provider and they had no idea until 6 months in when they tried to upgrade. As an industry we can build better. — Craig Kerstiens (@craigkerstiens) March 28, 2022 When I saw that tweet, I couldn’t help but appreciate the...
Read MoreElizabeth Christensen
Elizabeth Christensen
PostGIS is one of the most awesome extensions for PostgreSQL and can turn a relational database into a really powerful GIS ( Geographic Information System ). The PostGIS community is really great about documentation and training and this post is aimed at getting you some resources on how to get started with the major components of using PostGIS as a super beginner. I’ll help you get a sample dataset up, import a shape file, and get that all published to a web browser. PostGIS is a Postgres...
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 MoreMartin Davis
Martin Davis
provides access to the powerful spatial database capabilities of PostGIS and PostgreSQL via a lightweight web service. To do this, it implements the OGC API for Features ( OAPIF ) RESTful protocol. OAPIF is part of the Open Geospatial Consortium ( OGC ) OGC API suite of standards. In a previous post, we announced an exciting new capability for : support for CQL filters . CQL ( Common Query Language ) is another OGC standard that provides the equivalent of SQL clauses for web q...
Read MorePaul Ramsey
Paul Ramsey
Every once in a while, a post shows up online about someone using GPUs for common spatial analysis tasks, and I get a burst of techno-enthusiasm. Maybe this is truly the new way! This week it was a post on GPU-assisted spatial joins that caught my eye. In summary, the author took a 9M record set of parking infractions data from Philadelphia and joined it to a 150 record set of Philadelphia neighborhoods . The process involved building up a little execution engine in Python. It was pretty ma...
Read MoreMartin Davis
Martin Davis
The goal of is to provide easy and efficient access to PostGIS from web clients. To do this, it uses the emerging OGC API for Features ( OAPIF ) RESTful protocol. This is a natural fit for systems which need to query and communicate spatial data. The core OAPIF specification provides a basic framework for querying spatial datasets, but it has only limited capability to express filtering subsets of spatial tables. In particular, it only allows filtering on single attribute values, and it...
Read More