5 ms·
I'm a huge fan of SQLite. However one limitation I've run across is a good UI to admin it or develop for it. Right now I use something called "SQLite Administra
by Someone1234 12y ago
I'm a huge fan of SQLite. However one limitation I've run across is a good UI to admin it or develop for it. Right now I use something called "SQLite Administrator" (Orbmu2k) which is both really nice in some ways but super buggy...
Anyone found anything better? And, yes, I know it ships with command line tools but particularly for development it is nicer to have a GUI to quickly set up tables.
- aw3c2 12y agoOn 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/ https://addons.mozilla.org/firefox/addon/sqlite-manager/
- pyre 12y ago> 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...
- frik 12y agobut it's weird that Firefox doesn't support the WebSQL HTML5 API. All modern browsers except Firefox (and IE) support WebSQL by using SQLite.
- rajivm 12y agoMozilla 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_API 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.
- bch 12y agoI've worked w/ this[0] firefox plugin before, with good success. [0] https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...
- jqm 12y agoThere is a firefox plugin for sqlite. It's pretty nice. https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage... I use it sometimes to see table overviews, but generally just work from command line or a short python script specific to what I'm doing. Edit: Beat by 30 seconds! Ah well.. I guess now you have two recommendations for sqlite manager. Edit Edit: Now 3 recommendations. I guess the plugin is pretty popular.
- Osmium 12y agoI'm not sure if this is what you're looking for, but I can highly recommend Base by Menial: http://menial.co.uk/base/ http://menial.co.uk/base/ (Mac only)
- girvo 12y agoGosh I adore using Base, to the point where I choose SQLite over Postgres/MySQL more times than not, because its interface makes working with a joy. Sequel Pro and PG Commander are good, but not as good (well, the former is pretty close, but then you're using MySQL which I just find painful these days).
- silasb 12y agoUsing Adminer [1] and running it via `php -S localhost:8080 adminer.php` works beautifully. I also use Adminer to manage my Postgresql databases on my Mac. [1]: http://www.adminer.org/ http://www.adminer.org/
- smasty 12y agoI can recommend Adminer as well, it's just a single PHP file. The GUI is minimalistic but intuitive and very fast. The best part is probably the support for 8 database systems (MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB) and 30+ localizations, so you can use the same GUI for all your databases. Although probably not all drivers support all the features, as far as I know SQLite, Postgres and MySQL are essentially 100% covered (Don't know about others, since I don't use them).
- teh_klev 12y agoI've been using Nucleon's Database Master which has support for SQLite and also MySQL, MongoDB and others: http://www.nucleonsoftware.com/Products/Database-Master/Database-Master-Editions http://www.nucleonsoftware.com/Products/Database-Master/Data... It's not open source and it's Windows only, but there's a free edition that lets me do most things with SQLite and MongoDB.
- mamcx 12y agoAlso, another option that have work well for me in OSX is http://www.valentina-db.com/ http://www.valentina-db.com/ P.D: Just because is a commercial product down vote the parent? In this area (Sql managers) the commercial ones are better than the open source ones, by a LOT.
- teh_klev 12y agoYep, sometimes one has to part with a few quid to get the job done right and friction free. That aside, my mainstream MySQL utility is HeidiSQL which is in fact free and open source (although I did bung them a donation because I think it's a neat tool): http://www.heidisql.com/download.php http://www.heidisql.com/download.php Heidi also runs on Wine as well, so something for everyone :) http://appdb.winehq.org/appview.php?iAppId=3326 http://appdb.winehq.org/appview.php?iAppId=3326
- thelibrarian 12y agoI've not used it much, but SQLite Database Browser seems quite good: http://sqlitebrowser.org/ http://sqlitebrowser.org/ - it is opensource and cross platform.
- bicknergseng 12y agoRelated... anyone know what happened to Induction? https://github.com/Induction/Induction https://github.com/Induction/Induction looks like the guy who started it lost interest and no one picked it up?
- deleted 12y ago[deleted]
- yareally 12y agoIntellij IDEA Ultimate (or any of their other paid IDE tools) has a built in cross-db GUI tool for editing, creating and modeling databases. If using Intellij IDEA, it also has support for SQLite on Android, which is a huge benefit if you ever had to deal with SQLite on Android. Aside from that, the IDE will also detect SQL queries in one's code and syntax check them. It also lets you run the query directly from there with user generated parameters without having to execute the code file itself.
- kawera 12y agoHappy user of Liya[1]. Free but not open source; Mac only. [1] http://www.cutedgesystems.com/software/Liya/ http://www.cutedgesystems.com/software/Liya/
- malkia 12y agoWe are using custom build of sqlite (more db columns, returned columns) and for us a ui that either calls some .exe or loads .dll is preffered. My favourite was SqliteSpy but its statically linked, so had to switch to sqlitebrowser, and compile it with our own custom build of qt5 where "system" sqlite (our custom one) is used. Maybe one good case where DLL/.so/.dylib shine (if only golang... :) )
- jbert 12y ago> Maybe one good case where DLL/.so/.dylib shine (if only golang... :) ) Possibly, but it's mostly only useful if you can't recompile the app (i.e. don't have source). And in that case, you've probably paid money for it, and want support. Which you won't get if you've swapped out a component for one it wasn't tested with. [But I agree with your general point. DLL search path/LD_LIBRARY_PATH can be a useful 'speed hack' to drop in a different lib with an identical API and minor tweaks. e.g. overload malloc/free/realloc() in some misbehaving app to trace a problem without recompiling.]