Logical Replication on Standbys in Postgres 16

Postgres 16 is in beta and we are all excited about the updated logical decoding features. You heard that right, you can now do logical replication from a non-primary database! 

Practical AI with Postgres

Use some of the newest AI tools for Postgres! Craig shows you how to use ChatGPT for schema creation, data creation, query writing, indexing and more.

Building Customer-Facing Real-Time Dashboards with Postgres

Postgres can be a great back end to powering your customer-facing analytics. Craig gives an overview of getting started with a metrics schema and then powering up to performance.

Working with Time in Postgres

A primer on working with time in Postgres. Covers data types, query formats, intervals, overlaps, range types, indexing, and roll ups.

5 Ways to Get Table Creation Information in Postgres

When was this table created? Greg dives into the 5 places where you can get information about Postgres object creation.

Tags and Postgres Arrays, a Purrrfect Combination

Are you using tags in your database with some of your main database properties? Paul reviews some of the ways to store tags in a database from basic relational models to text arrays. 

Tweets-02

 

SVG Images from Postgres

We are excited to announce a new set of functions to generate svgs from Postgres and PostGIS! This gives you really easy maps, images, or charts directly from your database. 

High-compression Metrics Storage with Postgres Hyperloglog

Hyperloglog is a Postgres extension for doing high-compression storage and query approximations. See how to get started building a metrics system while saving on storage space and query time.

CI/CD with Crunchy Postgres for Kubernetes and Argo

CI/CD tools can help you deploy, test, and promote databases. Bob has a sample set up of using ArgoCD with Crunchy Postgres for Kubernetes. 

pgBackRest File Bundling and Block Incremental Backup

pgBackRest has some new features that allow you to bundle files in your backup repo and do a block incremental storage. 

Remote Access CSV Files from Postgres

Want to get CSV data into your database? Paul has some great tools to help you use CSV and Google Sheets.

banner

Crunchy Data | 843-737-6045 | crunchydata.com

unsubscribe manage preferences