News for hackers. Stuff that matters.
Re:SQLite: Small, Fast, Reliable – Choose any three by Someone1234 on Monday July 14, 2014 @05:59PM (#8033516)
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.

Re:SQLite: Small, Fast, Reliable – Choose any three by Osmium on Monday July 14, 2014 @06:09PM (#8033567)
I'm not sure if this is what you're looking for, but I can highly recommend Base by Menial:

http://menial.co.uk/base/

(Mac only)

Re:SQLite: Small, Fast, Reliable – Choose any three by girvo on Monday July 14, 2014 @06:59PM (#8033736)
Gosh 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).
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/
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.
Re:SQLite: Small, Fast, Reliable – Choose any three by silasb on Monday July 14, 2014 @06:16PM (#8033595)
Using 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/

Re:SQLite: Small, Fast, Reliable – Choose any three by smasty on Tuesday July 15, 2014 @06:11AM (#8035600)
I 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).
Re:SQLite: Small, Fast, Reliable – Choose any three by jqm on Monday July 14, 2014 @06:08PM (#8033562)
There is a firefox plugin for sqlite. It's pretty nice. 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.

Re:SQLite: Small, Fast, Reliable – Choose any three by bicknergseng on Monday July 14, 2014 @07:35PM (#8033864)
Related... anyone know what happened to Induction? https://github.com/Induction/Induction looks like the guy who started it lost interest and no one picked it up?
Re:SQLite: Small, Fast, Reliable – Choose any three by thelibrarian on Monday July 14, 2014 @07:20PM (#8033809)
I've not used it much, but SQLite Database Browser seems quite good: http://sqlitebrowser.org/ - it is opensource and cross platform.
Re:SQLite: Small, Fast, Reliable – Choose any three by kawera on Monday July 14, 2014 @11:29PM (#8034616)
Happy user of Liya[1]. Free but not open source; Mac only.

[1] http://www.cutedgesystems.com/software/Liya/

Re:SQLite: Small, Fast, Reliable – Choose any three by yareally on Monday July 14, 2014 @08:58PM (#8034141)
Intellij 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.

Re:SQLite: Small, Fast, Reliable – Choose any three by teh_klev on Monday July 14, 2014 @06:44PM (#8033686)
I'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/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.

Re:SQLite: Small, Fast, Reliable – Choose any three by mamcx on Monday July 14, 2014 @10:20PM (#8034385)
Also, another option that have work well for me in OSX is

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.

Re:SQLite: Small, Fast, Reliable – Choose any three by teh_klev on Monday July 14, 2014 @10:57PM (#8034505)
Yep, 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

Heidi also runs on Wine as well, so something for everyone :)

http://appdb.winehq.org/appview.php?iAppId=3326

Re:SQLite: Small, Fast, Reliable – Choose any three by malkia on Tuesday July 15, 2014 @03:37AM (#8035241)
We 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... :) )

Re:SQLite: Small, Fast, Reliable – Choose any three by jbert on Tuesday July 15, 2014 @04:03AM (#8035307)
> 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.]

Re:SQLite: Small, Fast, Reliable – Choose any three by bch on Monday July 14, 2014 @06:08PM (#8033559)
I've worked w/ this[0] firefox plugin before, with good success.

[0] https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...