How to Install SQLite Browser 3.8 on Ubuntu 16.04

DB Browser for SQLite 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, 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

SQLite Browser 3.8.0 which was released end of last year is now available for installation via the PPA.  SQLite Browser is a visual tool used to create, design and edit database files compatible with SQLite. This release contains some important enhancements, and fixes.

SQLite Browser 3.8 Changelog

Enhancements

• Add proper file extension filters to all file dialogs
• Improved error handling, e.g. more error messages with more detailed error descriptions
• Allow changing table columns even when there is a foreign key constraint on the table
• When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record
• Add option for disabling the SQL error indicators in the Execute SQL area
• Add an option for setting the colours of fields with regular and binary data
• Use the name of the imported file as default suggestion for a table name during CSV import

Bug Fixes

• Fix missing SQL log when query contains a line break, also trim the log
• Also set foreign key settings when creating a new database instead of just setting them when opening a file
• Fix drawing of Unicode characters in the SQL editor where the font settings wouldn’t apply as they should have
• Allow values greater than 10000 in the user_version pragma of a database
• Fix adding new a record into a table where all fields are set to a default value

See changelog for more

Install SQLite Browser 3.8 on Ubuntu 16.04 and below

 Run the following commands in Terminal to install SQLite Browser 3.8 on Ubuntu 16.04:

$ sudo add-apt-repository ppa:linuxgndu/sqlitebrowser-testing $ sudo apt-get update $ sudo apt-get install sqlitebrowser