It consists of 3 tools: SQLitePlus Database Explorer, the SQLitePlus COM DLL and the SQLitePlus Grid ActiveX component (free tool). SQLitePlus Explorer is a program for viewing and administering your SQLite databases.
It consists of 3 tools: SQLitePlus Database Explorer, the SQLitePlus COM DLL and the SQLitePlus Grid ActiveX component (free tool). SQLitePlus Explorer is a program 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.
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:
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.
SQLitePlus Database Explorer and COM DLL 1.0 Puzzle software developed by EzTools Software. The license of this puzzle software is freeware, the price is free, you can free download and get a fully functional freeware version of SQLitePlus Database Explorer and COM DLL. Do not use illegal warez version, crack, serial numbers, registration codes, pirate key for this puzzle freeware SQLitePlus Database Explorer and COM DLL. Always use genuine version that is released by original publisher EzTools Software.