3 ms·
SQLite implements the SQL-92 standard (http://en.wikipedia.org/wiki/SQL-92 http://en.wikipedia.org/wiki/SQL-92 , http://en.wikipedia.org/wiki/SQLite#Features ht
by frik 13y ago
SQLite implements the SQL-92 standard (http://en.wikipedia.org/wiki/SQL-92 http://en.wikipedia.org/wiki/SQL-92 , http://en.wikipedia.org/wiki/SQLite#Features http://en.wikipedia.org/wiki/SQLite#Features ).
Firefox certainly ships with SQLite and even their IndexedDB implementation is based on top of it internally (the irony): https://plus.google.com/+KevinDangoor/posts/PHqKjkcNbLU https://plus.google.com/+KevinDangoor/posts/PHqKjkcNbLU
Microsoft has MS Access JetRed, MS Outlook JetBlue and SQL Express SQL Databases that ship already with Windows and/or Office and are SQL-92 compatible. It should be trivial for them to figure out which SQL DB engine would fit best and integrate it in IE 12.
- davidjohnstone 13y agoFirst 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 13y ago[deleted]
- fidotron 13y 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.
- Pxtl 13y agoI assume that for an embedded DB, MS would be using a variant of Microsft Sql CE, which is their counterpart to SqlLite. And it's terrible.
- tanzam75 13y agoSQL CE is no longer under active development. Most Microsoft tools that need an embedded engine use ESE(Jet Blue), which is bundled with Windows. For third-party desktop developers, the replacement is SQL Express LocalDB. For WinRT developers, Microsoft has paid the SQLite developers to port it over, so that it passes Store validation. Windows Phone still uses SQL CE, but the only interface to it is LINQ-to-SQL. So Microsoft could conceivably swap out the backend at any time.