Articles by plaur782
2

Sqlfmt: An SQL gofmt-style formatter (tapoueh.org)

4

Approximations and Sampling in Postgres (snowflake.com)

2

How we pushed CDC into Postgres, and turned replication into clockwork (snowflake.com)

3

TQuel Paper: Implementing Temporal Operators in Postgres (illuminatedcomputing.com)

1

Looking Ahead to Postgres 19 (snowflake.com)

2

The PostgreSQL C Dialect (postgresql.org)

3

Looking Ahead to Postgres 19 (snowflake.com)

2

British Columbia, Time Zones, and Postgres (crunchydata.com)

2

The Minimum Viable Unit of Saleable Software (brandur.org)

1

Pg_lake: Integrate Your Data Lakehouse with Postgres (snowflake.com)

1

Postgres Internals Hiding in Plain Sight (crunchydata.com)

1

Incremental Data Processing in PostgreSQL (github.com/crunchydata)

128

Pg_lake: Postgres with Iceberg and data lake access (github.com/snowflake-labs)

2

Postgres Logging for Performance Optimization (crunchydata.com)

2

Logical Replication from Postgres to Iceberg (crunchydata.com)

1

Creating Histograms with Postgres (crunchydata.com)

1

Transforming Data with DuckDB and Dbt (duckdb.org)

2

Maximizing Your Delta Scan Performance (duckdb.org)

3

Automatic Iceberg Maintenance Within Postgres (crunchydata.com)

2

Parquet Bloom Filters in DuckDB (duckdb.org)

1

Postgres, Dbt, and Iceberg: Scalable Data Transformation (crunchydata.com)

1

PgBouncer is useful, important, and fraught with peril (jpcamara.com)

3

Postgres Compatability Index (drunkdba.medium.com)

1

Incremental Archival from Postgres to Parquet for Analytics (crunchydata.com)

2

Geoparquet 2.0: Going Native (cloudnativegeo.org)

22

Scaling with PostgreSQL without boiling the ocean (shayon.dev)

1

Best place to learn to use PostgreSQL (visualmode.dev)

1

Running TPC-H SF300 on a Raspberry Pi (duckdb.org)

2

Using DuckDB's Hilbert Function with GeoParquet (cholmes.medium.com)

124

PostgreSQL is the Database Management System of the Year 2024 (db-engines.com)

1

Database Trends: A 2024 Review and a Look Ahead (thenewstack.io)

2

Vertical Stacking as the Relational Model Intended: Union All by Name (duckdb.org)

2

DuckDB: Query Processing Is King (thenewstack.io)

1

Overture Maps Transportation theme is now GA (overturemaps.org)

3

DuckDB Node Neo Client (duckdb.org)

1

Speed Up Compound Full-Text Searches in PostgreSQL by 300x (rorvswild.com)

1

Full Text Search in Milliseconds with Rails and PostgreSQL (pganalyze.com)

1

Query Your Snowflake Managed Iceberg Tables with DuckDB (greybeam.ai)

2

Shrinking a Postgres Table (johnnunemaker.com)

59

Django and Postgres for the Busy Rails Developer (andyatkinson.com)

1

The DuckDB Avro Extension (duckdb.org)

2

DuckDB: Running TPC-H SF100 on Mobile Phones (duckdb.org)

3

Postgres Partitioning with a Default Partition (crunchydata.com)

3

CSV Files: Dethroning Parquet as the Ultimate Storage File Format – Or Not? (duckdb.org)

1

Pg_parquet – Postgres to Parquet Interoperability (i-programmer.info)

2

Some of My Favorite PostgreSQLisms (postgresonline.com)

1

Crunchy Data Warehouse: Postgres with Iceberg for Analytics (crunchydata.com)

1

Iceberg Tables in Postgres with Crunchy Data Warehouse (crunchydata.com)

3

PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released! (postgresql.org)

1

Easy Totals and Subtotals in Postgres with Rollup and Cube (crunchydata.com)

2

2024 Ruby on Rails Community Survey Result (railsdeveloper.com)

1

