Every blog post that took off on Hacker News, ranked by the votes of its best submission. 1,887 posts.
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a
Algorithms are a fascinating use case for visualization. To visualize an algorithm, we don’t merely fit data to a chart; there is no primary dataset. Instead there are logical rules that describe behavior. This may be why algorithm visualizations are so unusual, as designers experiment with novel forms to better…
Sergey Filimonov's blog
I saw Martin Kleppmann’s talk a few weeks ago about his approach to realtime editing with CRDTs, and I felt a deep sense of despair. Maybe all the work I’ve been doing for the past decade won’t be part of the future after all, because Martin’s
On December 21, 2018, the United States House of Representatives voted to enact H.R. 4174, the Foundations for Evidence-Based Policymaking Act of 2017, in a historic win for open government in the …
A complete GPT2 implementation as a single SQL query in PostgreSQL.
This visualization shows the top 30 books ranked by total number of links to Amazon in Hacker News comments from Oct 2006 to Oct 2015.
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
An independent, non-commercial educational visualization of PostgreSQL internals. Not affiliated with Electronic Arts.
Here’s a little “fake stats in the wild” gem that I think you and your followers will find at the least somewhat amusing.
Sadly, taking away valuable disclosure avoidance tools doesn't make fundamental trade-offs go away.
Over the past decade, the timing of PostgreSQL major releases has become very predictable: no earlier than the middle of September, and no l...
This is more of a personal post than something intended to be profound. If you are looking for a point, you will not find one here. Frankly I am not even sure who the target audience is for this (p…
Adam Drake is an advisor to scale-up tech companies. He writes about ML/AI/data, leadership, and building tech teams.
Writing a sqlite clone from scratch in C
This'll be my first blog post on the internet, ever. Hopefully it's interesting and accurate. Please point out any mistakes if you see any!
The fundamental problems a database engineer thinks about in the shower
Introduction Postgres queue tech is a thing of beauty, but far from mainstream. Its relative obscurity is partially attributable to the cargo cult of “scale”. The scalability cult has decreed that there are several queue technologies with greater “scalability” than Postgres, and for that reason alone, Postgres isn’t…
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
Personal website of Phil Booth
Beating another dead horse.
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
After analyzing 1000+ Y-Combinator Companies, I discover there's a huge market need for more engineering-focused data practitioner roles.
