On: MySQL for Developers

[whitepoplar]

Cool! Now we need this for Postgres.

[winrid → whitepoplar]

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

[blowski → whitepoplar]

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

[systems → blowski]

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

[paxys → systems]

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.

[craigkerstiens → paxys]

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

[acomjean → whitepoplar]

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…

[pphysch → acomjean]

Outside of SQL they are different technologies.

MySQL mingles its custom language with SQL which is a common point of confusion... Whom amongst us wasn't confused when "DESCRIBE" didn't work in SQLite or Postgres?

[FinalBriefing → pphysch]

Are they really different technologies? It has always been my impression that they are the same tech, but they have a slightly different syntax in some places (DESCRIBE) and different levels of capabilities (Postgres offers more).

If you know the core concepts of one, you are probably 80% good to go with the other.

[wlll → FinalBriefing]

> Are they really different technologies?

Yes, your impression is wrong.

[dotancohen → FinalBriefing]

MySQL and Postgres are completely different technologies that are both accessed by a similar interface.

[aarondf → whitepoplar]

I agree, there's a huge desire for this! I don't know the first thing about Postgres though, so it's not gonna be me :)

There's an opportunity for a creator here.

[manv1 → whitepoplar]

You mean postgres | postgreSQL | pg | pgsql?

[elforce002 → whitepoplar]

100x this.