4 ms·
It compiles to SQL, so the actual execution plan is as arbitrary as the SQL this compiles to. I love database where queries and commands are not declarative bu
by ralfn 5y ago
It compiles to SQL, so the actual execution plan is as arbitrary as the SQL this compiles to.
I love database where queries and commands are not declarative but imperative. Like RethinkDB or Mongo.
Databases with this type of syntax.
But to use this syntax for an SQL database is a horrible mistake, because it is misleading.
- Yoric 5y agoI believe that declarative is typically better at letting the db compile it to something efficient while imperative is typically better when the author of the request knows exactly what they're doing. > It compiles to SQL, so the actual execution plan is as arbitrary as the SQL this compiles to. Yes, I'm purely talking syntax. I find the syntax of SQL to be arbitrary. Do I need a single quote or two? Do I need parentheses here? Or double parentheses? What does this bind, exactly? I believe that there is lots to be gained by making the syntax more regular, without affecting semantics.