Hacker News new | ask | show | jobs
by SadWebDeveloper 1180 days 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.
2 comments
aarondf 1180 days ago
Oh 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!

link
Aeolun 1180 days ago
But then, most devs wouldn’t want their procedures inside the database anyway (with attendant lack of integration/versioning).
link