Posts about Analytics
Window Functions for Data Analysis with Postgres
Elizabeth has some sample queries and explanations for window functions like running totals, lag/lead, rolling averages, and more.
PostGIS meets DuckDB: Crunchy Bridge for Analytics goes Spatial
We have just added spatial features to Crunchy Bridge for Analytics. Marco has all the details about how to get public or private data into PostGIS.
8 min readPostgres Materialized Views from Parquet in S3 with Zero ETL
Marco breaks down how to pull Parquet, JSON, and CSV files into Postgres with materialized views. This workflow can be used as a simple data pipeline from object store directly into Postgres for a variety of use cases.
4 min readPostgres Powered by DuckDB: The Modern Data Stack in a Box
Marco reviews the challenges and strengths of analytical and transactional workloads and what a modern data stack that merges the two might look like.
12 min readQuery Hugging Face Datasets from Postgres
Crunchy Bridge for Analytics now lets you automatically connect your database with Hugging Face. Elizabeth walks through an example with the IMDB data.
Running TPC-H Queries on Iceberg Tables from PostgreSQL
Önder walks through how to run TPC-H queries for benchmarking data warehouse workloads against Iceberg tables using Crunchy Bridge for Analytics.
6 min readCrunchy Bridge Adds Iceberg to Postgres & Powerful Analytics Features
Query Iceberg tables, list all of your S3 files, connect to a Hugging Face training set, and more. Marco digs in with the details on our newest release of Crunchy Bridge for Analytics.
11 min readHow We Fused DuckDB into Postgres with Crunchy Bridge for Analytics
Marco reveals some of the components behind Crunchy Bridge for Analytics, which extends PostgreSQL for high performance analytics workloads using DuckDB.
6 min readSyncing Postgres Partitions to Your Data Lake in Crunchy Bridge for Analytics
Marco shows how you can combine pg_partman and pg_cron on Bridge for Analytics to set up automated time-partitioning with long-term retention and fast analytics in your data lake.
9 min readCrunchy Bridge for Analytics: Your Data Lake in PostgreSQL
Today Crunchy Data announces a new analytics engine to read cloud object storage files like CSV, JSON, and Parquet with Postgres.
10 min read
