3631
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.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3632
3633
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.
3634
3635
Message Queues: A Simple Guide with Analogies (2024)
This guide explains message queues with analogies: databases, warehouses and post offices.
3636
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.
3637
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
3638
3639
3640
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
3641
Lesson Learned from Queries over 1.3T Rows of Data
Explore how our customers use TiDB to handle their mission-critical workloads.
3642
3643
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.
3644
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...
3645
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...
3646
Querying Time Series in PostgreSQL
A blog about computer programs, databases, and the future of software development.
3647
3648
The R language, for programmers
Some things about the R programming language that programmers coming from other languages are likely to trip over.
3649
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.
3650
3651
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.
3652
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…
3653
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.
3654
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…
3655
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…
3656
3657
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.
3658
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.
3659
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.
3660