MySQL for Developers • Hacker News Board

Re: MySQL for Developers

#31

Post by boboroshi » Tue, Mar 21, 2023, 4:19 PM UTC

This looks amazing. Definitely something I'm going to dive into and level up on my SQL skills.

Re: MySQL for Developers

#32

Post by aarondf » Tue, Mar 21, 2023, 4:22 PM UTC

nbosscher wrote: post #3

This is amazing! I've been following Aaron's short database videos on Twitter and he is the real deal. Accessible, straightforward explanations of complex db stuff. I highly recommend checking this out.

Thanks Nate! Excited to get back to short form videos haha. I'm done with long form for a little bit

Re: MySQL for Developers

#33

Post by aarondf » Tue, Mar 21, 2023, 4:24 PM UTC

mijustin wrote: post #17

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…

This is well done! I can see that you've done your research: you've synthesized so much of the written material on MySQL (books, docs) in each lesson. Makes learning these concepts really accessible.

Thank you Justin, that was 100% my intent so that's encouraging to hear. There is a ton of good information, but man so much of it is irrelevant for application developers (as opposed to DBAs). Hopefully this fills that gap!

Re: MySQL for Developers

#34

Post by winrid » Tue, Mar 21, 2023, 4:25 PM UTC

whitepoplar wrote: post #5

Cool! Now we need this for Postgres.

Their product is for MySQL, so I doubt we'll see that soon.

Re: MySQL for Developers

#35

Post by michaelbuckbee » Tue, Mar 21, 2023, 4:40 PM UTC

This is outstanding.

I've always felt that one of the big "level ups" that an app developer can do is get a better understanding of how databases work and how/when to leverage their features.

The course kind of feels like cheating as it's so much less effort than slogging through all the books and failed projects you'd otherwise need to get the experience.

Re: MySQL for Developers

#36

Post by ano88888 » Tue, Mar 21, 2023, 4:42 PM UTC

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…

this is great. Thank you so much for your effort. Really appreciate it. By the way , if you are starting a startup, will you use mysql or postresql and why assuming you are equally good at both ?

Re: MySQL for Developers

#37

Post by ndstephens » Tue, Mar 21, 2023, 4:42 PM UTC

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…

This looks great!! Hopefully you can answer a couple questions for me.

You mention you're using TablePlus. Doesn't look like it has a free option. Can you recommend another similar database GUI tool so I can "code along"? And is there a database I can connect to and work with? Maybe you answer these at some point in the course, but I didn't see anything in the intro.

Also you mention this is for devs and not DBA's. Do you go over strategies for creating and "maintaining" a new db for a basic app? Or is this for a dev to work against a db that fully created and maintained by a DBA? I'm interested in using PlanetScale for hobby projects, so i'm currently trying to learn about not just using a db, but also being my own DBA (on a very small and basic scale).

Thank you for the course and any feedback on my questions.

Re: MySQL for Developers

#38

Post by ksec » Tue, Mar 21, 2023, 4:46 PM UTC

It is nice MySQL finally reach the front page on HN. Considering MySQL is extremely unpopular among folks here.

I will take this rare opportunity to ask, anyone knows when MySQL 9.0 is coming?

Re: MySQL for Developers

#39

Post by swyx » Tue, Mar 21, 2023, 4:46 PM UTC

this was both highly anticipated and has been excellently executed. incredible amazing work. thanks Aaron!

Re: MySQL for Developers

#40

Post by acomjean » Tue, Mar 21, 2023, 4:48 PM UTC

whitepoplar wrote: post #5

Cool! Now we need this for Postgres.

I’ve been using MySQL. Is Postgres so different now that the SQL here won’t work? (It may be that it’s MYSQL that’s different)

I know there are some differences in SQL syntax, but in my case we use pretty basic sql…