SQLite Expert Personel
- Downloads:
- Views:
- Rating:

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).
Free download from Shareware Connection - 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.
Version: 2.1.0 | Size: 10444 KB | Platform: Win2000, Windows Server, WinOther, WinVista
Released Date: | Rating: 0 | Title: SQLite Expert Personel
Author Url: http://www.sqliteexpert.com
Program Info Url: http://www.sqliteexpert.com
Download Url: http://www.sqliteexpert.com/SQLiteExpertPersSetup.exe
SQLite Expert Personal - 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.
SQLite Expert Professional - 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.
Microsoft Application Virtualization Dashboard
Active Directory Auditing Reports
BroadWave Pro Streaming Audio Server
JiJi Active Directory Reports
Mac Trash Recovery
JiJi GPO Search
BigAnt IM Server
Active Directory Management Software
BlissRADIUS
WMS Log Analyzer Enterprise Edition
WMS Log Analyzer Standard Edition
Webcam 1-2-3 v
WMS Log Storage Standard Edition
Proxy Log Explorer Standard Edition
SQL Script Builder - SQL Script Builder is software that create a database sql script from any ODBC data source. The script produced will create the table(s) and the records. Scripts are available in 5 output formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL.
Windows Azure SQL Database Management Pack for System Center 2012 - Windows Azure SQL Database Management Pack for System Center 2012 was especially designed to provide developers and administrators with a means of tracking the performance parameters and availability of Azure SQL Database applications.
SQL Management Studio for SQL Server - SQL Management Studio 2011 for SQL Server is a complete solution for Microsoft SQL Server database administration and development.
SQL Script Runner - SQL Script Runner is a useful application that will enable you to load multiple SQL scripts, provide the SQL Server IP and select a database to run the script against.
SQL Management Studio 2011 for SQL Server - SQL Management Studio 2011 for SQL Server is a complete solution for Microsoft SQL Server database administration and development.
Shareware Connection periodically updates pricing and software information of 'SQLite Expert Personel' from company source 'Bogdan Ureche' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using 'SQLite Expert Personel' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of SQLite Expert Personel.
Panda Cloud Cleaner - PC security has become a tricky and complicated subject both for home users and network supervisors, with complexity and risk factors multiplying over the years. Using a single antivirus app may not be enough anymore. That explains why many users ...
RawTherapee - There are so many image editors out there but when it comes to powerful and versatile RAW file editors, the choices are somewhat limited. With Adobe switching to Cloud-based subscriptions for most of its apps, semiprofessional users including ...
Sigma Internet Monitoring - There is no denying the huge importance of internet in human life. Without the web, it has literally become imposable to carry on a lot of personal and professional activities, irrespective of your age, gender and qualification. While the web ...
NovaBench - PC performance benchmarking is something that may not interest average users much but tech savvy lot resort to such apps to find out prowess and capability of their laptops and desktops. While there are quite a few PC benchmarking apps in market, ...
Bolide Movie Creator - Not many PC users ventured into editing video clips even a few years back. It was a task reserved for studio setups and professionals. However, emergence of mobile video recording devices, access to internet has changed things in recent times. ...
PureSync Personal - When you use computers, there is no way you can escape using specialized third party software. These need to be used for various needs including office productivity, web access, taking back-up and ensuring proper synchronization across multiple ...
Diver Reviver - It is not only malware and viruses that can affect performance of your computer. Malfunctioning and outdated drivers for hardware components can also affect speed and performance of a PC perceptibly. While seasoned users take the pain of ...
Soft4Boost Slideshow Studio - Nowadays you can record video using a number of devices including smart phones and tablets. However, some people still prefer using still images and music to create slideshows. Slideshows can be created for preserving fond memories digitally with ...
Tiranium Premium Security 2014 - Antivirus or Internet security software has become a mandatory requirement for computer users, including casual users and network administrators. However, it is quite commonplace for average PC users to get a little confused when selecting a ...
Pixelmator - There is no denying the fact that Mac users are often left with fewer third party app choices than those who use Windows based PCs. However, when it comes to imaging, the situation is a little better. If you want a versatile image editor for Mac ...


