← Learn/Part 4 · Data engineering

GadgetHub has grown large. One server can no longer cope. Here are the engineering strategies for scaling and the difference between transactional and analytical systems. The topic is conceptual by nature (replication, sharding, CAP can't be shown with a single node in the browser), so it's mostly quizzes; the practical exceptions are partitioning and the star schema, which run right in PGlite.