2281
Building data infrastructure that will last
As a consultant, I have been called in to review and, in many cases, replace dozens of half-finished, abandoned, and sometimes forgotten data infrastructure projects.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
2282
Faster R with FastR
R is a programming language for statistical computing known for its rich ecosystem of 3rd party libraries called “packages”. The R…
2283
2284
Breaking the WAL
I did this from a lawn chair on the Sunshine Coast.
2285
Bayesian ranking of items with up and downvotes or 5 star ratings
Evan Miller wrote a great article How Not To Sort By Average Rating . He shows that simple formulas like score = upvotes - downvotes or score = upvotes / (upvotes + downvotes) don’t work. He proposes to use the lower bound of the Wilson score confidence interval. The formula is complicated and somewhat of a hack…
2286
2287
2288
Mapping the off-target effects of every FDA-approved drug in existence
6.2k words, 29 minutes reading time
2289
SQLite 3.44: Interactive release notes
Order by in aggregates, better string concatenation, and thorough date formatting.
2290
Examining PostgreSQL 9.4 – A first look
PostgreSQL is currently entering its final commit fest. While its still going, which means there could still be more great features to come, we can start to take a look at what you can expect from it now. This release seems to bring a lot of minor increments versus some bigger highlights of previous ones. At the same…
2291
Relational shell programming
Unix is a bestiary of ad hoc databases: comma-, colon-, tab- and space-separated tables. Think of /etc/* or /var/log/* , or of columnar commands.
2292
Connecting to Google Sheets with Python
I wrote up my experience using Python to process data from a shared Google Sheets spreadsheet
2293
Postgres indexes under the hood
Many software engineers use database indexes every day, but few of us really understand how they work. In this post I’ll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for…
2294
Groundhog: Addressing the Threat That R Poses to Reproducible Research
R, the free and open source program for statistical computing, poses a substantial threat to the reproducibility of published research. This post explains the problem and introduces a solution. The…
2295
2296
Using command line to process CSV files (2022)
Process CSV files from the command line with awk, sort, and grep: pull out fields, order rows, and filter data without a spreadsheet or a script.
2297
Generalizing 'jq' and Traversal Systems using optics and standard monads
The Personal blog and musings of Chris Penner, a designer, developer and future opsimath.
2298
Building a MongoDB Clone in Postgres
I had a crazy thought. Don't all good ideas start with that phrase? Well, this one was suitably crazy: why not build my own version of MongoDB right on top of Postgres? It sounds a little far-fetched, but in all honesty it's pretty simple.
2299
Implementing system-versioned tables in Postgres
There's no official support for system-versioned tables in Postgres yet, and the temporal extensions aren't supported on Azure/AWS/GCP. Let's implement it ourselves with 3 triggers and an index.
2300
2301
ZFS from a MySQL perspective
As the purpose of a database system is to store data, there is close relationship with the filesystem. Yves Trudeau reconsiders the use of ZFS with MySQL.
2302
2303
MySQL vs. MariaDB: Reality Check
Choosing between MariaDB and MySQL? In this blog, we provide an overview of the key differences between MariaDB vs. MySQL and explore their unique use cases.
2304
Developer Preview: RethinkDB Now Available for Windows
We’re pleased to announce today that RethinkDB is now available for Windows . You can download a Developer Preview of our Windows build, which runs natively on Microsoft’s operating system.
2305
Build durable workflows with Postgres
In this blog post, we’ll dive deep into why we chose to build DBOS durable workflow execution on the PostgreSQL DBMS.
2306
Evidence of fraud in an influential field experiment about dishonesty
This post is co-authored with a team of researchers who have chosen to remain anonymous. They uncovered most of the evidence reported in this post. These researchers are not connected in any way to…
2307
Geosharded Recommendations with Hilbert Curve at Tinder
We’re on a mission to keep the magic of human connection alive. Learn more about life at Tinder and the many ways we're igniting our impact—for our employees and the millions of people seeking connection on our app.
2308
2309
How Postgres is more than a relational database: Extensions
Extensions allow Postgres to be customized and extended in powerful new ways. Here we find a tour of extensions and how they can make Postgres into much more than a relational database
2310
Datalog in JavaScript
Let's build a query engine from scratch. In about 100 lines of Javascript, we'll support joins, indexes, and find our answer for Arnold!