What does a good SQL index look like? I seeded Postgres with 1 million comments and measured every indexing decision with EXPLAIN ANALYZE: a 17ms sequential… Link to article: https://milanjovanovic.tech/blog/how-to-design-the-right-sql-index

Read More

The home feed looks like the easiest feature in a social app: fetch posts from the accounts you follow, sort, return a page. Link to article: https://milanjovanovic.tech/blog/how-do-you-build-a-social-media-feed-system-design

Read More