Hacker News new | past | comments | ask | show | jobs | submit login

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…




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?


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.


> Are they really different technologies?

Yes, your impression is wrong.


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




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: