SQLite Expert Personal 6.2.12.746
SQLite Expert Personal is a feature rich administration and development tool for SQLite. SQLite Expert is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
Download
22.59 MB
596downloads
0this week
FreeFreeware
0reviews
Screenshots
About SQLite Expert Personal
Are you developing SQLite3 databases and need an easy and powerful tool? SQLite Expert Personal is the perfect choice. It is a feature rich administration and development tool for SQLite. SQLite Expert is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
The graphical interface supports all SQLite features. It includes an SQL editor with syntax highlighting and code completion and visual table and view designers.
Supported platforms: Windows 2000, XP, Vista, 7.
Advanced SQL editor
* Syntax highlighting and code completion
* Multiple SQL tabs
Powerful restructure capabilities
* Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
* Restructure any complex table without losing data.
* Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.
Data editing
* Edit data in the grid using powerful in-place editors.
* Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
* Visualize and modify BLOB fields using the integrated Hex editor.
Other features
* Full Unicode support.
* Support for attached databases.
The graphical interface supports all SQLite features. It includes an SQL editor with syntax highlighting and code completion and visual table and view designers.
Supported platforms: Windows 2000, XP, Vista, 7.
Advanced SQL editor
* Syntax highlighting and code completion
* Multiple SQL tabs
Powerful restructure capabilities
* Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
* Restructure any complex table without losing data.
* Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.
Data editing
* Edit data in the grid using powerful in-place editors.
* Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
* Visualize and modify BLOB fields using the integrated Hex editor.
Other features
* Full Unicode support.
* Support for attached databases.
| Requirements | Windows 2000 or later; 1GB RAM; 100 MB available on hard drive |
|---|---|
| Release info | Update on Nov 01, 2026 |
| Release notes | - Index Advisor on the SQL tab: SQLite’s own advisor suggests indexes that would speed up a query, and shows the resulting plan. - Query History (SQL menu): every script run on the SQL tab, searchable, and reopened with a double-click. - One Find window for the current grid (Ctrl+F, SQL results included), a table, or a whole database (Find in the tree). Contains, whole value, starts with or regular expression; match case; whole words; chosen columns. All matches are listed and highlighted; Go to Row opens the row. - Recent searches are remembered. Esc or Clear Highlight removes the highlighting from a grid. - Shorter tree and grid menus: related commands are grouped under submenus. - Imports that create a table have a Column types option: descriptive types without sizes (the new default), STRICT type names, a STRICT table, or the old types with sizes. Floating-point columns are declared REAL. - Imports store a value longer than its column’s declared size whole, and the text import stores yes/no as 1 or 0. - The sample database uses SQLite’s type names (TEXT, REAL) without sizes. - The Record Editor sizes each box to its value; drag the strip under a box to resize it. - A new row appears in the grid at once, wherever it lands, and the cursor stays on it. - The Value Inspector opens on a value that does not match its declared type, and the text editor saves such a value as stored. - A tick box in a nullable column cycles through unchecked, null and checked. - Ctrl+C while editing a cell on the Design tab copies the selected text, not the row. - Grid filters offer every condition on TEXT columns (less than, greater than, between, any of and the rest), not only the LIKE family. BLOB columns can be filtered with Is null and Is not null. - Filters name NULL Is null and Is not null instead of “blank”, and show an empty string as (Empty), so the two no longer look alike. - A text column’s header filter list has (Empty) and (Not empty) beside (Null) and (Not null). Equals… |
| Related tags | SQLite administration |
| Listing data | winget |
Reviews
No reviews yet. Be the first to review SQLite Expert Personal.
Used SQLite Expert Personal? Tell other visitors what you thought.
Log in to write a reviewOther products by this publisher
-
SQLite Expert Professional 6.2.12.746
SQLite Expert Professional is the most feature rich administration and development tool for SQLite. SQLite Expert is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
Most viewed Windows Automotive Info Databases
-
1
EMS SQL Manager for PostgreSQL 5.4
EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features.
- 2 Auto Maintenance Pro 11.0.0.7 Makes it easy to track and organize preventive (PM) and repair maintenance on your personal vehicles/equipment. AMP alerts you when PM is due, provides user-definable PM schedules, generates a history, monitors operating costs, fuel, and vendors.
-
3
Automotive Wolf 4.520
The Original Car Care Software. The solution to tracking and managing your car maintenance. Track repairs, maintenance, fuel usage, operating expenses and more. Reminds you when any service is due including email notifications. Perfect for any car.
- 4 Fleet Maintenance Pro Shop Edition 11.0.0.40 Fleet Maintenance Pro Shop is easy to use fleet management software for shops. FMP alerts you when PM is due, tracks work orders, generates a fleet history, monitors operating costs, and tracks repairs, parts inventory, fuel, vendors, and drivers.
- 5 Maintenance Pro 5.0.0.30 Maintenance Pro helps keep track of your preventive and repair maintenance for your equipment. Whether you are tracking facility maintenance, machinery, or office equipment, this software will do the job.
-
6
A-Z Contacts Manager 3.1.0.57
Multi-User, Multi-functional business/personal contacts database: Complete contact information manager, audio/pop-up reminders for important tasks, to-do-list, advanced bulk e-mailer with mailing list manager for marketing campaign and many more...
- 7 DBSync for MS FoxPro & MySQL 2.1.0 Bi-directional synchronization and convertion for MS FoxPro and MySQL databases
- 8 CARCare Desktop Edition 2.0.078 Automotive Maintenance and Expense Tracking Software for Windows
-
9
Auto Organizer Deluxe 4.11
Complete program that will help car owners organize and manage all auto expenses, business trips, service contacts and fuel purchases. Intuitive interface and ready-to-use templates make it easy to set up and use.
-
10
Patient Medical Record and History Software 7.0
This software offers a solution to users who want to maintain patient records and histories.
Most downloaded Windows Automotive Info Databases
-
1
A-Z Contacts Manager 3.1.0.57
Multi-User, Multi-functional business/personal contacts database: Complete contact information manager, audio/pop-up reminders for important tasks, to-do-list, advanced bulk e-mailer with mailing list manager for marketing campaign and many more...
-
2
Automotive Wolf 4.520
The Original Car Care Software. The solution to tracking and managing your car maintenance. Track repairs, maintenance, fuel usage, operating expenses and more. Reminds you when any service is due including email notifications. Perfect for any car.
- 3 Auto Maintenance Pro 11.0.0.7 Makes it easy to track and organize preventive (PM) and repair maintenance on your personal vehicles/equipment. AMP alerts you when PM is due, provides user-definable PM schedules, generates a history, monitors operating costs, fuel, and vendors.
- 4 Fleet Maintenance Pro Shop Edition 11.0.0.40 Fleet Maintenance Pro Shop is easy to use fleet management software for shops. FMP alerts you when PM is due, tracks work orders, generates a fleet history, monitors operating costs, and tracks repairs, parts inventory, fuel, vendors, and drivers.
-
5
Auto Organizer Deluxe 4.11
Complete program that will help car owners organize and manage all auto expenses, business trips, service contacts and fuel purchases. Intuitive interface and ready-to-use templates make it easy to set up and use.
- 6 DBSync for MS FoxPro & MySQL 2.1.0 Bi-directional synchronization and convertion for MS FoxPro and MySQL databases
- 7 CARCare Desktop Edition 2.0.078 Automotive Maintenance and Expense Tracking Software for Windows
-
8
EMS SQL Manager for Oracle 3.2
EMS SQL Manager for Oracle is a high performance database tool for Oracle database development and administration. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to the newest one and supports the latest Oracle Database features.
- 9 Maintenance Pro 5.0.0.30 Maintenance Pro helps keep track of your preventive and repair maintenance for your equipment. Whether you are tracking facility maintenance, machinery, or office equipment, this software will do the job.
-
10
Patient Medical Record and History Software 7.0
This software offers a solution to users who want to maintain patient records and histories.