Popular x64 Tags
- server x64 download
- web server x64 download
- software x64 download
- log analysis x64 download
- raid x64 download
- analysis x64 download
- manage x64 download
- database driven x64 download
- windows 2008 ts gateway x64 download
- file server x64 download
- cd rom x64 download
- mail server x64 download
- ftp server x64 download
- client server x64 download
- virtualization x64 download
- live reports x64 download
- log x64 download
- network disk x64 download
- idisk x64 download
- smtp server x64 download
- history x64 download
- iscsi target x64 download
- disk mapping x64 download
- iscsi x64 download
- dscsi x64 download
- active directory management x64 download
- virtualized disk x64 download
- ipds printing x64 download
- pop3 server x64 download
- ipds x64 download
SQLite Expert Personel 5.5.14
Sponsored links:
Bogdan Ureche
SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert Professional is a straightforward and practical piece of software that helps you to manage and organize SQLite databases and gain better visibility into how your tables and classes are operating. SQLite Expert Professional will automatically choose a default alias for the current database but you can change it according to your needs. The Design tab allows you to view, add, delete or modify fields, indexes, foreign keys, constraints and triggers using the right-click menu. Additionally, you can add new entries by selecting the proper button located at the bottom of the application.
By using SQLite Expert you will be able to:
* Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
* Build SQL scripts and generate views visually using the integrated Query Builder.
* Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
* Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
* Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG, PNG and GIF image formats. BLOB fields can be edited with the integrated hex editor.
* Execute SQL queries and display results in the grid or as text.
At first glance, version 2.0 is not much different from the latest version 1.7. However, version 2.0 brings major internal improvements with respect to Unicode support. SQLite Expert is written in Delphi, and Delphi versions older than 2009 did not include native Unicode support. SQLite Expert versions 1.x included Unicode support by using a freeware library - UTF8VCL available from SourceForge. This project was in alpha stage of development and seems to be currently unmaintained.
The latest version of Delphi (Delphi 2009) finally added complete support for the Unicode character set, so it was the logical choice to upgrade the source code of SQLite Expert to Delphi 2009. This process took a few months because of the major internal differences between the two compilers. During this migration, the source code was gradually modified to compile with Delphi 2009 while still being compatible with Delphi 2007. As a result of this process, versions 1.7 and 2.0 of SQLite Expert look very similar but are actually much different internally. The native string type in Delphi 2007 was the AnsiString while in Delphi 2009 it is the UnicodeString (using UTF-16 encoding).
The following differences between versions 1.7 and 2.0 are related to the improved Unicode support:
* The default type mapping for CHAR and TEXT is now WideString instead of String. That means, all the text is now converted to UTF-16 when it is loaded from the database. In version 1.x it was converted to UTF-8. It is recommended not to change this setting.
* It you wish to change the default type mappings for other declared types so they are handled internally as strings, you should map them to WideString, not to String as in version 1.x.
* More encoding options on import/export from/to text files. An encoding detection when importing a text file has been included that seems to work reasonably well in most cases.
* The Encoding options have been renamed to "Unicode (UTF-8, UTF-16)" and "Default ANSI code page".
SQLite Expert includes a statically linked sqlite3 library, so it can be used without an external sqlite3.dll. However, it is still possible to use an external library, which might be a useful feature in case you want to use a more recent sqlite library, or one that supports encryption (note that encryption support is only available in the Professional Edition).
By using SQLite Expert you will be able to:
* Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
* Build SQL scripts and generate views visually using the integrated Query Builder.
* Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
* Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
* Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG, PNG and GIF image formats. BLOB fields can be edited with the integrated hex editor.
* Execute SQL queries and display results in the grid or as text.
At first glance, version 2.0 is not much different from the latest version 1.7. However, version 2.0 brings major internal improvements with respect to Unicode support. SQLite Expert is written in Delphi, and Delphi versions older than 2009 did not include native Unicode support. SQLite Expert versions 1.x included Unicode support by using a freeware library - UTF8VCL available from SourceForge. This project was in alpha stage of development and seems to be currently unmaintained.
The latest version of Delphi (Delphi 2009) finally added complete support for the Unicode character set, so it was the logical choice to upgrade the source code of SQLite Expert to Delphi 2009. This process took a few months because of the major internal differences between the two compilers. During this migration, the source code was gradually modified to compile with Delphi 2009 while still being compatible with Delphi 2007. As a result of this process, versions 1.7 and 2.0 of SQLite Expert look very similar but are actually much different internally. The native string type in Delphi 2007 was the AnsiString while in Delphi 2009 it is the UnicodeString (using UTF-16 encoding).
The following differences between versions 1.7 and 2.0 are related to the improved Unicode support:
* The default type mapping for CHAR and TEXT is now WideString instead of String. That means, all the text is now converted to UTF-16 when it is loaded from the database. In version 1.x it was converted to UTF-8. It is recommended not to change this setting.
* It you wish to change the default type mappings for other declared types so they are handled internally as strings, you should map them to WideString, not to String as in version 1.x.
* More encoding options on import/export from/to text files. An encoding detection when importing a text file has been included that seems to work reasonably well in most cases.
* The Encoding options have been renamed to "Unicode (UTF-8, UTF-16)" and "Default ANSI code page".
SQLite Expert includes a statically linked sqlite3 library, so it can be used without an external sqlite3.dll. However, it is still possible to use an external library, which might be a useful feature in case you want to use a more recent sqlite library, or one that supports encryption (note that encryption support is only available in the Professional Edition).
OS: Windows 2000, Windows 2003, Windows XP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64, Windows 8, Windows 8 x64, Windows 10, Windows 10 x64, Windows 11
Add Your Review or 64-bit Compatibility Report
Top Other Server Applications 64-bit downloads
SQLyog Community Edition x64 13.2.1
A application that will allow you to manage MySQL databases
Open Source
ESF Database Migration Toolkit Professional Editon 12.0.19
A simple application, allows you to convert from one database type to another
Demo | $322.00
TwonkyMedia Manager 3.1.0.55
Share your media on compatible devices throughout your home
Trialware | $19.95
FmPro Migrator 7.36
Migrates FileMaker to MySQL, Oracle, Access, SQL Server, PostgreSQL, FrontBase
Demo | $200.00
DbWrench 5.1.1
Multi vendor, cross platform database design and round-trip engineering software
Shareware | $149.00
Members area
Top 64-bit Downloads
-
SQLyog Community Edition
x64 13.2.1
x64 open source download -
WampServer 64-bit 3.3.2
x64 open source download -
TOra x64 3.2.186
x64 open source download -
Titan FTP Server x64 19.00 B3676
x64 trialware download -
Weka x64 3.8.6
x64 open source download -
callas pdfToolbox Server
x64 13.0.577
x64 trialware download -
Microsoft® SQL Server®
2012 x64 SP1
x64 freeware download -
SQLyog Pro x64 13.2.1
x64 trialware download -
Tableau Server 2023.3.6
x64 trialware download -
Lavasoft Personal
Firewall (64-bit) 3.0.2293
x64 trialware download
Top Downloads
-
SQLyog Community Edition
x64 13.2.1
open source download -
TOra 3.2.275
open source download -
ESF Database Migration
Toolkit Professional
Editon 12.0.19
demo download -
Portable SecureCRT 6.7.5
trialware download -
TwonkyMedia Manager 3.1.0.55
trialware download -
Advanced Onion Router 0.3.1.5
freeware download -
CacheGuard EH-1.3.6
shareware download -
EraserDrop Portable 2.1.1
open source download -
Wing FTP Server For
Mac(i386) 7.3.9
shareware download -
WampServer 64-bit 3.3.2
open source download -
freeFTPd 1.0.13
freeware download -
DbWrench 5.1.1
shareware download -
SunFirewall 2.0.0.4
shareware download -
callas pdfToolbox Server 15.1.639
trialware download -
BroadWave Pro Streaming
Audio Server 2.00
shareware download