4 ms·
Why can't we just have SQL92 on the client side along with some nice API that accepts keyed JSON objects and performs the standard CRUD operations with them. I
by eob 16y ago
Why can't we just have SQL92 on the client side along with some nice API that accepts keyed JSON objects and performs the standard CRUD operations with them.
I get that people want simple Key-Value and Object storage APIs because they provide nice abstractions for a particular set of use-cases, but that doesn't warrant throwing out relational databases & SQL.
The correct fix for this is to require full SQL92 compliance in the HTML spec, patch up SQLite to plug its areas of noncompliance, and then let framework designers address data access APIs (that all persist to relational data) at the JavaScript leve.
- mjw 16y agoIndeed. It's absolutely trivial to write an reasonably-performing key-value store on top of even the most minimal subset of SQL. The reverse is most certainly not true.