3 ms·

Can you clarify this? The reason Oracle is so prevalent is that many companies have millions of lines of code in pl/sql, may use many proprietry Oracle features

by thorin 9y ago

Can you clarify this? The reason Oracle is so prevalent is that many companies have millions of lines of code in pl/sql, may use many proprietry Oracle features which until recently weren't implemented in SQLServer or Postgres. There's also the aggressive license thing and the issue of moving a complex realtime financial system. I've spent years working on large scale Oracle/other db systems for banks and utilities, so interested to hear the story behind this...

michielr 9y ago
When running with sql_mode=ORACLE, the server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. See MDEV-10142, MDEV-10764 and MariaDB-10.3.0 release notes to know the current status. So after the update you can use a (subset) of pl/sql.
- SOLAR_FIELDS 9y ago
  Nice. This really is a shot at Oracle's hegemony when it comes to enterprise databases. Has anyone here done a migration from Oracle's offering to MariaDB? How difficult was it?
- thorin 9y ago
  That's what I was expecting to see but I couldn't find in your post. Thanks for the clarification. Would be good to see a similar mode in postgres as I know pgsql is close, transpilation makes stored procs cool!