571
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
572
Internet Archive Scholar: Search Millions of Research Papers
Looking for a research paper but can’t find a copy in your library’s catalog or popular search engines? Give Internet Archive Scholar a try! We might have a PDF from a “vanished” Open Access publisher in our web archive, an author’s pre-publication manuscript from their archived faculty webpage, or a digitized…
573
Actually Queryable Executables
I was pleasantly surprised and happy to see that my article ‘Your executable is a SQLite database’ resonated with people. It is a format I have been thinking about for a while, and the idea seems to have struck a chord with others.
574
Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical databases, pgrust is 300x faster than Postgres. It’s even ahead of…
575
Andy Pavlo joins ClickHouse to establish ClickHouse Labs
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
576
Finding bugs in SQLite, the easy way
SQLite is probably the most popular embedded database in use today; it is also known for being exceptionally well-tested and robust. In co...
577
How PostgreSQL stores rows
poking inside postgres pages
578
579
MySQL is bazillion times faster than MemSQL
I don’t like stupid benchmarks, as they waste my time. I don’t like stupid marketing, as it wastes my time too. Sometimes I succumb to those things, and now in return I want to waste yo…
580
581
582
Average color of each country (using satellite imagery)
*Couple of weeks ago we have noticed the article getting attention around twitter. As it is using our WMS EOxMaps endpoint we have asked Erin Davis if we could host her idea here. At EOX we endorse brilliant and unique ideas that utilize our tools and data. Thank you for this most interesting contri ...
583
Codeq
The free database designed for immutable values and a time-aware information model.
584
Download responsibly
This month we’ve ramped up the infrastructure behind the download server, and downloads should now be available earlier and faster. There’s also a small technical change in that requests for a “…latest” file will now be answered with a HTTP redirect to the specific latest version (see previous blog post).
585
Gemini 4 Carbon is the new #1 on the Artificial Analysis Intelligence Index v5
Google’s Gemini 4 Carbon is the new #1 on the Artificial Analysis Intelligence Index v5, and second only to Claude Opus 5.5 on the Artificial Analysis Coding Agent Index
586
587
The data model behind Notion's flexibility
Notion’s data model enables the product’s most foundational component: blocks. Through blocks, we allow users more flexibility over their information.
588
Postgres Full Text Search vs. the Rest
Comparing one of the most popular Postgres features against alternatives
589
How Discord Indexes Billions of Messages Using Elasticsearch
Discover the latest news and app updates, stories, company insights, and plenty more about Discord, all in one place.
590
A Canadian payroll dependency chart
Unfortunately, like most aspects of the tax system, this steadily increases in complexity, and this year with the Canada Pension Plan including not just "base" premiums and "additional" premiums but also "second additional premiums", I needed to rewrite my spreadsheet from scratch; and also very unfortunately, the…
591
Backblaze Hard Drive Stats for 2020
The AFR for 2020 dropped below 1% down to 0.93%. In 2019, it stood at 1.89%. That’s over a 50% drop year over year.
592
593
594
The "missing" graph datatype already exists. It was invented in the '70s
This post is a response to/inspired by The Hunt for the Missing Data Type ( HN ) by Hillel Wayne. I suggest reading his article first.
595
Forecasts need to have error bars
Richard Rosenfeld in the most recent Criminologist published a piece about forecasting national level crime rates. People complain about the FBI releasing crime stats a year late, academics are wor…
596
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
597
Making SQL Server run on Linux
This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL Server. Introduction We first announced SQL Server on Linux in March, and recently released the first public preview of SQL…
598
599
A friendly guide to colours in data visualisation
A collection of tools that help you deal with color gradients & color palettes, to design better data visualizations.
600
Labor market impacts of AI: A new measure and early evidence
We introduce "observed exposure," combining LLM capability with real Claude usage data, and share early evidence on employment effects.