1381
Reddit’s database has two tables (2012)
Steve Huffman talks about Reddit’s approach to data storage in a High Scalability post from 2010. I was surprised to learn that they only have two tables in their database.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1382
Let's Talk SkipList
the forgotten data structure (not really)
1383
Having, a less understood SQL clause
Understanding how the group by and having clauses work can help us write more efficient SQL. I want to demonstrate this with an example…
1384
1385
Airflow's Problem
In 2022, data engineers manage forests, not trees
1386
The many flavors of hashing
About the many types of hash functions, their use-cases, dos and don'ts, with suggestions for currently accepted algorithms.
1387
Overview of Consistency Levels in Database Systems
Database systems typically give users the ability to trade off correctness for performance. We have spent the previous two posts in this s...
1388
EdgeDB 2.0
Today we're excited to announce the release of EdgeDB 2.0, the latest version of our graph-relational database.
1389
1390
Do data-driven companies win?
Some gut-based judgements on the effectiveness of data.
1391
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
1392
SQLite Internals: Pages and B-trees
Let's open a hex editor and see what this thing is made of
1393
RStudio Is Becoming Posit
We are very excited to announce that RStudio has a new name, Posit.
1394
Shipping Multi-Tenant SaaS Using Postgres Row-Level Security
At Nile, we’re making it easier for companies to build world-class control planes for their infra SaaS products
1395
Propagation of mistakes in papers
A blog by and for database architects.
1396
Dicom File Format Basics
Explore the fundamentals of the DICOM file format! This quick introduction covers the basics of DICOM's structure, its essential uses, and tips for easily navigating its complex and abstract components.
1397
1398
ML is not that good at predicting consumers' choices
I wanted to share the attached paper on choice prediction that I recently co-authored with Itamar Simonson in case it’s of interest.
1399
Pretty maps in Python
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
1400
Soft deletion probably isn't worth it
The traditional soft deletion pattern using <code>deleted_at</code> columns leaks into code, curbs the usefulness of foreign keys, and makes data removal difficult. Luckily, there’s an alternative.
1401
New method identifies the root causes of statistical outliers
Amazon ICML paper proposes information-theoretic measurement of quantitative causal contribution.
1402
Analyzing Indie Hacker Products with Verified Revenue
Indie Hackers is a wonderful community for founders, a vast ocean of shared knowledge and a place to showcase your product journey. A lot of people are sharing their products there along with the revenue, often verified by Stripe. We analyzed the available data to check how much revenue are those products making and…
1403
Implementing "seen by" functionality with Postgres
Different approaches for tracking visitor counts with PostgreSQL.
1404
1405
I disagree with Turing and Kahneman regarding statistical evidence (2014)
It’s funny. I’m the statistician, but I’m more skeptical about statistics, compared to these renowned scientists.
1406
PostgreSQL views and materialized views and how they influenced TimescaleDB
Continuous aggregates are one of Timescale's most popular features, but you can’t fully understand them without some context on Postgres views and materialized.
1407
The DynamoDB Paper
This week at USENIX ATC’22, a group of my colleagues 1 from the AWS DynamoDB team are going to be presenting their paper Amazon DynamoDB: A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service . This paper is a rare look at a real-world distributed system that runs at massive scale.
1408
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
1409
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
1410
Postgres full-text search: A search engine in a database (2021)
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.