Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

MySQL for Developers

planetscale.com

Post reply on HN
Print view View original

21–30 of 119 posts

Re: MySQL for Developers

#22

Post by tracker1 »

MangoCoffee wrote: post #15

nice. i use MS SQL at work and MySql for personal project

Might be worth looking into PostgreSQL as well. It's just as readily containerized (docker) as well as being more ANSI compliant and consistent. I only say this because nearly every time I've ever used MySQL, I find annoyances.

Such as the fact that 'utf8' isn't 'utf8', 'utf8mb4' is... the feature was in testing as utf8 was being standardized and mysql used 'utf8mb3', and never updated the reference for 'utf8' for compatibility, even across major versions.

There's also the fact that collation on indexes for binary fields are case-insensitive if your default collation is, even if it's "binary".

Also, PostgreSQL has nicer support, imo, for JSON (JSONB) data, as well as a rich extension ecosystem.

Re: MySQL for Developers

#23

Post by aarondf »

nidnogg wrote: post #14

Is this really free? I can't quite put my finger on it but it seems so...high quality? Kudos to Aaron though, will gladly dive in later on

Haha thank you! I'm really grateful that everyone at PlanetScale gave me _so_ much time to work on this. We're really committed to doing everything as high quality as we can, even the free stuff. Let me know what you think!

Re: MySQL for Developers

#24

Post by tracker1 »

Can't really comment on the material... but a minor suggestion might be to have a section on ANSI-SQL statements and quotes, and where mySQL/MariaDB breaks the standard (such as foreign key references in table creation). As well as pointing out that you should use 'utf8mb4' for UTF-8, and not 'utf8' encoding.

Re: MySQL for Developers

#25

Post by jordanmoconnor »

aarondf wrote: post #2

Hey HN, I made this course :D The course is a bit more than 7 hours long split over 64 videos. I was always frustrated by the lack of intermediate database content, it seemed like it was mostly intro stuff, or straight to DBA level. So I read as many database books as I could, read through the official docs, and made this course specifically for application developers. If yall have any feedback I'd love to hear it. I…

Nice work! Congrats on shipping it

Re: MySQL for Developers

#26

Post by mschuster91 »

tracker1 wrote: post #22
MangoCoffee wrote: post #15

nice. i use MS SQL at work and MySql for personal project

Might be worth looking into PostgreSQL as well. It's just as readily containerized (docker) as well as being more ANSI compliant and consistent. I only say this because nearly every time I've ever used MySQL, I find annoyances. Such as the fact that 'utf8' isn't 'utf8', 'utf8mb4' is... the feature was in testing as utf8 was being standardized and mysql used 'utf8mb3', and never updated the reference for 'utf8' for co…

PostgreSQL, however, is one hell of a PITA to upgrade. Keeping a cluster of MySQL machines alive is way easier than PostgreSQL, not to mention how easy it is to shoot yourself in the foot with its authentication mechanisms.

Re: MySQL for Developers

#27

Post by aculver »

nidnogg wrote: post #14

Is this really free? I can't quite put my finger on it but it seems so...high quality? Kudos to Aaron though, will gladly dive in later on

Yeah, you're not alone. Aaron posted a thread on Twitter that shares the inside skinny on what it took to ship this course (https://twitter.com/aarondfrancis/status/1638191349261377539) but I had an early peek into the work he was doing on this course, and there was a clear inflection point in the project when he joined Planetscale and had the benefit of being able to focus a substantial amount of his time on it in addition to all the work other members of the team there were able to contribute to it. Very grateful that Planetscale unlocked this so it's available as a free resource instead of having to be behind a paywall to support its creator.
Post reply on HN