Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives

In this tutorial, we’re going to show you how to Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives. 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.

Install SQLite Browser

Install SQLite Browser 3.8 on Ubuntu 16.04 and Derivatives

SQLite Browser 3.8 Changelog


  • 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

sudo add-apt-repository ppa:linuxgndu/sqlitebrowser-testing

sudo apt-get update

sudo apt-get install sqlitebrowser

Please let us know in the comments, if this article was helpful to you. Any suggestion would be appreciated

comments powered by Disqus