4 ms·
First sentence of http://en.wikipedia.org/wiki/SQLite#Features http://en.wikipedia.org/wiki/SQLite#Features : "SQLite implements most of the SQL-92 standard for
by davidjohnstone 12y ago
First sentence of http://en.wikipedia.org/wiki/SQLite#Features http://en.wikipedia.org/wiki/SQLite#Features : "SQLite implements most of the SQL-92 standard for SQL but it lacks some features."
- deleted 12y ago[deleted]
- fidotron 12y agoEasy example: write a webapp that relies on SQLite's lack of type safety then encounter a browser that implements your vision of SQL but using a type safe backend. It'll break. This is why for this it's important implementation and spec are separated. Further, the trend for in browser APIs is for them to be lower level than previously. (See also WebGL, asm.js etc.). You could build an SQL abstraction over IndexedDB if you really want SQL querying, but people have noticed that the killer property for in browser DB libs is going to be replication and syncing after having disconnected - something a traditional SQL DB is not going to help with. For this reason PouchDB is closer to the API devs will actually be using day-to-day in web apps.