News for hackers. Stuff that matters.

A comment on Problems with Oracle SQL. Parent comment

Re:Problems with Oracle SQL by tomrod on Friday September 10, 2021 @12:37PM (#28483942)
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
[ Parent | on HN ]
Re:Problems with Oracle SQL by yyyk on Friday September 10, 2021 @02:29PM (#28485403)
I 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-...

[ Parent | on HN ]
Re:Problems with Oracle SQL by tomrod on Friday September 10, 2021 @04:54PM (#28486768)
Oh 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.

[ Parent | on HN ]
Re:Problems with Oracle SQL by ptrwis on Friday September 10, 2021 @01:26PM (#28484652)
Exactly, Oracle should be chosen when business logic is written in sql/plsql
[ Parent | on HN ]