Hacker News Reader

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.

View on HN

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!

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

Reply on news.ycombinator.com