Announcing Postgres Container Apps: Easy Deploy Postgres Apps
We're very 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.
PostGIS for Newbies
The PostGIS community is 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.
PostGIS vs GPU: Performance and Spatial Joins
Paul Ramsey compares using GPUs for common spatial analysis tasks to a conventional environment like PostGIS. Follow along as he dives into some examples and explores the differences.
CQL Filtering in pg_featureserv
Recently we added an exciting new capability for pg_featureserv: support forCQL filters. CQL (Common Query Language) is another OGC standard that provides the equivalent of SQL WHERE clauses for web queries. Here we'll describe the powerful new capability it provides.
Spatial Filters in pg_featureserv with CQL
pg_featureserv with CQL attribute and spatial filtering provides a highly effective platform for accessing data over the web. And we're continuing to enhance it with new capabilities to unlock even more of the power of PostGIS and PostgreSQL. In this post we'll show some examples of spatial filtering using CQL with pg_featureserv.
Optimize PostgreSQL Server Performance Through Configuration
It's always recommended that one of the first actions performed once an install of PostgreSQL is completed, would be to tune and configure some high-level settings. Check out this post for valuable guidance on doing so.
Crunchy Data at Upcoming Events
Be sure to stop by the Crunchy Data booth at the following events to meet the team and pick up some awesome swag.
PyCon US, Salt Lake City, Utah
April 27 - May 3, 2022
RailsConf, Portland, Oregon
May 17 - May 19, 2022
