SQLite Expert Profesional

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 Profesional 2. 1. 2000
Publisher: Bogdan Ureche License: Shareware
Version: 2. 1. 2000 Date Added: 8 January, 2012
File Size: 11.4 MB Downloads: 7
Price: $59.00 Editor Rating:
Systems: WinXP, Windows Vista, Windows2000, Windows2003

Advertisement

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 integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.

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 2.0 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).

SQLite Expert Profesional 2. 1. 2000 Related Software
  • Apex SQL Script 2008.01
    Apex SQL Script converts databases to scripts, .net exe's and deployment packages. Apex SQL Script creates insert scripts from Microsoft SQL Server database that can be archived, emailed, checked into source control, run against another database etc
  • SQL Decrypter Pro 1 10
    SQL Decrypter Pro is a sql decryption tool that helps DBA and database programmer decrypt the encrypted sql object. It is suitable to use for programmer & DBA
  • Atlantis Data Space Analyser 1.0.322
    Atlantis Data Space Analyser is a free graphical tool for making capacity judgements for SQL Server - find out why you consume the data space that you do
  • Atlantis SQL Everywhere 1.6.165
    Atlantis SQL Everywhere is a SQL Server IDE that features the most fully-featured code completion available for SQL Server - use it to turbocharge your productivity. SQL Everywhere eliminates many of the labourious parts of writing SQL
  • Atlantis Schema Surf 1.0.243
    Atlantis Schema Surf is our SQL dependency & live entity ER diagram tool - it is a free animated graphing tool which allows you to easily visualize the dependencies between the objects in your SQL Server databases in a live entity ER diagram
  • Atlantis Data Surf 1.0.536
    Atlantis Data Surf is our SQL visualization tool - it is a free animated graphing tool which allows you to easily visualize complex schemas - use it to "surf" through your data
  • Atlantis Data Inspector 1.0.882
    Data Inspector is our SQL diff and database synchronization tool, offering an easy and fast way to compare and synchronize data elements of SQL Server databases whether dealing with live, test or development databases
  • Atlantis Schema Inspector 1.0.646
    Atlantis Schema Inspector is an incredibly fast, flexible and complete SQL Server schema comparison and synchronization tool - use it to get your deployments right first time, every time
  • Ndb Database Manager 1. 1. 2005
    Ndb is a powerful database manager. The Ndb software allows you to create databases to keep track of all your vital information, address lists, phone numbers, images, Tomahawk Documents, contacts lists, sales information, etc
  • DecryptMSN 2.0.0
    DecryptMSN is the best MSN Messenger password finder that quickly recovers lost or forgotten passwords for your MSN Messenger, Windows Live Messenger and Windows Messenger accounts

SQLite Expert Profesional 2. 1. 2000 Publisher's Products
  • SQLite Expert Personal 3. 3. 1947
    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 Professional 3. 3. 1947
    Are you developing SQLite3 databases and need an easy and powerful tool? SQLite Expert Professional is the perfect choice. It is the most feature rich administration and development tool for SQLite
  • SQLite Expert Personel 2. 1. 2000
    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

Social bookmarks:
  Add to Delicious Add to Technorati Add to Blogmarks Add to Digg Add to Reddit Add to Furl Add to Newsvine Add to Slashdot Add to StumbleUpon Add to Blinklist

Text link code :
Hyper link code:
UBB/BLOG code:

Download Now
File Size: 11.4 MB