News for hackers. Stuff that matters.
Re:SQLite: Small, Fast, Reliable – Choose any three by frik on Tuesday July 15, 2014 @02:22AM (#8035067)
but it's weird that Firefox doesn't support the WebSQL HTML5 API. All modern browsers except Firefox (and IE) support WebSQL by using SQLite.
Re:SQLite: Small, Fast, Reliable – Choose any three by rajivm on Tuesday July 15, 2014 @02:43AM (#8035108)
Mozilla took a stance against WebSQL because there was essentially no "standards specification" for it. The standard has rather been defined by its implementation: SQLite. Obviously, this SQLite is a very pragmatic solution, but Mozilla wasn't just happy with something that couldn't have an alternative and therefore permanently constrained. Instead they implemented [IndexedDB](https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_A...), which is an open standard. However, indexed DB is not a relational SQL store and is therefore less familiar to developers. Instead, it is transactional indexed key-value store on which it is possible to develop an SQL or other type of store.