Latest posts from Marco Slot
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 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 readAn Overview of Distributed PostgreSQL Architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
16 min read
