34,070 views
Presentation https://flagstudio.ru/content/db/ 00:55 — Contents 01:59 — DB and DBMS. MySQL vs PostgreSQL 03:58 — DB composition. Indexes, transactions, triggers on the fingers 07:10 — SQL vs NoSQL 11:40 — Data types in the Nova admin panel 14:15 — JSON field. NoSQL inside SQL DBMS 15:27 — How to describe fields in the technical specifications 17:31 — Relationship types 19:55 — Relationship, string or JSON? Selecting a field type 24:00 — How to describe relationships in a technical task 27:17 — How to design relationships in a database 30:34 — Primary and Foreign keys 32:00 — An important OnDelete limitation 34:30 — Normalization 36:48 — Life hacks 39:18 — Migrations, seeds, dumps Learn Git in practice: https://gogit.ru/ Our channel in Telegram: https://t.me/flagstudio VK: https://vk.com/flagstudio Instagram: / thisisflagbaby