5 ms·

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 differenc

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 4y ago
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 4y ago
  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 4y ago
    > Are they really different technologies? Yes, your impression is wrong.
  - deleted 4y ago
    [deleted]
  - dotancohen 4y ago
    MySQL and Postgres are completely different technologies that are both accessed by a similar interface.
- deleted 4y ago
  [deleted]
deleted 4y ago
[deleted]