3 ms·
Yeah, but the abstraction layers get in the way if/when I need to optimize queries or use special features, plus it's easier to just write SQL. I'd rather targe
by hot_gril 4y ago
Yeah, but the abstraction layers get in the way if/when I need to optimize queries or use special features, plus it's easier to just write SQL. I'd rather target a specific DBMS and rewrite my queries if I ever change it.
> ignoring the ORM part
As it should be :)
- nl 4y agoNo, all (?) these things let you pass raw SQL straight to the database. In the case of JDBC and ODBC (and I think DB-API) thats all they do.
- hot_gril 4y agoBut raw SQL made for Postgres doesn't necessarily work for SQLite and vice versa. That's what I mean by the SQL standard being thrown out the window. You might be able to write SQL that works in both if you're careful and avoid a lot of features.