Find more
Windows programming tools at
 
   
  EzTools Software Logo Quality Windows Programming Tools
Because Presentation is Everything
EditListView Editable ListView
Customizable XP style ListView
Set colors, fonts, and much more
more info
 
Home  Downloads  Buy Support Services FAQ About Us

SQLitePlus COM DLL & Database Explorer

 

Product Quicklist  
  Database Products
SQLitePlus & SQLite++  
Database Explorer  
COM DLL  
SQLite++  
Compression & Encryption  
Stored Scripts  
Grid ActiveX  
FAQ  
Licensing  
SQLite.NET DLL  
SqlWeb COM DLL  
  HSP System
Overview  
HTML Scripting Pages  
EzWeb Compiler  
EzReg Copy Protection  
  ActiveX Components
EditListView Enhanced ListView  
WOW WebBrowser  
BrowserList HTML Listbox  
HotButton ActiveX  
HotLink HTML HyperLink  
HotList HTML Listbox  
SuperCombo HTML Droplist  
TabStrip ActiveX  
  Other Products
RegDb COM DLL  
Zip COM DLL  
Source Code  
EzComm Messaging DLL  
EzScript XML Generator  

 

  Version 6 now available (for SQLite 3 database format)
     try before you buy - with nag dialog

*** You get a free Database Explorer license when you purhcase ***

SQLitePlus Database Explorer
SQLitePlus COM DLL

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.

Create stylish "XP style" buttons buttons with the HotButton control.
 
 
The HotButton can have completely customized dropdown menus.
 

 

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