Arc Notes Weekly #7: Trade Offs

This week's post covers a few systems design rundowns (multiplayer games architecture and chess engines) and a new DSL for SQL.

A bit of a slower week this time around! A few systems design rundowns and a new DSL for SQL. ICYMI, we sent out a post last week on the Thing You Should Know series on databases! Check it out here.

Enjoy this week's round-up!

Mahdi (@myusuf3)

News

SQLite or PostgreSQL? It’s Complicated!

Moving an application from SQLite to PostgreSQL. With some interesting benchmarks and take aways. 

Modern Cloud for Multiplayer Games

Informative article on modern cloud multiplayer games architecture!

Best Linux Commands For Advanced Hardware and System Info

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.

I really wish more people would host articles on their own domains. This is an article describing how to build a chess engine from scratch. 

Twitter Sparrow tackles data storage challenges of scale

An article on how Twitter uses Sparrow to make sense of trillions of events with a latency in the range of a few hours

🐦 We are building the largest system design community on the internet! We would love for you to join us. You can find us here on Twitter.

Projects

GitHub - prql/prql: PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement. Cool concept, but you are going to have to pry SQL from my hands. 

♥️ The Favourites - this section won't make an appearance every week, will usually be something that was a particularly high point in tech that impacts us all. If you see something worthy of the favourite, tag us at @arcnotes

Give Up GitHub: The Time Has Come!

Well worth the read!