Re:SQLite: Small, Fast, Reliable – Choose any three
by aw3c2 on Monday July 14, 2014 @06:07PM
(#8033554)
On IRC they usually recommend some Firefox add-on which is kinda weird (and I would like a standalone tool) but seems great. https://addons.mozilla.org/firefox/addon/sqlite-manager/
[ Parent
| on HN ]
Re:SQLite: Small, Fast, Reliable – Choose any three
by pyre on Monday July 14, 2014 @06:41PM
(#8033670)
> which is kinda weird
Firefox uses SQLite for a bunch of internal data and the bindings are accessible to extensions. So basically Firefox is a cross-OS platform that's guaranteed to be linked against SQLite, with public bindings.
It probably works better than many of the Java-based 'cross-platform' solutions to many problems...
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.