4 ms·
Interesting, I wasn't aware PostgreSQL didn't have UPSERT until now. MySQL has INSERT on DUPLICATE functionality that is similar.
by overcast 11y ago
Interesting, I wasn't aware PostgreSQL didn't have UPSERT until now. MySQL has INSERT on DUPLICATE functionality that is similar.
- avidal 11y agoYep. Been a long requested feature. One of the reasons why the post states: "This feature also removes the last significant barrier to migrating legacy MySQL applications to PostgreSQL."
- overcast 11y agoRoger that.
- avar 11y agoWhat do they mean by "legacy" in this context? INSERT ... ODKU is not a legacy feature of MySQL, it's a currently supported first-class feature of the database, nor is MySQL itself a "legacy" database.
- brlewis 11y agoI think they're referring to mysql. The sentence would have worked just as well without the word "legacy". I say this as someone who prefers PostgreSQL.
- X-Istence 11y agoNo, they are referring to an application that is being moved from MySQL to PostgreSQL. The application is "legacy" in that it is an older version and the new version is "current". Due to the English language however there can be some debate as to what they meant. In this case "legacy" is most likely meant to describe the "MySQL application" not "MySQL" itself.
- brlewis 11y agoYou're wrong about which meaning is more likely. A meaning that adds something to a sentence is a more likely meaning than one that adds nothing to a sentence. If you take "legacy" to mean "being migrated from" then the sentence becomes This feature also removes the last significant barrier to migrating being-migrated-from MySQL applications to PostgreSQL. It's more likely that if "being migrated from" was the intended meaning, they would have simply left the word out.
- elbear 11y agoYour comment assumes the author of the release notes has perfect command of the English language and they thought through in detail what the word "legacy" would mean in this context.
- brlewis 11y agoNot at all. First, my comment says "more likely" so it isn't assuming anything. Second, if we change "more likely" to "definitely", the assumption is merely that the sentence in question is written with the same command of the English language as the rest of the announcement, i.e. no egregiously redundant words.
- pbreit 11y agoFrom Google: "denoting software or hardware that has been superseded but is difficult to replace because of its wide use" Maybe not a perfect word but very easy to understand in the context.
- brlewis 11y agoThat definition does not help the argument that "legacy application" is a more likely meaning than "legacy mysql". In the sentence in question, the application hasn't been migrated yet, so clearly it has not been superseded.
- orf 11y agoReplace MySQL with Django. Do you assume Django itself legacy, or the Django based application? I parse it correctly as "a legacy application that uses MySQL".
- scidev 11y agoLegacy applications, not legacy MySQL feature.
- greenleafjacob 11y agoIf you are switching from MySQL to Postgres, then it's legacy by definition rather than intrinsic properties of MySQL.
- desdiv 11y agoIronically the first two google results for "UPSERT" is from wiki.postgresql.org.
- overcast 11y agoShows how long it's been in the works, and requested.