Latest posts
Deploy PostgreSQL With TLS in Kubernetes
Secure communication for your Postgres clusters in Kubernetes by deploying them with TLS. Learn about the different TLS modes that PostgreSQL offers!
7 min read
Production PostGIS Vector Tiles: Caching
Building maps that use dynamic tiles from the database is a lot of fun. You get the freshest data, you don't have to think about generating a static tile set, and you can do it with very minimal middleware, using pg_tileserv.
3 min read
Postgres: The Friendly Relational Member of Your Data Management Toolbox
The recent selection of Postgres as the "Database of the Year" for the third time in four years is by no means an overnight success story, but is well deserved recognition for a database decades in the making. As organizations look for the relational database of the future, Postgres is ready and waiting. We are proud to be among the leading contributors and supporters of this important movement.
3 min read
R Predictive Analytics in Data Science Work using PostgreSQL
Today we are going to finish up by showing how to use that stored model to make predictions on new data. By the way, I did all of the Postgres work for the entire blog series in Crunchy Bridge. I wanted to focus on the data and code and not on how to run PostgreSQL.
8 min read
Announcing the Crunchy Data PostgreSQL Security Technical Implementation Guide
Crunchy Data is pleased to announce the publication of the Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) by the United States Defense Information Systems Agency (DISA). PostgreSQL was the first open source database to provide a published STIG, and Crunchy Data is proud to update and improve the STIG as PostgreSQL continues to advance and evolve.
3 min read
Crunchy Data PostgreSQL Security Technical Implementation Guide Now Available
This new guide is the result of ongoing collaboration with DISA and provides security guidance for PostgreSQL 9.6 through 12
3 min read
Using R in Postgres for Logistic Regression Modeling
Greetings friends! We have finally come to the point in the Postgres for Data Science series where we are not doing data preparation. Today we are going to do modeling and prediction of fire occurrence given weather parameters… IN OUR DATABASE!
8 min read
Loading Data into PostGIS: An Overview
There are a lot of ways to load data into a PostgreSQL/PostGIS database and it's no different with spatial data. If you're new to PostGIS, you've come to the right place. In this blog post, I'll outline a few free, open source tools you can use for your spatial data import needs.
8 min read
PostgreSQL 13 Benchmark: Memory Speed vs. TPS
Today I'm changing the memory speed on my main test system, going from 2133MHz to 3200MHz, and measuring how that impacts PostgreSQL SELECT results. I'm seeing a 3% gain on this server, but as always with databases that's only on a narrow set of in-memory use cases.
5 min read
Postgres Views with Django: A Quick Demo
In this series so far we've talked about how to get our Django application to save uploaded images as bytea in Postgres. We've also walked through an example of a PL/Python function that processes the binary data to apply a blur filter to the uploaded image. Now, we'll show how to retrieve the blurred image from Django.
4 min read
Postgres, PL/Python and SciPy/NumPy for Processing Images
I recently wrote about building a Django app that stores uploaded image files in bytea format in PostgreSQL. For the second post in this series, we're now going to take a look at applying a blur filter to the uploaded image using PL/Python.
7 min read
Active-Active PostgreSQL Federation on Kubernetes
Learn how to deploy an out-of-the-box multi-master PostgreSQL solution to federate your data on Kubernetes with the Postgres Operator.
15 min read
PostGIS Raster and Crunchy Bridge
The PostGIS raster has a steep learning curve, but it opens up some unique possibilities for data analysis and accessing non-standard data from within PostgreSQL. Here's an example that shows how to access raster data from PostGIS running on Crunchy Bridge.
11 min read
Using the Postgres bytea Type with Django
How about a simple image upload app built with Django 3.1 andbacked by PostgreSQL 13, that takes advantage of the PL/Python procedural language for processing?
9 min read
Using Pl/pgSQL to Calculate New Postgres Columns
In our last blog post on using Postgres for statistics, I covered some of the decisions on how to handle calculated columns in PostgreSQL. I chose to go with adding extra columns to the same table and inserting the calculated values into these new columns. Today’s post is going to cover how to implement this solution using Pl/pgSQL.
8 min read
Waiting for PostGIS 3.1: GEOS 3.9
While we talk about "PostGIS" like it's one thing, it's actually the collection of a number of specialized geospatial libraries, along with a bunch of code of its own.
4 min read
Replacing Lines of Code with 2 Little Regexs in Postgres
For those of you who have a bad taste in your mouth from earlier run-ins with regexs, this will be more use case focused and I will do my best to explain the search patterns I used.
7 min read
PostGIS Day 2020 Roundup
Crunchy Data's second annual PostGIS Day took place a couple weeks ago on November 19th, and as a first-time attendee I was blown away by the knowledge-sharing and sense of community that I saw, even as I was tuning in remotely from my computer at home.
7 min read
Using Postgres for Statistics: Centering and Standardizing Data
Today we are going to examine methods for calculating z-scores for our data in the database. We want to do this transformation because, when we carry out logistic regression we want to be able to compare the effects of the different factors on fire probability.
8 min read
Postgres: The batteries included database
Today you don’t need a reason for choosing Postgres, if you do all your answers are above. Today the question has really shifted to what are you not using Postgres for, and how can the community better support that happening natively in Postgres in the future.
8 min read
