DB Browser for SQLite

DB Browser for SQLite (was SQLite Database Browser) is a high quality, visual, open-source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, and search and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands. Controls and wizards are available for users to:

• Create and compact database files
• Create, define, modify and delete tables
• Create, define and delete indexes
• Browse, edit, add, and delete records
• Search records
• Import and export records as text
• Import and export tables from/to CSV files
• Import and export databases from/to SQL dump files
• Issue SQL queries and inspect the results
• Examine a log of all SQL commands issued by the application

Note - This project has previous been known as "SQLite Browser" and "Database Browser for SQLite". "DB Browser for SQLite" will hopefully be the name that sticks. :)

Improvements

• Several, several fixes in our SQL grammar parser allowing you to edit more databases using the UI tools.
• Make adding new rows less confusing by showing automatically generated data by default values, triggers or the PK right after the new row is added.
• Edit Table dialog: Add option for adding a unique constraint to columns.
• UI improvements: Show line numbers in the SQL log, avoid extreme column widths in the table view showing the results of a SQL statement, add a new dock showing the DB schema
• Add a database schema pane (can be torn off), so the schema can be viewed while in the Execute SQL tab.
• Tag name correction in git repo.

Translations

• Added a Russian translation.
• We have most of a German translation now.

Bug fixes

• Fixed a few "crashes when loading database" bugs.
• Fix import of CSV files containing multi-byte Unicode characters.
• Complete quoting for parameters of some CMake commands.
• Some comments were corrected.
• Compilation warning [-Wformat] fixes.
• Outdated version number in src/app.plist file.