2281
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…
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2282
2283
Breaking the WAL
I did this from a lawn chair on the Sunshine Coast.
2284
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…
2285
2286
2287
Mapping the off-target effects of every FDA-approved drug in existence
6.2k words, 29 minutes reading time
2288
SQLite 3.44: Interactive release notes
Order by in aggregates, better string concatenation, and thorough date formatting.
2289
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…
2290
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.
2291
Connecting to Google Sheets with Python
I wrote up my experience using Python to process data from a shared Google Sheets spreadsheet
2292
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…
2293
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…
2294
2295
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.
2296
Generalizing 'jq' and Traversal Systems using optics and standard monads
The Personal blog and musings of Chris Penner, a designer, developer and future opsimath.
2297
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.
2298
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.
2299
2300
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.
2301
2302
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.
2303
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.
2304
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.
2305
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…
2306
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.
2307
2308
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
2309
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!
2310