Using CTID Based Pagination for Data Cleanups in Postgres (shayon.dev)

1

Postgres and Citus and Partman for Your IoT Database (crunchydata.com)

3

Performance Gains with Postgres 17B-Tree Bulk Scans (crunchydata.com)

1

Building Postgres Extensions: Dropping Extensions and Cleanup (crunchydata.com)

3

Postgres Window Functions for Data Analysis (crunchydata.com)

3

PostGIS Meets DuckDB: Crunchy Bridge for Analytics Goes Spatial (crunchydata.com)

2

Postgres Materialized Views from Parquet in S3 (crunchydata.com)

2

Understanding the Postgres Hackers Mailing List (crunchydata.com)

1

How the VC Ecosystem Broke the LP Ecosystem (twitter.com/fintechjunkie)

1

Postgres Powered by DuckDB: The Modern Data Stack in a Box (crunchydata.com)

9

Postgres feature you're not using – CTEs a.k.a. WITH clauses (craigkerstiens.com)

1

Six Degrees of Kevin Bacon – Postgres Style (crunchydata.com)

2

PostgreSQL 16.4, 15.8, 14.13, 13.16, 12.20, and 17 Beta 3 Released (postgresql.org)

6

Six Degrees of Kevin Bacon – Postgres Style (crunchydata.com)

1

Postgres for Analytics with DuckDB Integration (thenewstack.io)

1

Why Postgres and DuckDB for Analytics (twitter.com/marcoslot)

1

Postgres Psql: Settings, Presets, Echo, and Saved Queries (crunchydata.com)

1

We Fused DuckDB into Postgres for Crunchy Bridge (crunchydata.com)

2

Parallel Queries in Postgres (crunchydata.com)

1

Building Postgres Extensions: Dropping Extensions and Cleanup (crunchydata.com)

2

PgCompare: Multi-Database Data Comparison Tool (crunchydata.com)

3

Postgres 16 Security Technical Implementation Guide Released (crunchydata.com)

1

Time Partitioning and Custom Time Intervals in Postgres with Pg_partman (crunchydata.com)

1

Native Delta Lake Support in DuckDB (duckdb.org)

3

We Fused DuckDB into Postgres with Crunchy Bridge for Analytics (crunchydata.com)

1

FTC's ban on noncompetes could be good for startups. But might be struck down (techcrunch.com)

1

Why Tesla May Settle in Texas While X Found Its Spot in Nevada (virginia.edu)

2

Postgres Can Do That? (medium.com/cognite)

1

Pg_query for Postgres 16 (pganalyze.com)

3

PostgreSQL: Full text search with the "websearch" syntax (adamj.eu)

2

Pg_easy_replicate 2.0 (shayon.dev)

3

PostgreSQL Internals: Things to Know About Update Statements (patrick.engineering)

1

Logical Replication from Postgres 16 Standby (decodable.co)

1

Getting Postgres Logs in a GitHub Action (brandur.org)

1

JSON Updates in Postgres 16 (crunchydata.com)

1

Pgpartman: Partition Management Extension for Postgres (github.com/pgpartman)

2

Top Postgres Management Tasks (crunchydata.com)

2

Scaling Vector Data with Postgres (crunchydata.com)

2

Postgres Row Level Security Primer and Creating Large Policies (crunchydata.com)

8

Postgres Subqueries: CTEs, Materialized Views, Window Functions, LATERAL Join (crunchydata.com)

1

Pg_partman 5.0 release: Postgres Partion Management (postgresql.org)

2

Remote Access Anything from Postgres (crunchydata.com)

1

Performance Tips for Postgres FDW (crunchydata.com)

2

High Compression Metrics Storage with Postgres Hyperloglog (crunchydata.com)

1

Performance Tips for Using Pgvector and Postgres (crunchydata.com)

1

Remote Access CSV Files from Postgres (crunchydata.com)

1

Performance Tips for Postgres and pgvector (crunchydata.com)

3

Practical AI with Postgres (crunchydata.com)

1

How to Get Table Creation Information in Postgres (crunchydata.com)