3061
Is the "modern data stack" still a useful idea?
My vote: no.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3062
Postgres Postmaster does not scale
Why Postgres postmaster contention becomes a bottleneck at scale, how connection bursts and worker churn trigger it, and which fixes helped in production.
3063
Airflow 2.0
We're proud to announce that Apache Airflow 2.0.0 has been released.
3064
Back to basics: Writing an application using Go and PostgreSQL
Learn how to use PostgreSQL with the Go programming language using the pgx driver and toolkit in a very productive manner. Furthermore, with the provided source code, you'll be able to learn how to write efficient and sound unit and integration tests, ready to be run locally or on a Continuous Integration environment…
3065
I disagree with Turing and Kahneman regarding statistical evidence (2014)
It’s funny. I’m the statistician, but I’m more skeptical about statistics, compared to these renowned scientists.
3066
3067
Observability 2.0 and the Database for It
What Observability 2.0 means in practice, how wide events replace siloed metrics/logs/traces, and why GreptimeDB is purpose-built as the database foundation.
3068
I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS
Why and how I migrated from distributed postgres to distributed sqlite on kentcdodds.com
3069
3070
If the world’s population lived like... (infographic)
Shortly after I started Per Square Mile, I produced an infographic that showed how big a city would have to be to house the world’s 7 billion people.
3071
Deno KV Is in Open Beta
Deno KV, the easiest way to add a strongly consistent database to your app, is now in open beta.
3072
How to get stock fundamentals data with Python
Learn how to download fundamentals data with Python using the yahoo_fin package, including P/E and P/S ratios, return on equity, and more.
3073
3074
Columnar Storage Is Normalization
Something I didn't understand for a while is that the process of turning row-oriented data into column-oriented data isn't a totally bespoke, foreign concept...
3075
3076
PostgreSQL and SQL:2023
In a previous article, I introduced what is new in SQL:2023. Now I want to show the status of SQL:2023 support in PostgreSQL. See the previous article for details on these features.
3077
Querying Parquet with Precision Using DuckDB
DuckDB, a free and open source analytical data management system, can run SQL queries directly on Parquet files and automatically take advantage of the advanced features of the Parquet format.
3078
Simple, Fast, and Scalable Reverse Image Search
How we built our first iteration of content matching at Canva.
3079
Do We Need Distributed Stream Processing?
In the era of big data and AI, many data-intensive applications exhibit requirements that cannot be satisfied by traditional batch processing models. Streaming applications, such as click stream analytics , IoT data processing, network monitoring , or financial fraud detection , must support high processing rates…
3080
Video Processing at Dropbox
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
3081
Fastest table sort in the West – Redesigning DuckDB's sort
DuckDB, a free and open-source analytical data management system, has a new highly efficient parallel sorting implementation that can sort much more data than fits in main memory.
3082
Fun with NFL Stats, Bokeh, and Pandas
An exploration of NFL play-by-play statistics with Bokeh and Pandas.
3083
3084
3085
Building the Next New York Times Recommendation Engine
Alexander Spangher discusses recent work that’s been done to revamp our article recommendation algorithm.
3086
3087
How to Distribute Postgres Geographically
Documenting a pattern for making multi-tenant applications global by distributing the data, using only standard PostgreSQL functionality.
3088
Stream VByte: breaking new speed records for integer compression
In many information systems, we work with arrays of integers. For example, maybe you need to keep track of which records in a database contain a given value. This sort of mapping can be expressed as an array of integers. These arrays can end up taking up a large fraction of your memory or disk … Continue reading…
3089
Postgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_switch_wal.
3090
YC Summer 2017 Stats
Today is Y Combinator’s 25th Demo Day. With 124 companies presenting over the next two days, this is the largest Demo Day in YC’s 12.5 year history. We wanted to share some stats about YC and about the batch. For the more visually inclined, see the graphic below created by YC alum SketchDeck…