Редактор sqlite для linux

What are the Best SQLite GUI Tools?

SQLite is a commonly used and popular relational database management system that saves all database data in an SQLite file created by its tools. To view and edit this data, you need a software tool that can access the file. Fortunately, there are several GUI tools available that help users easily manage their SQLite databases.

In this detailed guide, we will discuss some of the best SQLite GUI tools that are open-source. We will evaluate their features to help you in making an informed decision on the best tool for your needs.

What are the Best SQLite GUI Tools?

There are numerous GUI tools available for managing SQLite databases. These tools are designed to help users view and edit SQLite files in an organized and user-friendly manner. Below we have mentioned some of the best SQLite GUI tools:

1: DB Browser for SQLite

DB Browser for SQLite is a user-friendly free SQLite file viewer. It is a feature-rich SQLite file viewer in which users can view and edit the databases.

The following are the key features of the DB Browser for SQLite:

• Users can view the primary names of the databases with records.
• In the Browse data option, users can view and edit the data manually.
• Users can enable and disable different options from the View menu.
• Users can check whether the database contains a foreign key or not.
• Users can export the database file in CSV, SQL, and JSON file formats.

2: SQLite Studio

The SQLite Studio is a free and open-source desktop tool for viewing SQLite files. It offers all the essential features for viewing and editing databases. You can edit the data in this tool through custom SQL queries. It is a platform-independent tool, you can run it on almost all operating systems including Windows, macOS, and Linux.

The following are the general features offered by SQLite Studio:

• Users can view all the objects of the database with their schema and types.
• Users can easily browse data by selecting a specific table.
• SQL log feature allows users to view all the SQL queries.
• Users can export the data of the file in CSV and SQL format.
• Users can use table editing tools to edit the data of the table.
• Users can work on multiple databases at a time.

3: SQLite Expert

SQLite Expert is a free SQLite file viewer that offers a wide range of features for viewing and editing different aspects of the database. Its graphical interface supports all SQLite features and includes a syntax highlighting SQLite editor.

The following are the key features of the SQLite Expert:

• Users can build complex SQL queries with ease
• Users can import and export data in many file formats.
• This tool supports the password protected databases
• Provides advanced data editing tools in the grid and image editor

4: SysTools SQLite Viewer

SysTools SQLite Viewer is a simple yet powerful tool that allows users to view the data of SQLite databases. It is a Windows-only tool that supports viewing only one SQLite file at a time. Users can view the properties of the database, such as its size, total number of pages, and rows.

The following are the general features of SysTools SQLite Viewer:

• For viewing the details of the database objects, use the SQLite Database Object option.
• Users can view the hexadecimal value of the data present in the database
• Users can view the database data in the form of the table

To get access to other advanced features users have to purchase the premium version of this tool.

5: SQLiteman

SQLiteman is a feature-rich SQLite GUI tool that offers all the important features required for viewing and editing the database. It is a platform-independent tool that is stable and reliable to use. This tool can be downloaded through the Windows Microsoft Store and App Store of the system.

The following are the key features offered by SQLiteman:

• Users can view the name of the databases in the Schema menu.
• The item view section provides the detail of the data of a certain row.
• Users can view and edit the SQL library queries in Pragmas.
• It also allows the users to modify the SQL code.
• Export the data file in multiple formats.

Bottom Line

SQLite is a well-known and widely used relational database management system for web developers and so are its management tools. We covered the best free and open-source SQLite GUI tools in this article that offer all the essential features for viewing and editing databases. If you just want to work with SQLite then DB Browser for SQLite and SQLite Studio are the good option for you. If you need more advanced features like complex SQL queries and password-protected databases, then you can choose SQLite Expert or SQLiteman. SysTools SQLite Viewer is also a good option for those who need a straightforward tool to view the data of their databases.

About the author

Zainab Rehman

I’m an author by profession. My interest in the internet world motivates me to write for Linux Hint and I’m here to share my knowledge with others.

Источник

Downloads

Note — If for any reason the standard Windows release does not work (e.g. gives an error), try a nightly build (below).

Nightly builds often fix bugs reported after the last release. 😄

macOS

Our latest release (3.12.2) for macOS:

Homebrew

