PostGIS Day is Nov. 21, full schedule and registration are open!

Join Us for PostGIS Day Nov 21

This free, virtual community event serves to highlight the features and uses of the PostGIS spatial database as a part of the GIS ecosystem. We have a full day of talks lined up so check out the schedule and don't forget to register!

WHAT'S NEW

pg_parquet: An Extension to Connect Postgres and Parquet

We’re excited to release pg_parquet - an open source Postgres extension for working with Parquet files. The extension reads and writes parquet files to local disk or to S3 natively from Postgres.

Convert JSON into Columns and Rows with JSON_TABLE

Postgres 17 added another huge JSON feature to its growing repository of strong JSON support with the JSON_TABLE feature. JSON_TABLE lets you query JSON and display and query data like it is native relational SQL. So you can easily take JSON data feeds and work with it like you would any other Postgres data in your database.

Crunchy Postgres for Kubernetes 5.7: Faster Backups, Automated Snapshots, Postgres 17 and More

We are excited to announce the release of Crunchy Postgres for Kubernetes 5.7! This latest version brings a wealth of new features and enhancements designed to make your Postgres deployments on Kubernetes more flexible, efficient, secure, and robust than ever before.

4 Ways to Create Date Bins in Postgres: interval, date_trunc, extract, and to_char

You followed all the best practices, your sales dates are stored in perfect timestamp format, but now you need to get reports by day, weeks, quarters, and months. You need to bin, bucket, and roll up sales data in easy to view reports. Do you need a BI tool? Not yet actually. Your Postgres database has hundreds of functions that let you query data analytics by date.

Enhanced Postgres Release Notes

There is something new you may not have seen in the release notes for Postgres 17. No, not a new feature, I mean inside the actual release notes themselves! The Postgres project uses the git program to track commits to the project, and now each item in the release notes has a link to the actual commit (or multiple commits) that enabled it.

EVENTS

Crunchy Data Events Page

unsubscribe manage preferences

Join Us for PostGIS Day Nov 21

WHAT'S NEW

pg_parquet: An Extension to Connect Postgres and Parquet

Convert JSON into Columns and Rows with JSON_TABLE

Crunchy Postgres for Kubernetes 5.7: Faster Backups, Automated Snapshots, Postgres 17 and More

4 Ways to Create Date Bins in Postgres: interval, date_trunc, extract, and to_char

Enhanced Postgres Release Notes

EVENTS

KubeCon NA

Red Hat Government Symposium

Red Hat Summit: Connect 2024

PostGIS Day 2024

PyLadiesCon