http://sqlitebrowser.sourceforge.net/
Source is available of course, as well as pre-compiled binaries for Linux, Windows and Mac OSX.
The following features were added in the 1.1 update:
- SQL query window: enter SQL commands and see the output and error codes directly in a browser view.
- SQL log: lists all SQL commands issued by the browser application and/or by the user. Useful as a tool to analyze and learn SQL.
- Abitility to open database files specified with a command line parameter (sqlitebrowser mydb) and/or drag and drop.
- Added experimental modify table wizard, since SQLite does not support the ALTER TABLE SQL command. Use it with care. Works correctly for all tables originally created in SQLiteBrowser.
- The browser uses a transaction in the background to undo changes made to a database before they are commited to disk. All changes are now temporary until the user decides to SAVE the file.
- Added CSV import/export capabilities: a wizard makes it possible to configure table importing from a CSV file (delimiters, etc.) Supports most CSV format variations, including files generated by MS Excel and Access.
- Added SQL dump import/export capabities. Useful to store an SQL format backup of your database, or to interchange data with MySQL or Oracle, for example.
- Added text import/export capabilities directly to from a text file to db records.
- Modified record browsing interface. The spreadsheet interface now redraws faster (and clips longer records accordingly) Double click a cell to edit the record on a separate window. This allows better support for longer records including line breaks, for example.
and many other small enhancements and bug fixes. Enjoy.
Regards, Mauricio Piacentini Tabuleiro
