Hacker News new | ask | show | jobs
by spapas82 1256 days ago
Yes that's true. But please consider that some orgs prefer self hosting their software. In this case using their database would be preferable.
1 comments

In that case, only using ANSI SQL will help (i.e. no vendor-specific queries).
Unfortunately, you can't count on the enterprise's pre-existing DB to support all of ANSI SQL well. Oracle in particular deviates from ANSI in a whole bunch of well-known ways (messed-up date types, treating the empty string, '', as the same thing as NULL, etc., etc.), which are almost certain to trip up SQL which hasn't been tested against it.