5 ms·
Quite difficult to review that many hours of video but from the syllabus there are probably some missing pieces, mainly stored procedures and triggers, yes i kn
by SadWebDeveloper 4y ago
Quite difficult to review that many hours of video but from the syllabus there are probably some missing pieces, mainly stored procedures and triggers, yes i know MySQL sucks for that particular job and probably you didn't touch them because planetscale probably doesn't support them (not a planetscale dev but this is my wild guess).
Also didn't see any topic on choosing the right charset/collation for the right data and why.
- aarondf 4y agoOh there are definitely missing pieces! I tried to cover the "meaty middle" of what application developers usually need to know. I did not cover stored procedures and triggers. I did cover CTEs and windows, which are not yet supported by PlanetScale. I also covered foreign key constraints, which are not yet supported by PlanetScale. As far as charset and collation, I cover that a bit in the "strings" video of the "Schema" section. Let me know if you have any other feedback!
- Aeolun 3y agoBut then, most devs wouldn’t want their procedures inside the database anyway (with attendant lack of integration/versioning).