4 ms·
How do you make event triggers in MySQL? How do you make a system-versioned table/query in PostgreSQL? How do you port regular expressions to MS SQL Server?
by ttfkam 5y ago
How do you make event triggers in MySQL?
How do you make a system-versioned table/query in PostgreSQL?
How do you port regular expressions to MS SQL Server?
How do you set up an exclusion constraint on a range type (without race conditions or invalid data) in anything except Postgres?
Most relational databases fit niches that the other don't. No one RDBMS is best, but they are most certainly not interchangeable.
Even using the lowest common denominator SQL means you'll be missing out on major performance boosts because they each have their own hints/shortcuts.
- phplovesong 5y agoWell if you are comparing non-standard database features you are out of luck. Im talking about the 95% CRUD stuff that you do. Basic selects/joins/aggregations etc. Its super rare i see the need to actually change the underlying database from say postgres to mysql. And in this scenario you are still screwed if you did use a ORM, with database X only features. My point was basic SQL knowledge transfers between databases for the bread and butter 95% of things you need to do.