Looking for recommendations for 3rd party SQLite utilities for browsing, maintaining, importing/exporting and repairing SQLite database files.
My primary development environments are Windows and Linux although I'm open to Mac only products as well. My 'google' research on this topic follows my signature. Thank you, Malcolm SQLite utilites found via google: sqlite (utilities|utility) The following products are listed in reverse order of price. SQLite Analyzer, $100 http://www.kraslabs.com/sqlite_analyzer.php http://software.techrepublic.com.com/abstract.aspx?docid=222935&q=analyzer Need a tool that would manage SQLite databases quickly and easily? SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions! Add tree-like database structure display, syntax highlighting, instant script generation. SQLite Analyzer is the best Internet has to offer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. There are no table size restrictions. Add tree-like database structure display, syntax highlighting, instant script generation to understand why professionals choose SQLite Analyzer. ### SQLite Maestro, $100 http://www.sqlmaestro.com/products/sqlite/maestro/ SQLite Maestro is the premier SQLite admin tool designed to meet the requirements of SQLite users and to make the work with the databases simpler and more comfortable. SQLite Maestro allows you to create, edit, copy, extract and drop all the database objects such as tables, views, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other admin tools designed for the easiest and most efficient work with SQLite databases. SQLite Maestro allows you to build diagrams based on SQLite data. This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more. ### SQLite Data Wizard, $100 http://jcay.com/tools-and-utilities/database-tools/sqlite-data-wizard.html SQLite Data Wizard is a powerful Windows GUI utility for managing your data. It provides you with a number of easy-to-use tools for performing the required data manipulation easily and quickly. * ASP.NET Generator: create a full set of ASP.NET scripts in a few mouse clicks * PHP Generator: get high-quality web applications without manual coding * Data Pump: transfer any ADO-compatible database to SQLite * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Flexible Task Scheduler * The Agent application to execute tasks in background mode ### SQLite Code Factory, $80 http://www.sqlmaestro.com/products/sqlite/codefactory/ SQLite Code Factory is a premier SQLite GUI tool aimed at the SQL queries and scripts development. Key features include: * Visual Query Builder * Handy SQL Editor with code folding and syntax highlighting * Simultaneous executing of several queries with multi-threading * Data management: viewing, editing, grouping, sorting and filtering abilities * Data export to as many as 14 file formats including Excel, RTF and HTML * Data import from Excel, CSV, text files and more * Powerful BLOB Viewer/Editor The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, customize user interface according to your needs and much more. ### SQLite3 Database Manager, $60 http://www.filedepot.eu/sqliteman/ Win32 application to manage SQLite3 database. Development tool for managing all database objects: * Tables * Views * Indexes * Triggers * SQL builder * Export schema and data to InterBASE, Firebird and other databases. ### SQLiteManager, $50 http://www.sqlabs.net/sqlitemanager.php SQLiteManager is a "next generation" GUI database manager for sqlite databases, it combines an incredible easy to use interface with blazing speed and advanced features. SQLiteManager allows you to open and work with sqlite 2.x, sqlite 3.x, in memory databases and REALSQL Server databases. It allows you to create and browse tables, views, triggers and indexes. It enables you to insert, delete and updates records in a very intuitive way and it supports you arbitrary SQL commands. SQLiteManager's report generation system is flexible enough to let you generate reports in just about any format you can imagine (report generation can actually be used to export data in just about any format you need). You create the report templates using a report template language and then generate reports by pouring SQL query results into the templates. ### SQLitePlus Database Explorer Only, $30 http://www.eztools-software.com/tools/sqliteplus/admin.asp Easily Manage your SQLite Databases: Use SQLitePlus Database Manager to view/edit your SQLite databases. SQLitePlus Database Manager is similar to SQL Server Query Analyzer. You can create/drop/view Tables, Views, Triggers, and Indexes, and also issue SQL queries and commands to view and otherwise manipulate your data. The data is displayed in a grid control, allowing you to copy the data to files or other programs. ### SQLiteSheet, $30 http://www.isoftol.com/soft.htm#sqls Work with SQLite3 becomes easy. Tool for administration of databases SQLite. The Program allows: -Modify database (create table, drop table, vacuum, etc.) -Execute SQL requests (insert delete, update, select, etc.) The program works: -SQL commands mode -GRID mode. Import DBF files Export to DBF, XML, HTML files Support function (UpperAnsi,LowerAnsi,TrimLeft,Trim,TrimRight, PadLeft,PadRight,Replace,Translate,Instr,Mod,Div,Sign,etc) ### SQLiteSpy, free (donation) http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases. ### SQLite command line utility (sqlite-3_5_8.zip), free http://www.sqlite.org/sqlite-3_5_8.zip The official SQLite command-line program for accessing and modifying SQLite version 3.* databases. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users