PostgreSQL、Supabase与数据模型的数据库设计
甄选并验证：Abhishek Kumar, Backend Engineer, PayPal大多数数据问题都不是Bug，而是决策——几个月前仓促做出的决定，某人急需一张表，建完后再也没管过。列表被塞进一个逗号分隔的列，价格存成浮点数导致每第一千笔订单损失一分钱，某张表任何人都能从互联网读取，因为没人打开一个开关。等到问题浮现时，数据已成现实，修复意味着凌晨两点的迁移。 本课程教你刻意做出那些决策，在还没有数据可丢失之前。 你会从需求开始，而不是从表编辑器开始。你将学会如何将领域转化为实体和关系，再转化为规范化的PostgreSQL模式，使用符合现实的键和类型。你将认识到约束比应用层的验证更强大——数据库本身不允许任何人违反的规则，包括你忘记的第二个客户端。你将了解当多个用户同时出现时，索引、事务和隔离行为如何运作。由于基于Supabase，你会明白你的模式就是API和安全边界：行级安全、角色和策略精确决定谁能看到哪一行。 然后是实际模式——JSONB、全文搜索、软删除、层次结构、多租户——以及那些看似聪明却悄然剥夺了数据库本该提供的一切的反模式。 四十二节课，每节课都以同样的方式结束：现在你知道何时使用它，以及为什么。
课程目录
关于课程作者
Abhishek Kumar is the engineer teams trust with the parts of a product that cannot quietly break—authentication, payments, data synchronization, and the APIs on which other services depend. Over eight years, he has decomposed legacy applications into independently deployable services, designed event-driven workflows, and improved heavily used systems through query tuning, caching, asynchronous processing, and careful capacity planning. His working environment spans Java, Python, Go, and Node.js, supported by PostgreSQL, Redis, Kafka, Docker, Kubernetes, and AWS. Abhishek remains involved after deployment, tracing production failures, strengthening observability and automated testing, reviewing architecture decisions, and helping younger engineers develop the judgment required to keep complex systems fast, secure, and recoverable.
评价 (12)
- cheery_salmon
super clair !
- peppy_mink
super helpful
- jade_explorer
kinda boring, too many slides.
- sassy_cuttlefish
Quá cơ bản, không có gì mới.
- cheerful_aardvark
great stuff