News for hackers. Stuff that matters.

A comment on Homebrew removes MongoDB from core formulas. Parent comment

Re:Homebrew removes MongoDB from core formulas by goto11 on Tuesday September 03, 2019 @02:21AM (#20864105)
Relational/SQL databases still follow the same fundamental data model and query language, despite the differences in SQL syntax. I will argue migration is still easier. Just avoid stored procedures which complex logic, since these are essentially proprietary programming languages.
[ Parent | on HN ]
Re:Homebrew removes MongoDB from core formulas by statictype on Tuesday September 03, 2019 @08:21AM (#20865801)
Even without stored procedures, its not easy.

To really take advantage of a database engine, you will probably end up using engine-specific idioms.

Postgres and Sql Server support recursive CTEs. MySql probably doesn't?

Sql Server supports cursors but is dog slow and generally not recommended for any sort of large scale operations.

Isolation levels and locking are really important as well. Do all engines even support the same isolation levels?

[ Parent | on HN ]