3 ms·
>If it had been SQL it would have been easy to drop in another database. Hahaha. No. If anything, migrating from something like Mongo might possibly be easier
by statictype 7y ago
>If it had been SQL it would have been easy to drop in another database.
Hahaha. No.
If anything, migrating from something like Mongo might possibly be easier. Because it's non-relational, you probably have very little business logic in your database layer.
Unlike with Sql.
And even though Sql has a standard syntax, beyond vanilla CRUD queries, there are many differences. Even if 2 engines support the same synatx, the idiomatic way of doing something will differ.
(For example, cursors in Sql Server is extremely slow, whereas its a perfectly acceptable way of doing list operations in Postgres)