Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
How we made Jupyter notebooks load faster
When we received feedback our Notebooks UI was taking too long too load, our engineers dove into ways to improve the developer experience — bringing some load times from 30 seconds down to less than one.
Supercharge SQLite with Ruby Functions
An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in…
On Building A Stupidly Fast Graph Database
It’s pretty clear to computer science geeks that Directed Edge is supposed to be doing groovy things with graphs. In fact our recommendation engine, and some of the things that are unique about our approach to recommendations, are built on our super-fast graph database. When we went live yesterday with the latest…
The Growth of Reddit
Explore the Quillbot blog for practical articles on writing, grammar, creativity, AI tools, education, marketing, and career growth.
Why Can't Database Tables Index Themselves? (2006)
Here’s a thought question for today: why can’t database tables index themselves? Obviously, indexes are a central concept to databases and database performance. But horror tales still abound of naïve developers who “forget” to index their tables, and encounter massive performance and scalability problems down the road…
Parsing SQL
SQL is a language to handle data in databases. However, it has limitations and you might need to parse SQL to get around them.
The Simpsons by the Data
Analysis of Simpsons characters, dialogue, TV ratings, and more
1,600 days of a failed hobby data science project
I dedicated over 1,600 days to a data science project, only to see it fail. In this article, I share a new checklist I developed to help prevent similar setbacks in the future.
Artificial Analysis Intelligence Index v4.2
We are accelerating elements of our upcoming v5 release with interim updates to keep pace with the frontier. Index v4.2 has more complex and realistic tasks, and more private test sets to prevent gaming
Scientific datasets are riddled with copy-paste errors
Initial results from scanning through Excel files belonging to 600 published scientific papers.
84% of a single-threaded 1KB write in Redis is spent in the kernel
Alex Clemmer is a computer programmer. Other programmers love Alex, excitedly describing him as "employed here" and "the boss's son".
Making ActiveRecord 2x faster
TL;DR: AdequateRecord is a set of patches that adds cache stuff to make ActiveRecord 2x faster
PostgreSQL High Availability Solutions – Part 1: Jepsen Test and Patroni
Note: code used in this article can be found on the Github repo jepsen-postgres-ha .
League of Legends data scraping the hard and tedious way for fun
Personal website for some random tidbits I work on
Effectively Using Materialized Views in Ruby on Rails
We look at how to utilize both, views and materialized views, within Ruby on Rails with a real-world sized dataset of hockey teams and their top scorers.
Show HN: Domain-tailored CRDTs for collaboration without server involvement
An in-depth exploration of a new class of expressive, performant, and intuitive CRDTs, together with macOS and iOS sample code.
OpenTelemetry Traces and PostgreSQL
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.
Research team digitizes more than 100 years of Canadian infectious disease data
The new, publicly accessible database contains more than a million infectious disease incidence counts dating back to 1903.
SAT score distributions in Michigan
The state of Michigan required all public HS seniors to take the SAT last year (~91k out of ~107k total seniors in the state). This generate...
Excess Deaths in 2020
Update Updated on April 29th, 2021. The CDC continues to update its counts of deaths by cause for 2020 as data comes in from the jurisdictions that report to it. The data are by now fairly complete, though there are still significant gaps in several states due to delayed reporting. North Carolina, in particular, has…
Four DB2 Code Bases?
Many years ago I worked on IBM DB2 and so I occasionally get the question, “how the heck could you folks possibly have four relational database management system code bases?” Some go on to argue that a single code base would have been much more efficient. That’s certainly true. And, had we moved to a single code base…