Hacker News headlines

1

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

15 hours ago | plaur782 | github.com | newest

128

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

2 days ago | plaur782 | github.com | best

2

Postgres Logging for Performance Optimization (crunchydata.com)

3 months ago | plaur782 | crunchydata.com | newest

2

Logical Replication from Postgres to Iceberg (crunchydata.com)

7 months ago | plaur782 | crunchydata.com | newest

1

Creating Histograms with Postgres (crunchydata.com)

7 months ago | plaur782 | crunchydata.com | newest

1

Transforming Data with DuckDB and Dbt (duckdb.org)

7 months ago | plaur782 | duckdb.org | newest

2

Maximizing Your Delta Scan Performance (duckdb.org)

8 months ago | plaur782 | duckdb.org | newest

3

Automatic Iceberg Maintenance Within Postgres (crunchydata.com)

8 months ago | plaur782 | crunchydata.com | newest

2

Parquet Bloom Filters in DuckDB (duckdb.org)

8 months ago | plaur782 | duckdb.org | newest

1

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

8 months ago | plaur782 | crunchydata.com | newest

1

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

9 months ago | plaur782 | jpcamara.com | newest

3

Postgres Compatability Index (drunkdba.medium.com)

9 months ago | plaur782 | medium.com | newest

1

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

9 months ago | plaur782 | crunchydata.com | newest

2

Geoparquet 2.0: Going Native (cloudnativegeo.org)

9 months ago | plaur782 | cloudnativegeo.org | newest

22

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

9 months ago | plaur782 | shayon.dev | frontpage

1

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

10 months ago | plaur782 | visualmode.dev | newest

1

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

10 months ago | plaur782 | duckdb.org | newest

2

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

10 months ago | plaur782 | medium.com | newest

124

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

10 months ago | plaur782 | db-engines.com | best

1

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

10 months ago | plaur782 | thenewstack.io | newest

2

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

10 months ago | plaur782 | duckdb.org | newest

2

DuckDB: Query Processing Is King (thenewstack.io)

10 months ago | plaur782 | thenewstack.io | newest

1

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

11 months ago | plaur782 | overturemaps.org | newest

3

DuckDB Node Neo Client (duckdb.org)

11 months ago | plaur782 | duckdb.org | newest

1

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

11 months ago | plaur782 | rorvswild.com | newest

1

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

11 months ago | plaur782 | pganalyze.com | newest

1

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

11 months ago | plaur782 | greybeam.ai | newest

2

Shrinking a Postgres Table (johnnunemaker.com)

11 months ago | plaur782 | johnnunemaker.com | frontpage

59

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

11 months ago | plaur782 | andyatkinson.com | best

1

The DuckDB Avro Extension (duckdb.org)

11 months ago | plaur782 | duckdb.org | newest

2

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

11 months ago | plaur782 | duckdb.org | newest

3

Postgres Partitioning with a Default Partition (crunchydata.com)

11 months ago | plaur782 | crunchydata.com | newest

3

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

11 months ago | plaur782 | duckdb.org | newest

1

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

12 months ago | plaur782 | i-programmer.info | frontpage

2

Some of My Favorite PostgreSQLisms (postgresonline.com)

12 months ago | plaur782 | postgresonline.com | newest

1

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

12 months ago | plaur782 | crunchydata.com | newest

1

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

12 months ago | plaur782 | crunchydata.com | newest

3

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

12 months ago | plaur782 | postgresql.org | newest

1

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

12 months ago | plaur782 | crunchydata.com | newest

2

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

12 months ago | plaur782 | railsdeveloper.com | newest

1

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

12 months ago | plaur782 | shayon.dev | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

3

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

a year ago | plaur782 | crunchydata.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

3

Postgres Window Functions for Data Analysis (crunchydata.com)

a year ago | plaur782 | crunchydata.com | newest

3

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

a year ago | plaur782 | crunchydata.com | frontpage

2

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

a year ago | plaur782 | crunchydata.com | newest

2

Understanding the Postgres Hackers Mailing List (crunchydata.com)

a year ago | plaur782 | crunchydata.com | frontpage

1

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

a year ago | plaur782 | twitter.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

9

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

a year ago | plaur782 | craigkerstiens.com | best

1

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

a year ago | plaur782 | crunchydata.com | newest

2

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

a year ago | plaur782 | postgresql.org | newest

6

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

a year ago | plaur782 | crunchydata.com | frontpage

1

Postgres for Analytics with DuckDB Integration (thenewstack.io)

a year ago | plaur782 | thenewstack.io | newest

1

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

a year ago | plaur782 | twitter.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

2

Parallel Queries in Postgres (crunchydata.com)

a year ago | plaur782 | crunchydata.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

2

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

a year ago | plaur782 | crunchydata.com | newest

3

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

a year ago | plaur782 | crunchydata.com | newest

1

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

a year ago | plaur782 | crunchydata.com | newest

1

Native Delta Lake Support in DuckDB (duckdb.org)

a year ago | plaur782 | duckdb.org | newest

3

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

a year ago | plaur782 | crunchydata.com | newest

1

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

a year ago | plaur782 | techcrunch.com | newest

1

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

a year ago | plaur782 | virginia.edu | newest

2

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

a year ago | plaur782 | medium.com | newest

1

Pg_query for Postgres 16 (pganalyze.com)

a year ago | plaur782 | pganalyze.com | newest

3

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

a year ago | plaur782 | adamj.eu | newest

2

Pg_easy_replicate 2.0 (shayon.dev)

a year ago | plaur782 | shayon.dev | newest

3

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

a year ago | plaur782 | patrick.engineering | newest

1

Logical Replication from Postgres 16 Standby (decodable.co)

a year ago | plaur782 | decodable.co | newest

1

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

2 years ago | plaur782 | brandur.org | newest

1

JSON Updates in Postgres 16 (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

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

2 years ago | plaur782 | github.com | newest

2

Top Postgres Management Tasks (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

2

Scaling Vector Data with Postgres (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

2

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

2 years ago | plaur782 | crunchydata.com | newest

8

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

2 years ago | plaur782 | crunchydata.com | frontpage

1

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

2 years ago | plaur782 | postgresql.org | newest

2

Remote Access Anything from Postgres (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | frontpage

1

Performance Tips for Postgres FDW (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

2

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

2 years ago | plaur782 | crunchydata.com | frontpage

1

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

2 years ago | plaur782 | crunchydata.com | newest

1

Remote Access CSV Files from Postgres (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

Performance Tips for Postgres and pgvector (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

3

Practical AI with Postgres (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

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

2 years ago | plaur782 | crunchydata.com | newest

3

Working with Time in Postgres (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

6

Postgres Pgvector Performance Tips for Developers (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | frontpage

1

PostgreSQL for Solving N+1 Queries in Ruby on Rails (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

Finding Shortest Paths and Travel Costs with Postgres Functions (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

Postgres Unlogged Sequences (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

Is Your Postgres Ready for Production? (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

3

Easy Postgres Time Bins (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

PostgreSQL 15 on Heroku (heroku.com)

2 years ago | plaur782 | heroku.com | newest

1

FDIC Announces Agreement to Sell Signature Bank Assets (cnbc.com)

2 years ago | plaur782 | cnbc.com | newest

3

Introduction to Postgres Backups (crunchydata.com)

2 years ago | plaur782 | crunchydata.com | newest

1

CooleyGo New Resource: Short Term Promissory Note Forms (cooleygo.com)

2 years ago | plaur782 | cooleygo.com | newest