4 ms·
As an alternative to an ORM, there is another great abstraction layer that works across a large number of databases. It's called SQL!
by jimbokun 7y ago
As an alternative to an ORM, there is another great abstraction layer that works across a large number of databases. It's called SQL!
- kingbirdy 7y agoThat's true in theory, but unfortunately you can still run in to issues when different databases support different parts of SQL, and the db you're migrating from has different features than the one you're migrating to.
- shakna 7y agoThere are a huge number of differences in the SQL supported by different engines. You can't just switch from one to another, unless you're only using a small subset of SQL to begin with.
- imtringued 7y agoUntil you realize that not even booleans are standardized between SQL dialects...
- legulere 7y agoHow do you insert a row and get the automatically set Id set by the database portably? That’s a standard create operation.