SQLite Expert Personal

Do you need an easy and powerful tool when developing SQLite3 database? SQLite Expert Personal official version will be your best choice. This has the richest set of management and development tool features. SQLite Expert Personal answers all user needs, from writing simple SQL queries to developing complex databases. SQLite Expert visual management tool allows users to perform operations such as creating, editing, copying, and extracting on the SQLite server.

SQLite Expert Personal software features

                          SQL Query Builder

          If you are not a SQL expert but want to create complex queries intuitively, you can use the integrated query builder to generate SQL SELECT queries in the visual interface.

Execute SQL query

​ ​ SQLite Expert allows users to easily execute SQL scripts and display the results in a grid or text. If all columns in the select query come from one table, the result set is also editable.

SQLite Expert supports syntax highlighting, saving and loading scripts in files, SQL history, and interrupting the execution of long-running queries.

Display and edit data in the grid

​ ​ SQLite Expert allows users to insert, delete and edit table data in the grid.

You can simply click on a grid cell and modify its value. Click the Publish button in the Navigator panel to save the data to the database. You can use the Up, Down, PageUp, and PageDown keys to traverse grid cells.

Display data as text

You can also display a table or query result set in text format.

Table Design: Field Editor

​ ​ SQLite Expert allows to reorganize tables without losing the data that already exists in the table. Reorganizing a table is wrapped in a nested transaction, which rolls back if any errors occur while applying changes to the table.

Table Design: Index Editor

Indexes can be added, deleted, modified and renamed intuitively. SQLite Expert supports index field collation and reordering, primary, unique and auto-increment indexes and conflict clause editing.

Table Design: Foreign Key Editor

SQLite introduced full support for foreign keys in version 3.6.19. Starting with version 2.2, SQLite Expert allows intuitive editing of foreign keys. Foreign keys can be added, deleted and modified.

Table Design: Trigger Editor

       Triggers can be added, deleted, modified and renamed intuitively.

Table Design: Check Constraint Editor

        Check constraints can be added, removed, modified and renamed visually.

Table Design: Unique Constraint Editor

Unique constraints can be added, removed, modified and renamed visually.

View design

Views can be added, deleted, modified and renamed intuitively. Temporary views are supported.

Image editor

​ ​ If the column contains an image, you can open it in an image editor, as shown in the screenshot.

​​Currently supports BMP, PNG, JPG, GIF and ICO formats.

Hex Editor

The contents of any field can be displayed and edited in the hex editor.

       Manage SQLite extensions

Loading and unloading SQLite extensions. Professional version supports automatic expansion.

​ ​ SQLite Expert provides the unique feature to display the installed functions and collations of any SQLite extension.

Table Design: Record Editor

A recent feature is the record editor, which is very useful for tables with a large number of columns.

Import and export data

SQLite Expert currently supports the following methods of importing and exporting data:

Use the Data Transfer Wizard to import data from SQLite, SQL scripts, and ADO data sources.

​ ​Import data from text files (CSV, TSV).

Use the Data Transfer Wizard to export data to SQLite, SQL scripts.

​ ​Export data to text files (CSV, TSV), XML, HTML or Excel.

Use drag and drop to transfer tables between SQLite databases.

​ ​​Transfer records between SQLite tables or in Excel via the clipboard.

SQLite Expert Personal installation steps

​​ 1. Download the compressed package of SQLite Expert Personal official version of the software from Huajun Software Park. After decompressing, double-click the exe file to enter the installation interface, view the software license agreement, select i accept the agreement, and click next

​ ​ 2. Select the software installation location and click browse to modify the default installation location on the C drive. It is recommended that you choose to install on the D drive, and then click next

​​ 3. Select the start menu folder, the default is enough, click next

​​ 4. Select additional tasks, the default is enough, click next

5. Confirm the software installation information and click install

​​ 6. The official version of SQLite Expert Personal software is being installed, we are waiting patiently

7. The software is installed successfully, click finish.

How to use SQLite Expert Personal

How to create a table?

File》New Database》Enter the name of the database in the text box, such as using ceshi, and then create the database

Right click on the built ceshi database, select New Table, and create a table

Then set the table name in General under Design

Then set the column name and type in Colunmns under Design. Here are id, name and password.

Types are divided into INTEGER and TEXT

​​Create an index for the id in the Index under Design

Then you can use SQL statements to practice operations in SQL, and then you can see the changes in the data in Data

SQLite Expert Personal FAQ

How to open a password-protected database in SQLite Expert Personal official version?

You must install a SQLite library that supports the same encryption algorithms used to encrypt the database.

​Why can’t the SQLite Expert Personal official version load the library?

The official version of SQLite Expert Personal is for the wrong platform (i.e. 32-bit library of 64-bit SQLite Expert).

This library has unmet external dependencies, such as the Visual C++ runtime library.

This library does not export one or more functions required by SQLite Expert.

Why are Boolean values ​​not displayed correctly?

Currently, the official version of SQLite Expert Personal only supports Boolean values ​​stored as integers 0 (false) and 1 (true).

SQLite Expert Personal update log

          Added support for UPSERT clause.