---
title: Postgres Constraints for Newbies, Safer Application Users in Postgres and more.  
---

Your monthly dose of top Postgres content from your friends at Crunchy Data

| View in browser 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 Crunchy Data, 162 Seven Farms Drive, Suite 220, Charleston, SC 29492, 843-737-6045 Unsubscribe Manage preferences |
| --- |