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. 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 Personel 2.1.2000
Publisher: Bogdan Ureche
License: Freeware
Size: 10.2 MB
Downloads: 804
Price: Free
   
Platforms:  Windows2003 , Windows2000 , Windows Vista , WinXP


Latest Downloads from Bogdan Ureche

SQLite Expert Profesional 2.1.2000 Download SQLite Expert Profesional 2.1.2000

SQLite Expert Profesional 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...

SQLite Expert Professional 3.0 Download SQLite Expert Professional 3.0

SQLite Expert Professional 3.0

SQLite Expert Professional is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better...

SQLite Expert Personal 3.2 Download SQLite Expert Personal 3.2

SQLite Expert Personal 3.2

SQLite Expert Personal is a very powerful SQLite3 database manager. Not only does it have powerful GUI tools to help you manipulate the databases,...



Related Downloads

Microsoft Access 2010 14.0.4760.1000 Download Microsoft Access 2010 14.0.4760.1000

Microsoft Access 2010 14.0.4760.1000

Microsoft Access 2010 is all about simplicity and empowering you to make the most of your information, even if you’re not a database expert. And,...

FBClone 2.1.2004 Download FBClone 2.1.2004

FBClone 2.1.2004

FBClone is a small utility that can clone a Firebird database in one shot (instead of backup/restore cycle) and pump data from one database to...

OmniAudit 1.14 Build 495 Download OmniAudit 1.14 Build 495

OmniAudit 1.14 Build 495

OmniAudit installs complete data change auditing in your SQL Server database in just a few minutes. Audit every field in every table, or pick and...

Datanamic MultiRun for MySQL 2011.02 Download Datanamic MultiRun for MySQL 2011.02

Datanamic MultiRun for MySQL 2011.02

Datanamic MultiRun for MySQL is a simple tool to quickly execute multiple SQL scripts against multiple MySQL databases. Define a list of databases,...

SQL Uniform Professional 1.8.2001 Download SQL Uniform Professional 1.8.2001

SQL Uniform Professional 1.8.2001

SQL Uniform is a database client, graphical user interface (GUI), a helper application to relational databases of various types regarding query,...

SQLite2009 Pro Enterprise Manager 3.7.6.2 Download SQLite2009 Pro Enterprise Manager 3.7.6.2

SQLite2009 Pro Enterprise Manager 3.7.6.2

SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Features: * Encryption Method is now...

Portable RazorSQL 5.6.2003 Download Portable RazorSQL 5.6.2003

Portable RazorSQL 5.6.2003

The Portable RazorSQL application can help you query, update, navigate, and manage all major databases. With Portable RazorSQL, an SQL query tool,...

AmoK xml2sql 1.0 Download AmoK xml2sql 1.0

AmoK xml2sql 1.0

AmoK xml2sql converts XML-Dumps made with PhpMyAdmin back to SQL. AmoK xml2sql does not need a GUI and runs with command line. AmoK xml2sql is...

SQLite Expert Profesional 2.1.2000 Download SQLite Expert Profesional 2.1.2000

SQLite Expert Profesional 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...

Windows Server 2003 - XP Conversion Pack 2.0 Download Windows Server 2003 - XP Conversion Pack 2.0

Windows Server 2003 - XP Conversion Pack 2.0

Windows Server 2003 is well known for its superior speed, stability, and security when compared to Windows XP.This fact is proven by Microsoft’s...

View additional Servers downloads at 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71


New Downloads

ICS CUBE 5.2.5.180412 Download ICS CUBE 5.2.5.180412

ICS CUBE 5.2.5.180412

ICS CUBE is designed to address a broad scope of issues small or medium business faces when operating corporate network attached to the Internet....

ProVide 12.0 Download ProVide 12.0

ProVide 12.0

Great business solutions improve your day
Rest easy with effortless and secure file access for users and teams. ProVide is the answer for...

Net Time Server & Client 3.2.1.2358 Download Net Time Server & Client 3.2.1.2358

Net Time Server & Client 3.2.1.2358

The Net Time Server & Client application allows you to synchronize your PC's system clock or all PC's system clock in your LAN using various...

quickSMTP 0.1 Download quickSMTP 0.1

quickSMTP 0.1

quickSMTP is a fast and efficient mail server for Windows and is fully compliant with SMTP and POP3 specifications. It is free for use and provides...

zFTPServer Suite 11.3 Download zFTPServer Suite 11.3

zFTPServer Suite 11.3

zFTPServer is a multi threaded Windows file server. Although being extremely simple to use, there exists an advanced configurations mode which...

RDS WebAccess 10.4 Download RDS WebAccess 10.4

RDS WebAccess 10.4

RDS-WebAccess is using HTML5 to open Remote Desktop with any web browser. Its high performance HTML5 RDP Client is providing browser based access...

VPSrobots 0.1.1 Download VPSrobots 0.1.1

VPSrobots 0.1.1

VPSrobots
Do you get tired of that your time is stolen by endless tedious works on servers managing and websites building. If so, don't be...

RDS Knight 1.4 Download RDS Knight 1.4

RDS Knight 1.4

RDS-Knight is the optimal solution to detect cyber threats, defend RDS servers and develop remote desktop systems' security. Cyber criminals know...