3961
The metrics behind Spotify’s IPO
Spotify's direct listing IPO filing reveals how monthly churn fell from 7.7% to 5.5% as personalization and family plans drove subscriber retention at scale.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3962
Testing Postgres race conditions with synchronization barriers
Synchronization barriers let you test for race conditions with confidence.
3963
Vitess 18
Vitess 18 is now generally available, with a number of new enhancements designed to improve usability, performance, and MySQL compatibility.
3964
3965
How is efficacy vs. severe disease strong if 60% of hospitalized are vaccinated?
A surge involving the rapidly-transmitting Delta variant in heavily vaccinated countries has led to much hand-wringing that the vaccines are not effective against Delta, or vaccine effectivenss wanes after 4-6 months. This has fueled anti-vaccine sentiment suggesting the vaccines are not working, and causing much…
3966
How/why to sweep async tasks under a Postgres table
I like slim and stupid servers, where each endpoint wraps a very dumb DB query. Dumb queries are fast. Fast queries make websites smooth and snappy. Keep those click/render loops sacred. Sweep complexity under a task table.
3967
A Look Inside Our 210TB 2012 Web Corpus
Want to know more detail about what data is in the 2012 Common Crawl corpus without running a job? Now you can thanks to Sebastian Spiegler!
3968
The Consortium for Python Data API Standards
An initiative to develop API standards for n-dimensional arrays and dataframes
3969
Why we didn't use a bloom filter
Josiah Carlson talks about Redis, Python, and other technology topics.
3970
Displaying Content as a Graph
Most web content is displayed as a strict hierarchy, tree-based or otherwise. What if it wasn't?An exploration into the advantages of graph-based content design, the numerous pitfalls, and a few case studies along the way.
3971
3972
3973
NYC has released data for every tax lot in the city. Here is my first look
Many thanks to advocates inside and outside who worked tirelessly for years to liberate one of New York City’s most fundamental datasets. Many more thanks to the efforts of Department of City Planning, DoITT, and the Chief Analytics Officer’s office. THANK YOU!
3974
Nonnegative matrix factorization
The why and how of nonnegative matrix factorization Gillis, arXiv 2014 from: ‘Regularization, Optimization, Kernels, and Support Vector Machines.’ Last week we looked at the paper ‘Beyond news cont…
3975
Text Matching Using Cosine Similarity
Recently I was working on a project where I have to cluster all the words which have a similar name. For a novice it looks a pretty simple job of using some Fuzzy string matching tools and get this done. However in reality this was a challenge because of multiple reasons starting from pre-processing of the data to…
3976
3977
3978
3979
DBLog: A Change-Data-Capture Framework
Andreas Andreakis, Ioannis Papapanagiotou
3980
3981
Analysis of 419,000 FlapMMO attempts
FlapMMO is a new and popular browser game inspired by Flappy Bird. Unlike Flappy Bird, though, each server has hundreds of other players and you can all see each other. It's lots of fun and I previously posted about hacking FlapMMO for mouse control .
3982
Amazon DynamoDB Update – Global Tables and On-Demand Backup
AWS customers in a wide variety of industries use Amazon DynamoDB to store mission-critical data. Financial services, commerce, AdTech, IoT, and gaming applications (to name a few) make millions of requests per second to individual tables that contain hundreds of terabytes of data and trillions of items, and count on…
3983
Ebtrees: Elastic Binary Trees (2011)
Administrivia This article was initially posted on Wikipedia in 2008, which explains why it's written at the 3rd person and looks familiar...
3984
3985
3986
Following a Select Statement Through Postgres Internals
Find out for yourself how Postgres works internally. Learn what a postgres server does when it receives select statements and how it understands SQL.
3987
3988
Using watermarks to coordinate change data capture in Postgres
Explore the challenges of building a change data capture (CDC) pipeline for Postgres. And see how Sequin used a watermark design inspired by Netflix's DBLog.
3989
3990
21,864 Yugoslavian .yu domains
TLDR; get a list of 21,864 domains from the former Yugoslavia’s “.yu” top level domain: download the .CSV