Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
Even though many scientists are expected to abide by the principles of open, rigorous and reproducible research, few scientists actually receive formal training in this. Indeed, there is no collection written by working scientists for working scientists about the principles of transparent, rigorous and reproducible…
Programmers often need to 'filter out' data. Suppose that you are given a database of users where only a small percentage are 'paying customers' (say 5% or less). You can write an SQL query to check whether a given user is indeed a paying customer, but it might require a round trip to your database … Continue reading…
Previously, on Jepsen , we demonstrated stale and dirty reads in MongoDB . In this post, we return to Elasticsearch, which loses data when the network fails, nodes pause, or processes crash.
When I started playing with word2vec four years ago I needed (and luckily had) tons of supercomputer time. But because of advances in our understanding of w...
[Twitter thread, Hacker News discussion, Reddit discussion]
My wife and I run OpenBenches - a crowd-sourced database of nearly 40,000 memorial benches. Every bench is geo-tagged with a latitude and longitude. But how do you go from a string of digits to something human readable? How do I turn -33.755780,150.603769 into "42 Wallaby Way, Sydney, Australia"? Luckily, that's a…
An alternate to traditional <code>deleted_at</code> soft deletion that stays out of the way and minimizes bugs.
Hello, my name is Maxim Babenko, I’m the head of the distributed computing technologies department at Yandex. Today we’re pleased to…
Explore Backblaze's Q3 2023 hard drive stats, revealing insights on 259,533 HDDs, failure rates, and data center performance for enhanced reliability.
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5. That did not happen. However, I...
The idea for this article didn't exist in my brain before this morning. But there I was, scrolling the New page and even more tired of all the AI-related Show HN posts than usual. I was confident that their numbers were multiplying and wanted proof. Exactly how much more AI crap is on my lawn compared to last year?
Visit the post for more.
Why OpenRun uses a SQLite database instead of the local file system for static files.
Radar offers geocoding, place search, and fraud detection APIs, powered by HorizonDB, a Rust-based engine delivering 20k QPS and sub-millisecond latency.
[Amazon RDS for PostgreSQL](https://aws.amazon.com/rds/postgresql/) now supports the next major release of the PostgreSQL open source database, version 9.6.1. New features …
This week-end project started by browsing the open-data repository of Paris’ public transport network, which contains various APIs to query real-time departures, current disruptions, etc.The data reuse section caught my eye, as it features external projects that use this open data.In particular, the RATP status…
Our updated modeling strategy now estimates total COVID-19 mortality, including unreported deaths due to COVID-19.
We are members of the Facebook Notifications Data Science team at Meta. We ran surveys on how users felt about on-site notifications…
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
