Quality Interior Design
 
EzTools Software Logo Quality Windows Programming Tools
Because Presentation is Everything
  
 
Home Buy Support About Us

SQLitePlus COM DLL & Database Explorer

 

  Products
SQLitePlus  
Database Explorer  
COM DLL  
Compression & Encryption  
Stored Scripts  
FAQ  
Licensing  
FileDb Simple .NET Database  
ConfigDb  
EditListView Enhanced ListView  
WOW WebBrowser  

 

  Version 7
     try before you buy - with nag dialog

 

A SQL database in a single file

SQLitePlus is based on SQLite (www.sqlite.org).  It consists of 2 tools: the SQLitePlus COM DLL and SQLitePlus Database Explorer (free app).  SQLitePlus Explorer is an app for viewing and administering your SQLite databases. The SQLitePlus COM DLL is for use by your programs to easily access SQLite databases programmatically.  This COM DLL gives you lightning speed access to SQLite database files from your Windows language of choice - C#, VB6, C++, VB.NET, Delphi, etc. 

Here is what the sqlite.org website says about SQLite:

"SQLite is a small, fast, embeddable SQL database engine that supports most of SQL92, including transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. A complete database is stored in a single cross-platform disk file."

SQLite is written in C and therefore not accessible from many high-level languages. We have created an "ADO-like" wrapper COM DLL for the SQLite C library, making it possible (and easy) to use this powerful SQL database engine from higher level languages, such as Visual Basic, Delphi, C#, etc., but with NO ODBC/OLEDB drivers or ADO required.  The SQLitePlus COM DLL and Database Explorer extend the functionality of SQLite to add these important features:

  • COM DLL, which can be used from almost any high level language
  • Separate Database Explorer
  • Stored Scripts (like Stored Procedures)
  • On-the-fly Encryption and Compression
  • ADO-like object model
  • Built-in RegEx function
  • Ease of use

Ideal Access Database Replacement

"We are using MS Access & ADO and the overhead is huge. Our installation program can't be downloaded from the web because the DB and components require about 15MB.  SQLitePlus solves this and is faster to boot."

One of the biggest dilemmas for distributed commercial application developers is, "what database do I use?".   If you have ever needed a small, robust and powerful desktop SQL database to ship with your Windows applications, SQLitePlus is the answer you have been looking for.

SQLitePlus Database Explorer  

Use SQLitePlus Database Explorer to view your SQLite databases.  You can create/drop/view Tables, Views, Stored Scripts, Triggers, and Indexes, and also perform SQL queries and commands to view and otherwise manipulate your data.  The data is displayed in a grid control, allowing you to copy the data to files or other programs.  You can open multiple databases at the same time, and open any number of Query windows.

SQLitePlus COM DLL

The SQLitePlus COM DLL is a "wrapper" around the SQLite C library.  You use this DLL to access SQLite databases from your Windows programs.  Since it s a COM DLL, it is usable by most common Windows programming languages (eg. VB, C++, Delphi, .NET languages, etc.).  SQLitePlus Admin uses the COM DLL for all of its database access, so you can see just how powerful it is.  And best of all, YOU DON'T NEED MDAC or any other database install.

Stored Scripts

We have integrated the Microsoft Scripting Engines - VbScript and JScript - into SQLitePlus.  This is an amazing feature that you really should check out (samples included in the download).  Click here for more info on Stored Scripts.

CSV File features

Many people today still work with CSV and TAB-delimited files daily. SQLitePlus can easily import and export these files formats directly to/from SQLite database files. This can be done both with the SQLitePlus Database Explorer and with the SQLitePlus COM DLL (the SQLitePlus Database Explorer actually uses the COM DLL's SqliteDb.Import and SqliteDb.Export functions). All file formats are supported:

- UTF-8
- UTF-16
- CodePage

What this means for you is that you can suck a CSV file into a SQLite database using the Import facility and immediately begin working with it using SQL. Or you can very easily export any data to a CSV/delimited file using the Export facility.
 

No ODBC/OLEDB drivers needed (or wanted)

The SQLitePlus object model is very similar to ADO (Microsoft ActiveX Data Objects).  But SQLitePlus IS NOT A ODBC/OLEDB DRIVER.  There are a couple of good reasons for this: 1) This product is designed for applications that need to store its data in a local database and DO NOT want the overhead of installing ODBC/OLEDB drivers nor requiring ADO to be installed, and 2) SQLite is extensible (things like user-defined C functions), and SQLitePlus will provide a means of allowing higher level programming languages access these "hooks".  This could not be done if implemented as an OLEDB database driver.  Another good reason is performance: SQLitePlus has very little overhead because it is a very thin wrapper around the SQLite C library.




 

Copyright © EzTools Software2001-2010 All rights reserved. Trademarks and Disclaimer:
All trademarks belong to their respective companies.