3631
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3632
Which Is Closer: Local Beer or Local Whiskey?
For which fraction of the US is the nearest brewery further away than the nearest distillery? Analysis and visualization done with Wolfram Language.
3633
3634
ArangoDB 3.7 – a big step forward for multi-model
The only enterprise AI data platform that cuts complexity, reduces costs, and gets you to production faster.
3635
3636
Message Queues: A Simple Guide with Analogies (2024)
This guide explains message queues with analogies: databases, warehouses and post offices.
3637
Partitioning in Postgres, 2022 Edition
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
3638
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
3639
3640
3641
Interactive NBA Shot Charts with R and Shiny
Make your own NBA shot charts. Open-source, interactive dashboard interface to NBA Stats API built with R and Shiny
3642
Lesson Learned from Queries over 1.3T Rows of Data
Explore how our customers use TiDB to handle their mission-critical workloads.
3643
3644
Postgres 17: Streaming I/O for sequential scans and ANALYZE
We discuss streaming and vectored I/O in Postgres 17. This is an important step towards implementing asynchronous I/O in Postgres. In Postgres 17 we do not yet have asynchronous I/O, but we do see a performance benefit from what is essentially a refactoring work around the internal APIs.
3645
Using Python and heat maps to determine the best place to aim on a dart board
Over break I went out with a buddy of mine and played some darts. This got me to thinking, where exactly should someone aim in order t...
3646
Parallel Index Scans in PostgreSQL
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...
3647
Querying Time Series in PostgreSQL
A blog about computer programs, databases, and the future of software development.
3648
3649
The R language, for programmers
Some things about the R programming language that programmers coming from other languages are likely to trip over.
3650
Conformance checking at MongoDB: Testing that our code matches our TLA+ specs
Testing code fidelity with TLA+ specs at MongoDB. Explore conformance checking experiences and agile modelling in distributed systems.
3651
3652
How to Think about Correlation?
I am an economist at the Federal Trade Commission with a very basic statistics question, one that I have put to several fairly high-powered econometricians, and to which no one has had a satisfying answer.
3653
10 Years of Hacker News "Ask HN: Who Is Hiring" Trends
The "Ask HN: Who is hiring" monthly post on Hacker News, available on the first day of each month, provides a platform for users to share tech job listings for free. Analyzing 10 years of these posts with a Python script reveals significant shifts in hiring trends. This insight into the evolving tech job market can…
3654
InfluxDB Clustering Design – Neither CP or AP
A few weeks ago I hinted at some big changes coming in the InfluxDB clustering design. These changes came about because of the testing weve done over the last 3 months with the clustering design that was going to be shipped in 0.9.0.
3655
Asymmetric Quantization: Near-Lossless Retrieval with 97% Storage Reduction
Late interaction makes retrieval more precise but turns every document into many vectors. Asymmetric quantization keeps query vectors precise and stores…
3656
PostgreSQL Subtransactions Considered Harmful
PostgreSQL subtransactions (nested transactions) may cause multiple performance and scalability issues: higher rates of XID growth and higher risks of transaction ID wraparound, performance degradation when more than PGPROC_MAX_CACHED_SUBXIDS (64) are used in a session, drastic performance slowdowns when…
3657
3658
Citus Cloud 2, Postgres, and Scaling Without Compromise
Relational databases have been a mainstay for decades. But what happens when you need to scale out a relational database like Postgres? This post announces Citus Cloud 2, the latest version of the Citus managed database as a service that scales out Postgres horizontally in the cloud.
3659
Bitcoin Mining in Plain English
99Bitcoins is your trusted guide to Bitcoin & crypto, offering easy tutorials, expert insights, and in-depth reviews to help you navigate the crypto world.
3660
Hermitage: Testing the “I” in ACID
tl;dr: I have created a test suite for comparing the transaction isolation levels in different databases. I did this as background research for my book . This post explains why.