Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 30.131.213 Times

SQLite Expert Personel 2. 1. 2000

Company: Bogdan Ureche
Date Added: January 29, 2013  |  Visits: 312

SQLite Expert Personel

Report Broken Link
Printer Friendly Version


Product Homepage
Download (30 downloads)

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

Requirements: No special requirements
Release Date: January 29, 2013
Platforms: Windows2000, Windows2003, WinXP, Windows Vista
Keyword: Database Database Management Edit Table Script Sql Sql Script
Users rating: 0/10

License: Freeware Size: 10.2 MB
SQLITE EXPERT PERSONEL RELATED
Programming  -  Gaud - Database Visual Editor 5.1
Build around JDBC and XML, this tool allows you to maintain visual repesentations of a database's layout, edit table's data, generate code to bind objects to tables, and export data in XML format to easely export data from one database to another.
82.51 KB  
Database Tools  -  Gladius DB 0.7.0
Gladius DB is a fast and efficient PHP flatfile database engine written in pure PHP; its SQL syntax is compatible with a subset of intermediate SQL92. You will not need any specific extension to have it work, and it is bundled with an adoDB lite...
57.34 KB  
Database Tools  -  SQL Database Studio 2.0.8.1
SQL Database Studio is modern professional client for Microsoft SQL Server. It enables you to effectively work with SQL Database. SQL Database Studio contains advanced features such as database comparison, GPS visualization, table lookups,...
6.04 MB  
Database Tools  -  Clone Table for MS SQL Server Professional 1.06.42
Clone Table for SQL Server Professional is an application that enables you to create copy of selected table (schema and data) to same database. This operation is required in the next case: you need to verify some idea against live (not generated)...
 
Automotive Information Databases  -  Database Browser Portable 3.2.2.19
This easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. There are two versions available. Standard and Portable Standard version can be installed on Windows PC....
2.28 MB  
Automotive Information Databases  -  Database Browser 3.3.0.2
This easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. There are two versions available. Standard and Portable Standard version can be installed on Windows PC....
2.47 MB  
Database Tools  -  ApexSQL Search 2014.01
ApexSQL Search analyzes SQL Server database object's dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects...
6 MB  
Business  -  TOAD for DB2 4.6.2.573
TOAD for DB2 is a database development solution that provides productivity features/functions for rapidly creating and executing queries, facilitating database object management, developing SQL code, and instant access to DB2 expertise. Developers...
77.8 MB  
Business  -  SQL ODBC Query Builder 1. 8. 2001
This application allows for dynamic and extensive constuction of database queries, including multiple table joins, extended boolean statements, calculated fields, user override options, data dictionaries, output of large text fields and...
4.86 MB  
Business  -  eva/3 Universal Database Converter (UDC) 1.2
The Universal Database Converter transfers complete database data structures, data repositories, and indices from one database system to another. Table relationships with primary and foreign keys are also taken into account and transferred into...
2.94 MB  
NEW DOWNLOADS IN NETWORK & INTERNET, SERVER TOOLS
Network & Internet  -  vShare Download 2.1.4
Most apps store can't download and install apps, game, wallpaper, ringtone, without any cost for iPhone, iPad, iPod touch, Android and Windows computer, but vShare is the great place for free download and install more than million of apps and...
67.23 KB  
Network & Internet  -  AD Browser 6.10
AD Browser is a free Active Directory® browser by LDAPSoft. It is simple and easy to use tool designed to provide a read only access to the active directory. With AD Browser you can search for entries, view all available attributes and run...
41.77 MB  
Network & Internet  -  FreeStyler for Chrome 2.3.2.14
FreeStyler is a browser add-on that has everything you might need to style up websites you visit according to your taste. It provides a great number of ready-to-use styles with convenient system of managing them. User style is a skin for a...
587 KB  
Network & Internet  -  PCMate Free WiFi Hotspot Creator 6.6.9
PCMate Free WiFi Hotspot Creator is a free virtual WiFi hotspot creator for Windows which allows you to instantly turn your laptop into a wireless hotspot, in order to access internet without any interruption. This free WiFi router with industry...
582.47 KB  
Network & Internet  -  Webii 2.0
Capture The Real Essence of Web Automation Rid your life of repeated, boring, complex tasks that consume time and energy. Webii is here to make things simpler and easier by removing monotonous tasks from the equation. This superior tool lets...
5.05 MB  
Server Tools  -  zFTPServer Suite 10.16
zFTPServer is a multi threaded Windows file server. Although being extremely simple to use, there exists an advanced configurations mode which should satisfy every need. Also, extensions are available that makes this into a full-fledged...
2.85 MB  
Server Tools  -  AttackTracer 1.24
If your Windows server is reachable from the internet and you want certain services like remote desktop, FTP transfers or SQL-Server to be accessible from outside then attacking attempts on your server will definitely be made. Numerous automated...
3.14 MB  
Server Tools  -  VertrigoServ Apache PHP WAMP server 2.34
VertrigoServ was developed to make available a highly professional and easily installable package of Apache, PHP, MySQL and PhpMyAdmin for Windows platform. With a convenient all-in-one installer, all components are installed in a single directory...
29.5 MB  
Server Tools  -  CARDIOLOG ANALYTICS 2.0.8.3
'SharePoint visionaries, admins and end users: get the most comprehensive, all-inclusive free SharePoint analytics solution on the market to help you optimize and transform your portal, compatible with all SharePoint versions including SharePoint...
48 KB  
Server Tools  -  Thureus HMIBuilder 1.20
Thureus HMIBuilder shareware supports industrial OPC/DDE servers and visualizes the real-time data on the graphic canvas. The canvas can be designed easily by field engineers with no programming skill. All that required is fill-in-the-blank...
31.47 MB