MySQL now has window functions: https://mysqlserverteam.com/mysql-8-0-2-introduc... | Hacker News

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

		cwyers on July 16, 2019 \| parent \| context \| favorite \| on: Anyone made the jump from MySQL to PostreSQL? It i... MySQL now has window functions: https://mysqlserverteam.com/mysql-8-0-2-introducing-window-f... And MySQL has strict mode, which I believe is enabled by default on newer versions but available in any 5.x version: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mo...

zaphar on July 16, 2019 [–]

Strict mode is like 1/4'th of the safety that PostgreSQL gives you. Robust types for columns. Safe transaction semantics. Better tools for enforcing data consistency.

MySQL has a long way to go before it can give you the same security for you data that PostgreSQL does.

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