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