3 ms·
I feel Postgres and SQL Server are easier to grok error states. Oracle seems to want to be an application platform more than a datastore
by tomrod 5y ago
I feel Postgres and SQL Server are easier to grok error states. Oracle seems to want to be an application platform more than a datastore
- ptrwis 5y agoExactly, Oracle should be chosen when business logic is written in sql/plsql
- yyyk 5y agoI don't have the experience to compare them to Oracle, but SQL Server and Postgres do have their own issues. The infamous MSSQL "string or binary data will be truncated" error (fixed a while ago[0]), or the way either deals with unqualified access to columns which leads to surprises (e.g. in MSSQL subqueries or in Postgres's SECURITY DEFINER procedures). [0] https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver15#tf460 https://docs.microsoft.com/en-us/sql/t-sql/database-console-...
- tomrod 5y agoOh indeed, they all have quirks. Oracle seems to have more than most, IMO. I have a journeyman data engineering level experience with each. Rare combo I guess, Data Scientist focus.