- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
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 functionality 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, 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.
Huajun editor recommends:
SQLite Expert Personal is a software that is completely fool-proof and super simple to operate. I also recommend it.DataedoDownload and use related software.
it works
it works
it works