Avatar
Kafai
4286a1dc03c206fe8d877d45c55d82b55a140b4e1bbae8e0546e138119a2561d
Learning software internal

Best virtual machine. There is no second best.

You will start to appreciate Let it crash and supervision tree from BEAM after you realise how bad we programmer code are.

Anything that’s more overloaded than page in computer science ?

TIL. For pure functions, you can hash the implementation and only re-run the test if the hash changes(work particularly well in CI)

When you learn more about database internal, you started to think more about b+-tree, LSM-tree, pages instead of only logical tables.

Partitioning table in #postgres means smaller table and smaller tables allow faster vacuum which will potentially improve query performance by

- less bloat (due to more up-to-dated xmin)

- fewer heap fetch due to more up-to-dated VisibilityMap

A good sign that you’re learning something worthwhile is when even LLMs struggle with it.

One of the best video explaining actor model. #elixir devs should watch it.

https://youtu.be/7erJ1DV_Tlo?si=zATwn_HsJA8mcSF6

Most people have been vibe coding in untyped language like JS, Python before LLM became widespread.

PostgreSQL was shipped with a time-travel queries feature but was replaced by WAL for performance :(