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

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.