Topics /
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
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…
Learn how to build automated PDF reports in Python with Jupyter and Mercury, including scheduling, charts, and email delivery workflows.
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
mrjob: Distributed Computing for Everybody Dave M Search and Data-Mining Engineer Oct 29, 2010 Ever wonder how we power the People Who Viewed this Also Viewed… feature? How does Yelp...
I have to admit, my research blog posts are getting longer and longer. From one side I find it genuinely encouraging, because if one gets so much information just by scratching the topic, imagine what’s hidden beneath the surface! One university professor once said “what could be interesting in databases?”, and it…
ATMSeer is an interactive visualization tool for users to see and control algorithms and hyperparameters of machine-learning (AutoML) systems. The work was developed by researchers in the MIT Laboratory for Information and Decision Systems (LIDS), Hong Kong University of Science and Technology (HKUST), and Zhejiang…
A few weeks back, we published a draft of an article entitled _Monotonicity Types_. In it, we describe a type system which we hope can aid the design of distributed systems by tracking monotonicity with types....
Building the platform where people around the world come to search, save and shop
In this talk, Andrew Hyatt shows how to use SQLite to store and retrieve information using the triples package. Afterwards, he wil handle questions over BigBlueButton.
Object-Relational Mappers get a lot of hate from people who misjudge the complexities of the task.
Take a closer look into why—and where—top programming languages are popular.
Last weekend I tweeted two links to two tweets by a poor guy who apparently got his MongoDB database into an unrecoverable state during shutdown whilst upgrading to a newer version. That tweet quickly made the rounds, and the next morning I saw myself staring at replies stating that it was all his fault, because he…
[This is part two in a series — you should read part 1 first for context and then you might go on to part 3.] The Dublin Core — metadata made dumb Just when librarians were in despair o…
Dissecting the Octopus
Query performance often varies depending on how you write queries. For PostgreSQL, what provides better performance? The IN or OR operator?
This analysis was featured on: The Hustle newsletter (lead story), TechCrunch, Hacker News, The Growth Newsletter (issue #021), Social Blade, Data Science...
We've been using RethinkDB in production for almost a year. RethinkDB is an open-source database designed to make it dramatically easier to build and scale real-time apps. Last week, the 2.0 release of RethinkDB landed and it was given a shiny "Production Ready" badge. After five years of development, RethinkDB is…
In July 2020, I stumbled into a fundamental limitation in the general-purpose database design for transaction processing.
No single cloud fits all. Explore how we build a more flexible future with hybrid cloud.
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
Software engineer, etc etc
Building the platform where people around the world come to search, save and shop
What do nested transactions look like in an ACID environment? We explore the journey of a nested SQL transaction in CockroachDB in this post.
There has been quite a bit of furor and excitement on the Internet this week regarding some very public criticisms (and defenses) of MongoDB and its creators, 10gen . Unfortunately, a ghost from my recent past also resurfaced as a result. Let me begin by apologizing to 10gen and its engineers for what I said at JSConf…
If you’ve had the chance to read our GDPR white paper or our previous GDPR primer blog post, you’ve, no doubt, seen the word "pseudonymization" used extensively to describe one technical measure that ...
