Install the Visual Database Browser SQLite Browser 16.04 on Ubuntu 3.8

Install the Visual Database Browser SQLite Browser 16.04 on Ubuntu 3.8

SQLite Browser 3.8 was released at the end of last year. SQLite Browser is a visual database Browser that can be installed through PPA. SQLite Browser is a visualization tool compatible with SQLite used to create, design, and edit database files. The interface is simple and clean, completely free! This press release contains some important improvements and amendments.

SQLite Database Browser can manage all iphone data. It is developed based on the Qt library and is mainly used as a tool for non-technical users to create, modify, and edit SQLite databases. It is implemented using a wizard. An application used to process SQLite3 database files. It can open sqlite3 database files (common file extensions are. db ,. db3 ,. s3db; as long as the file is a SQLite3 database file, it does not matter if its extension is not standard ).

SQLite Database Browser is an open-source Visual Database browsing management tool that supports various platforms, including Windows, Linux, and Mac OS.

Creating, designing, and editing SQLite-compatible database files is a piece of cake for them.

SQLite Browser 3.8 Update log

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 shoshould 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

For more details, see the release log.

Install SQLite Browser 16.04 in Ubuntu 3.8 and later versions

Bkjia @ bkjia :~ $ Sudo add-apt-repository ppa: linuxgndu/sqlitebrowser-testing
[Sudo] bkjia password:
DB Browser for SQLite Unstable versions Only
More information: https://launchpad.net /~ Linuxgndu/+ archive/ubuntu/sqlitebrowser-testing
Press enter to continue or Ctrl + c to cancel adding

Gpg: the key ring '/tmp/tmpncmky_5c/secring. gpg' has been created.
Gpg: the key ring '/tmp/tmpncmky_5c/pubring. gpg' has been created.
Gpg: Download key '7f2583ea 'from hkp server keyserver.ubuntu.com
Gpg:/tmp/tmpncmky_5c/trustdb. gpg: Build a trust Database
Gpg: Key 7F2583EA: the Public Key "Launchpad PPA for Gajj GNDU" has been imported
Gpg: Total number of processed items: 1
Gpg: imported: 1 (RSA: 1)
OK
Bkjia @ bkjia :~ $ Sudo apt-get update

Sudo apt-get install sqlitebrowser

 

OK.

How to install JSON-supported SQLite 3.9.1 on Ubuntu 15.04

SQLite3 simple operation

Analysis on the combination of storage and data types in SQLite3

SQLite3 installation and basic operations

Simple Application of SQLite databases in Ubuntu 12.04

How to install SQLite in Ubuntu 12.04

Basics of SQLite Database

SQLite details: click here
SQLite: click here

This article permanently updates the link address: