Did you ever think about how Instagram, Twitter, Facebook or any social media platforms track who... Tagged with beginners, database, scylladb, architecture.

Anmol Baranwal

Spotify

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

Explore how social media platforms track likes and the challenges of data modeling for likes in a database, with a focus on the use of ScyllaDB and counters.

Database 101: How social media “likes” are stored in a database

Great write up!
I think that this is a good example on where streaming databases like Materialize can really help. You can essentially create a live materialized view and the result will be kept up to date as the data comes.
In traditional DBs, data is stored in tables matching the structure of the writes (inserts, updates) and all the computation work happens on read queries (selects). A streaming database moves the work to the write side: Instead of just storing data on writes, a streaming database asks for the queries upfront (in the form of Materialized Views) and incrementally updates results as input data arrives.

Super informative, thanks for sharing 🚀

does fb, insta and other social networking sites use same approach?

Nice approach, I am currently working on something similar so it will help a lot!