If you prefer using Homebrew for macOS, our latest release can be installed via Homebrew Cask:

brew install --cask db-browser-for-sqlite 

Nightly builds

Download nightly builds for Windows and macOS here:

Linux

Our latest release is available as an AppImage, Snap packages, and distribution specific packages:

AppImage

Remember to change it’s permission bits to be executable before you run it. 😄

Snap packages

Snap Release build

 snap install sqlitebrowser 

Snap Nightly builds

 snap install sqlitebrowser --devmode 

Other distribution specific instructions:

Arch Linux

Install with the following command:

sudo pacman -S sqlitebrowser 

Fedora

Install for Fedora (i386 and x86_64) by issuing the following command:

sudo dnf install sqlitebrowser 

openSUSE

sudo zypper install sqlitebrowser 

Debian

Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.

Install the package using:

sudo apt-get install sqlitebrowser 

Ubuntu and Derivatives

Stable release

For Ubuntu and derivaties, @deepsidhu1313 provides a PPA with the latest release here:

To add this ppa just type in these commands in terminal:

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

Then update the cache using:

Install the package using:

sudo apt-get install sqlitebrowser 

Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until Launchpad decides to discontinue building for any series).

Ubuntu Precise (12.04) and Utopic (14.10) are not supported:

• Precise does not have a new enough Qt package in its repository by default, which is a dependency
• Launchpad does not support Utopic any more, which has reached its End of Life

Nightly builds

Nightly builds are available here:

To add this ppa, type these commands into the terminal:

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

Then update the cache using:

Install the package using:

sudo apt-get install sqlitebrowser 

Other Linux

On others, compile DB4S using the instructions in BUILDING.md.

FreeBSD

DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks to lbartoletti 😄). DB4S can be installed using either this command:

make -C /usr/ports/databases/sqlitebrowser install 

pkg install sqlitebrowser 

Источник

Редактор sqlite для linux

It’s free of charge for everybody, for any purpose (including commercial). It’s safe, as anyone can review source code.

Advanced SQL code editor

The SQL Editor window assists user with SQL syntax hints & highlighting, provides pretty-print code formatter, marks syntax errors. You can Ctrl+click on table mentioned in SQL query to open that table (or index, or trigger, or view).

Encrypted databases

Currently supported encrypted, password-protected SQLite variations are: SQLCipher, WxSQLite3 and System.Data.SQLite.

Multiple databases seamlessly

You can execute SQL statements that refer to multiple databases within single query, thanks to transparent database attaching mechanism built into the SQL Editor of SQLiteStudio.

Custom SQL functions

You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python or Tcl. There is repository of ready-to-use scripts on the wiki page.

Custom collation sequences

You can implement your own collation sequences (i.e. algorithms for comparing 2 values, that could be used in ORDER BY clause, etc).

SQL & DDL history

You need that query you executed 2 weeks ago? No problem. SQL Editor has a «History» tab. You need to upgrade production database the same way you did locally with SQLiteStudio? Use DDL History window — it has all DDL statements as executed by SQLiteStudio.

D&D between databases

You can Drag & Drop objects (tables, indexes, . ) between databases in order to copy or move them, with or without data.

Cross-platform

Works on all 3 major platforms — Windows, MacOS X, Linux. Can be compiled from sources on other, less common platforms (like FreeBSD, . ).

Portable distribution

There is a portable distribution. No need to install it. Just download the package, decompress and run. No administrator rights are required.

Data populating

Do you need to test your application quickly with some pre-generated data? SQLiteStudio can populate tables for you with various strategies (constant, sequence, random number, random text, dictionary-based text, script code generated).

Importing/exporting

SQLiteStudio can import data from various formats (currently CSV or any text file using Regular Expression), or export to various formats (SQL statements, CSV, HTML, XML, PDF, JSON).

Scripting

The application currently supports JavaScript, Python and Tcl scripting languages. Scripts can be used as generators for data populating, custom SQL functions, custom collation sequences).

Plugins

SQLiteStudio supports plugins of several categories. For example another scripting language can be added with plugin. Another import or export format, another table data populating strategy, another SQLite database format, SQL code formatter, code highlighter, table cell value representation renderer — all of these can be exteded with plugins.

Источник