|
A SQL database in a single file
SQLitePlus is based on SQLite (www.sqlite.org).
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 Interface
-
Stored Procedures
-
Encryption
-
Compression
-
ADO-like
functionality
-
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?". Many choose Microsoft Access, but are then
left with the task of including the necessary ODBC or OLEDB drivers plus the
required ADO DLLs (MDAC). Its a huge overhead to need to ship with your
application (12-15MB). But no more with SQLitePlus. SQLitePlus is
faster and has more features than Access - and you get much of
the same functionality as with ADO but in a single
COM DLL. 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.
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.
|