Topics /
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
Typically, if you're designing a storage system - such as a filesystem, or a database - one of your major concerns is how to store the data on disk. You have to take care of allocating space for the objects to be stored, as well as storing the indexing data; you have to worry about what happens when you want to extend…
Edit – this post generated a few insightful comments on Hacker News. I’ve also put the code in a notebook for ease of use. Introduction Modern MLOps is complex because it involves too many components. …
Explores SQLite B-Tree index structure with visualizations, explaining on-disk and in-memory storage mechanisms
I had summarized/discussed a couple papers ( Haystack , Memcache caching ) about Facebook's architecture before. Facebook uses simple arch...
Welcome to acronym city! The Court of Appeal of Brussels has made an interesting ruling. A customer complained that their bank was spelling the customer's name incorrectly. The bank didn't have support for diacritical marks. Things like á, è, ô, ü, ç etc. Those accents are common in many languages. So it was a little…
Lessons Learned: Sharding for startups is a technical post about database scalability. What caught my eye was the term . What an odd term — “sharding.” Why would a database be described that way?
This visualization shows the top 29 books ranked by the number of unique users linking to corresponding Amazon pages in Hacker News comments from Oct 2006 to Oct 2015.
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick.
Author: Alexey Makhotkin squadette@gmail.com. Introduction In this database design tutorial (~9000 words) I’m going to show how to design the database tables for a real-world project of substantial complexity. We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is…
Previously, on Jepsen, we saw Chronos fail to run jobs after a network partition . In this post, we’ll see MariaDB Galera Cluster allow transactions to read partially committed state.
In this tutorial we will learn about the concepts behind the SQL syntax. We will go through the basics of how to use the FROM and WHERE clauses, and move on to more advanced topics like joins, aggregations and subqueries.
You can get CS papers published with shoddy statistics, but that doesn’t mean you should. Here are three easy ways to bungle the data analysis in your evaluation section: don’t even try to use statistics when you really ought to; misinterpret an inconclusive statistical test as concluding a negative; or run too many…
You probably have heard about alleged vote fraud in the Russian legislative election 2011. You might even have seen videos about cases of vo...
Often when I’m prototyping a project, I hesitate to use a sqlite database despite their many adavantages . It seems much easier to just dump a bunch of files in a directory and to rely on the universal support for the filesystem API to read/delete/update records. Part of this is avoiding the overhead of figuring out a…
I’ve been working in AI and search for a decade. First, I built Doctrine, the largest European legal search engine, and now I am building Fintool , an AI-powered financial research platform that helps institutional investors analyze companies, screen stocks, and make investment decisions.
Deleting an S3 bucket is harder than you think, and may even cost you money.
I just committed a very important patch to PostgreSQL. The short summary for the patch is " Don't vacuum all-frozen pages. " and it follows...
Fernando Irarrázaval Stream of consciousness about Data Science, Python, and Economics.
Sometimes, I don’t know why I do things. It’s one of these times. A few months ago, Python 3.13 got its JIT engine, built with a new JIT compiler construction methodology (copy-patch, cf. research paper ). After reading the paper, I was sold and I just had to try it with PostgreSQL. And what a fun ride it’s been so…
👉 The decision was close, but the team has decided to keep looking for someone who might have more direct neural net experience.\n👉 Honestly, I think the way you communicated your thought process and results was confusing for some people in the room.\n👉 He’s needing someone with an image analysis background for data…
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
This made it to the Hacker News front-page too: some very interesting comments there
ORM looks great early in a project but breaks down as complexity grows, forcing you to learn SQL anyway. Relations aren't objects. Either use NoSQL for object-like data or write a model layer with real SQL. ORM's abstraction is leaky, its efficiency poor, and the alternatives are better.
On Software, life and everything in-between
Recently while conducting some research, I found myself down the path of Google Analytics ID's as well as other analytics services. I was investigating ways to not only identify varying analytics code in sites, but to correlate them with ot…
