As promised in one of previous posts, I’ve written a little GUI-ed program in Java that allows exporting BLOBs data from SQLite to separate files. And I’m giving it away, with all sources.
The program has only one dependency – sqlitejdbc-v056.jar, which is a JDBC driver for SQLite databases. Download it from www.zentus.com/sqlitejdbc/ and put in the same folder where my program’s JAR is.
(UPD: actually it’s better to download newer driver – “sqlite-jdbc-3.7.2.jar” or latter from here – http://code.google.com/p/sqlite-jdbc/)
Besides the above-mentioned dependency, my program is just a single JAR file (sources are packed into it). To launch the program simple double-clicking on it should be just enough. If it isn’t, search web for “launch JAR” – you’ll find plenty of instructions. You must have Java installed, but that is an obvious thing I suppose.
Here’s the download link: mvmn.ho.ua/dld/sliteblobexp.jar (MD5 checksum = 99ca2488ac62f48721dced3c119d1271).
UPD: now also on GitHub – github.com/mvmn/sqlite-blob-export. See “distr” for binary distribution (built JAR file).
A small video of it in action: