GhostBSD For SQLite Database With SQLitebrowser GUI Manager

DB Browser or SQLite Browser for SQLite3 is a visual open source technology with a GUI display that makes things easier for users. SQLite Browser is used to create, design, and edit SQLite compatible database files. This technology allows users and developers to create databases, search, and edit data through a spreadsheet-like interface.

DB Browser for SQLite3 contains controls and wizards that bypass the need for Structured Query Language (SQL) commands and allow users to create and compact database files, create and edit tables and indexes, edit and search for records, import and export records and tables as text and Comma-Separated Values (CSV) files, and more.

With SQLite Browser it will be easier for users to create and edit files compatible with SQLite databases such as text, CSV, and SQL dump files. These files can be saved to the user's local drive or stored in a SQLite database.

SQLite Browser is a utility that allows us to view data stored in the SQLite Database. Depending on the format and type of data in the database, it may or may not be human readable. It is generally used for debugging or other development tasks where the developer needs to read data that has been stored but does not have a built-in system to access it programmatically.

The following are the features found in SQLite Browser:
  1. Create and compact database files.
  2. Create, define, modify, and delete tables.
  3. Create, define, and delete indexes.
  4. Browse, edit, add, and delete notes.
  5. Search notes.
  6. Import and export notes as text.
  7. Import and export tables from/to CSV files.
  8. Import and export databases from/to SQL dump files.
  9. Issue a SQL query and check the results.
  10. Check the log of all SQL commands issued by the application.

How to install SQLite Browser for SQLite on GhostBSD is very easy. To install SQLite Browser on GhostBSD you must log in as a super user or root user. The following is how to install SQLite Browser on GhostBSD.

1. On the GhostBSD Desktop, right click the mouse then select Open in Terminal so we can enter the GhostBSD command shell menu.
2. After the GhostBSD command shell menu appears, click the following command.

semeru@ns3:/usr/home/semeru/Desktop $ sudo su
Password: type the GhostBSD password
You have mail.

root@ns3:/usr/home/semeru/Desktop #

3. After you log in as root user, type the following command.

root@ns3:/usr/home/semeru/Desktop # pkg update -f
root@ns3:/usr/home/semeru/Desktop #
pkg upgrade -f
root@ns3:/usr/home/semeru/Desktop #
pkg install sqlitebrowser
Updating GhostBSD repository catalogue...
GhostBSD repository is up to date.
All repositories are up to date.
Checking integrity... done (0 conflicting)
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
sqlitebrowser: 3.12.1_7

Number of packages to be installed: 1

The process will require 6 MiB more space.

Proceed with this action? [y/N]:
[1/1] Installing sqlitebrowser-3.12.1_7...
[1/1] Extracting sqlitebrowser-3.12.1_7: 100%
==> Running trigger: gtk-update-icon-cache.ucl
Generating GTK icon cache for /usr/local/share/icons/hicolor
==> Running trigger: desktop-file-utils.ucl
Building cache database of MIME types

4. After the installation is complete, run sqlitebrowser by typing the following command.

root@ns3:/usr/home/semeru/Desktop # sqlitebrowser

then the DB Browser menu will automatically appear.

After the sqlitebrowser program is open, you can operate various SQL commands with sqlitebrowser with a GUI display that can make it easier for you.
Iwan Setiawan

I Like Adventure: Mahameru Mount, Rinjani Mount I Like Writer FreeBSD

Post a Comment

Previous Post Next Post