Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Yes that's true. But please consider that some orgs prefer self hosting their software. In this case using their database would be preferable.


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: