4021
Everything I've seen on optimizing Postgres on ZFS
Looking to run Postgres on ZFS? I've gathered some of the information and sage advice out there to give you a head start on figuring out how to do it safely and efficiently.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,226 posts.
4022
ZFS on Linux still has annoying issues with ARC size
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…
4023
Automated PDF Reports with Python Notebooks
Learn how to build automated PDF reports in Python with Jupyter and Mercury, including scheduling, charts, and email delivery workflows.
4024
4025
Deconstructing the Postgres planner to find indexing opportunities
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
4026
4027
mrjob: Yelp open sources its Elastic MapReduce framework for Python
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...
4028
Evolution of tree data structures for indexing
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…
4029
Cracking open the black box of automated machine learning
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…
4030
Monotonicity Types: Towards a Type System for Eventual Consistency
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....
4031
Open-sourcing Pinterest MySQL management tools
Building the platform where people around the world come to search, save and shop
4032
Emacs: Using SQLite as a Data Source
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.
4033
OrmHate
Object-Relational Mappers get a lot of hate from people who misjudge the complexities of the task.
4034
4035
4036
The State of the Octoverse: top programming languages of 2018
Take a closer look into why—and where—top programming languages are popular.
4037
MongoDB, Data Durability and Improvements coming in 1.8
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…
4038
Dublin Core's dirty little secret (2010)
[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…
4039
Dabbling with Dagster vs. Airflow
Dissecting the Octopus
4040
When should you use the IN instead of the OR operator in Postgres?
Query performance often varies depending on how you write queries. For PostgreSQL, what provides better performance? The IN or OR operator?
4041
Analysis of all YouTube trending videos in US for 2019
This analysis was featured on: The Hustle newsletter (lead story), TechCrunch, Hacker News, The Growth Newsletter (issue #021), Social Blade, Data Science...
4042
Building Better Node.js Applications with RethinkDB
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…
4043
Rediscovering Transaction Processing from History and First Principles
In July 2020, I stumbled into a fundamental limitation in the general-purpose database design for transaction processing.
4044
The etcd operator: Simplify etcd cluster configuration and management
No single cloud fits all. Explore how we build a more flexible future with hybrid cloud.
4045
Roapi: An API Server for Static Datasets
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
4046
Building a CRUD App with Datomic Cloud Ions
Software engineer, etc etc
4047
Ingesting MySQL data at scale – Part 1
Building the platform where people around the world come to search, save and shop
4048
Nested Transactions in CockroachDB 20.1
What do nested transactions look like in an ACID environment? We explore the journey of a nested SQL transaction in CockroachDB in this post.
4049
MongoDB and Riak, In Context (and an apology)
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…
4050
Protecting GDPR Personal Data with Pseudonymization
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 ...