301
Reed-Solomon error recovery in RAID-6
A post describing a simple example how you can create your own manual error recovery solution based on what is used in RAID-6, in Python.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 314 posts.
302
Everything I've seen on optimizing Postgres on ZFS
Looking to run Postgres on ZFS? I've gathered some of the information and sage advice out there to give you a head start on figuring out how to do it safely and efficiently.
303
Deconstructing the Postgres planner to find indexing opportunities
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
304
Evolution of tree data structures for indexing
I have to admit, my research blog posts are getting longer and longer. From one side I find it genuinely encouraging, because if one gets so much information just by scratching the topic, imagine what’s hidden beneath the surface! One university professor once said “what could be interesting in databases?”, and it…
305
Dublin Core's dirty little secret (2010)
[This is part two in a series — you should read part 1 first for context and then you might go on to part 3.] The Dublin Core — metadata made dumb Just when librarians were in despair o…
306
Roapi: An API Server for Static Datasets
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
307
Protecting reserved roles with PostgreSQL Hooks
Using Postgres Hooks to protect functionality in your Postgres database.
308
Faster DISTINCT queries on PostgreSQL
Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries. Read the full article on the Tiger Data blog.
309
Study reveals scale of data-sharing from Android mobile phones
These vendor-customised Android variants transmit substantial amounts of information to the OS developer and to third parties such as Google, Microsoft, LinkedIn, and Facebook that have pre-installed system apps.
310
Peritext: A CRDT for Rich-Text Collaboration
Collaboration on rich text is hard to model with plain-text approaches. We review the challenges and how to construct a CRDT for rich text.
311
Using inflation tracking methods from 80s and 90s, inflation would be ~10%
The CPI chart on the home page reflects our estimate of inflation for today as if it were calculated the same way it was in 1990. The CPI on the Alternate Data Series tab here reflects the CPI as if it were calculated using the methodologies in place in 1980. In general terms, methodological shifts in government…
312
Savings are now more liquid and part of “M1 money”
Money is marvelously nuanced. Because different assets can be used as money, we need several categories and definitions to keep track of it. M1 describes the most liquid and widely...
313
What’s behind the recent surge in the M1 money supply?
While the terms “money” and “wealth” often mean the same thing in everyday parlance, economists define money more narrowly as the component of wealth consisting of
314
Latest Data on COVID-19 Vaccinations by Race/Ethnicity
KFF is collecting and analyzing data on COVID-19 vaccinations by race/ethnicity to gain increased insight who is receiving the vaccine and whether some groups are facing disparities in vaccination.