Main > Network & Internet > Database Utils >

SQLite Expert Personal 2.0.4



 

SQLite Expert Personal 2.0.4

Sponsored Links

SQLite Expert Personal 2.0.4 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 4.77 MB
Platform: Windows2000,WinXP,Windows2003,WindowsVista
License: Freeware
Price: $0
Downloads: 196
Date added: 2009-04-18
Publisher: Bogdan Ureche

SQLite Expert Personal 2.0.4 description

SQLite Expert Personal 2.0.4 is a powerful and easy to use tool which is designed to give you an advanced way 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 and PNG image formats. BLOB fields can be edited with the integrated hex editor.
  • Execute SQL queries and display results in the grid or as text.

Major Features:

  1. Managing SQLite3 databases
    • Create database
    • View and change database parameters
    • Register frequently used databases for using in SQLite Expert
    • Check integrity
    • Vacuum
    • Transaction support
    • View database schema report
    • Export to Excel
    • Export to XML
    • Import and export from and to text files (CSV, TSV)
    • Import data from ADO data source
    • Transfer data between SQLite databases  
    • Export data to script
  2. Managing tables
    • Create tables
    • Delete tables
    • Rename tables
    • Restructure tables without losing existing data
    • View, add, delete, modify, reorder fields
    • View, add, delete, modify indexes
    • View constraints
    • Add, delete, modify constraints
    • View triggers
    • Add, delete, modify triggers
    • Supports temporary tables
  3. Managing views
    • Create views
    • Delete views
    • Rename views
    • View triggers
    • Add, delete, modify triggers
    • Supports temporary views
  4. Executing SQL scripts
    • Execute SQL scripts
    • Stop long running queries
    • SQL history
    • SQL syntax highlighting
    • Save and load SQL scripts
  5. Query Builder
    • Completely visual building of complex SQL queries
    • User-friendly interface with drag & drop support
    • Visual building of sub-queries and unions
    • Visual criteria constructing tool for Where and Having clauses
    • Save and load SQL scripts
  6. Displaying and editing data
    • Display and edit data in the grid
    • Display data as text
    • Data filtering
    • Image editor (supports BMP, JPG and PNG)
    • BLOB editor
    • Text editor
    • Generate HTML Reports
  7. Extending SQLite Expert using scripting
    • Lua scripting support
    • Pascal scripting support
    • Lua and Pascal example scripts
  8. Data types
    • 40 predefined data types
    • Custom data types

Enhancements:
  1. Improved Unicode support

    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 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".
  2. Statically linked sqlite3 library
    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).
  3. No bug fixes between 1.7 and 2.0
    During the migration from Delphi 2007 to Delphi 2009, all the bug fixes have been implemented in both versions 1.7 and 2.0, so if a bug exists in the latest 1.7 version and is not Unicode related, there is a good chance it is still present in version 2.0. However, at the time of the 2.0 released, all the reported bugs have been fixed. Also, after the release of 2.0 no more bug fixes will be implemented in 1.7, so it is recommended to upgrade to version 2.0 to keep up with the latest updates.
  4. Upgrading an existing 1.x Professional license to 2.0
    If you own a license for SQLite Expert Professional 1.x, you may upgrade to version 2.x at no additional cost.
WareSeeker Editor

SQLite Expert Personal 2.0.4 Screenshot

SQLite Expert Personal 2.0.4 Keywords

Bookmark SQLite Expert Personal 2.0.4

Hyperlink code:
Link for forum:

SQLite Expert Personal 2.0.4 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for SQLite Expert Personal 2.0.4. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
SQLite Expert Professional 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. Free Download
Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also can be used to create and restoring backups, transfer data between databases, tables and data files or edit database schema. Free Download
SQLite Analyzer - Process SQLite databases visually with SQLite Analyzer! Free trial! Free Download
Sqlite Developer, a powerful sqlite3 database manager! * SQL Editor with syntax highlight, autocomplete, unicode support, live syntax check. * Visual schema management. * Export/Import data. * Support Free Download
create columns in database reports Free Download
Program to export data from MySQL databases to any of 15 available formats. Free Download
Converts SQLite to dbf, xml, csv, txt, sql. Creates reports in xls, doc, html Free Download
Program to export data from PostgreSQL databases to any of 15 available formats. Free Download