I don't have the experience to compare them to Oracle, but SQL Server and Postgr... | Hacker News

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

		yyyk on Sept 10, 2021 \| parent \| context \| favorite \| on: Problems with Oracle SQL 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-...

tomrod on Sept 10, 2021 [–]

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.

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