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

71–80 of 119 posts

Re: MySQL for Developers

#71

Post by paxys »

systems wrote: post #63
blowski wrote: post #44

Earlier quoted context omitted.

The Art of Postgres is probably it. https://theartofpostgresql.com/

The Art of Postgresql is a book not a video course And unfortunately they dont provide to table of content on the site

Also, while we may see $75 or $150 or whatever as throwaway money (especially in the context of professional help products or books), that price is wildly unaffordable for most of the planet. Having high-quality free educational material out there is a godsend for students and developers in low income countries.

Re: MySQL for Developers

#72

Post by pratikch1253 »

This is perfect I was looking for something like this will definitely be checking it out over this weekend one request please give us the training data set you use for this course so that we can follow along with all the sql queries you are typing.

Re: MySQL for Developers

#73

Post by aarondf »

pratikch1253 wrote: post #72

This is perfect I was looking for something like this will definitely be checking it out over this weekend one request please give us the training data set you use for this course so that we can follow along with all the sql queries you are typing.

This is a great idea. Let me see how quickly I can get that done.

Re: MySQL for Developers

#74

Post by craigkerstiens »

paxys wrote: post #71
systems wrote: post #63

Earlier quoted context omitted.

The Art of Postgresql is a book not a video course And unfortunately they dont provide to table of content on the site

Also, while we may see $75 or $150 or whatever as throwaway money (especially in the context of professional help products or books), that price is wildly unaffordable for most of the planet. Having high-quality free educational material out there is a godsend for students and developers in low income countries.

The Art of PostgreSQL is great and super thorough. Knowing the author I can't fault him on price for the effort he put into it.

But also your point of students and developers in low income countries completely understand that side. It's a shameless plug but we built our Postgres playground with tutorials on a number of topics which are completely free aiming to help target some of that audience - https://www.crunchydata.com/developers/tutorials

Re: MySQL for Developers

#75

Post by manv1 »

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…

PosgreSQL has its share of annoyances, like case preserving case insensitivity and inconsistent naming of its tools/config files.

Nothing like trying to do a select on a table/column that you know is there and getting an error...becuase the table/column was created with quotes by your ORM so it doesn't automagically get case in-sensitized.

It's maddening.

Re: MySQL for Developers

#76

Post by KronisLV »

It's really nice to see more content for MySQL/MariaDB still being made, since it feels like they are still good solutions for a whole variety of situations! While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough!

Re: MySQL for Developers

#77

Post by hu3 »

KronisLV wrote: post #76

It's really nice to see more content for MySQL/MariaDB still being made, since it feels like they are still good solutions for a whole variety of situations! While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough!

> While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough

I see this sentiment often here on HN. Something long the lines of "MySQL is enough for small apps but you want PotgreSQL for serious work."

When in practice I find the opposite to be true. PotgreSQL is hard to scale and hard to upgrade when compared to MySQL. I mean, just take a look at the caliber of companies that leverage MySQL at scale using Vitess to orchestrate it (spoiler, it powers Youtube, GitHub, Slack, Shopify and more):

https://planetscale.com/vitess

What's PostgreSQL comparable list?

Re: MySQL for Developers

#78

Post by anamexis »

manv1 wrote: post #75
tracker1 wrote: post #22

Earlier quoted context omitted.

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…

PosgreSQL has its share of annoyances, like case preserving case insensitivity and inconsistent naming of its tools/config files. Nothing like trying to do a select on a table/column that you know is there and getting an error...becuase the table/column was created with quotes by your ORM so it doesn't automagically get case in-sensitized. It's maddening.

I would never have expected any identifiers to be case insensitive, personally.

Re: MySQL for Developers

#79

Post by AYBABTME »

KronisLV wrote: post #76

It's really nice to see more content for MySQL/MariaDB still being made, since it feels like they are still good solutions for a whole variety of situations! While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough!

If by "advanced in-database processing" you mean stuff like PostGIS, then yes PostgreSQL is the right approach. But for most people building web-apps to scale, or established businesses who want to pick a solution and stick to it for basically ever, MySQL is much easier to scale. There's a ton of companies running MySQL at scale. I never heard of the same for Postgres, and for a long while I had an intellectual preference for Postgres as being the more "pure" implementation. Experience in the field showed me that MySQL, despite its flaws, is the name of the game.

Further "evidence" by referring to other experienced folks who worked on scaling SQL databases, and MySQL is what's used and what folks have experience with:

   - https://twitter.com/Sirupsen/status/1602347646961606656
   - https://blog.nelhage.com/post/some-opinionated-sql-takes/#my-personal-choice-mysql

Re: MySQL for Developers

#80

Post by mulmen »

hu3 wrote: post #77
KronisLV wrote: post #76

It's really nice to see more content for MySQL/MariaDB still being made, since it feels like they are still good solutions for a whole variety of situations! While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough!

> While I might look in the direction of PostgreSQL for more advanced in-database processing, for most CRUD apps the aforementioned two are going to be more than enough I see this sentiment often here on HN. Something long the lines of "MySQL is enough for small apps but you want PotgreSQL for serious work." When in practice I find the opposite to be true. PotgreSQL is hard to scale and hard to upgrade when compared…

> What's PostgreSQL comparable list?

Netflix, Instagram, Spotify, Skype, Reddit, Twitch, Yahoo.

e: removed Uber.

Post reply on HN