This is an editor for LOB data and a import/export tool for SQLite.
SqliteLobEditor is a SQLite LOB data editing tool, and it can batch import/export SQLite LOB ((BLOB, CLOB). This is compatible with Windows 2000, XP, 2003, Vista, 2008, 7, and 8. The interface is simple. The interface is easy enough for the IT types and the DBA types who would typically need this kind of a tool. There is a task scheduling option available. You could set times at which the transfer task will take place. The interface will guide you through the settings step. The large configuration area displays the necessary details. A progress bar displays the transfer completion. You not only get a time estimation of how much time has been spent and what is left, you get an estimate of number of records transferred too. This tool supports multiple data types including text, RTF, image, PDF, html, xml, etc.
Batch import and export of data is possible. Large object or LOB data of both CLOB and BLOB types are supported. Viewing of BLOB, CLOB data by calling an external tool is possible for more sophisticated edits. The tool makes it easy to view image data in BLOB field. BLOB data can be viewed in hexadecimal format when editing. Saving of edited data and loading of data for editing are possible. Import or export task through saved sessions can be done repeatedly. Command line interface helps specify transfers quite easily after you have gained some experience with the tool. Task scheduling is done easily. Data transfers then take place at specified times automatically. This is a good tool when you work with SQLite often.