newObjects (fromerly known as ZmeY soft) SQLite COM database (part of AXPack1)
Home Products Docs & Libs
pixel.gif (49 bytes)
Home
Products by category
ALP site
ISAPI filters
ActiveX
Forums (discussions)
Buy direct (RegNet)
Articles and samples
Documentation online
Links
ACOMTools

Read more ...
Click here
ALP is implemented as an Asynchronous Pluggable Protocol. It acts like a WEB server but without need of network. It executes WEB applications such as ASP pages and CGI applications. ALP makes Internet Explorer to be server and client. With ALP you can write stand-alone desktop applications, CD-ROM autoruns, use ASP for pure desktop software and still keep your code ready to run on WEB servers too.
Write desktop software in ASP and CGI!
download it


Webscripts directory

Site navigation
Products
ActiveX components



HTML Parser Light

Parse HTML content to a document tree, change it regenerate it. Wtih this component you can do what the browsers do - understand the page. Can be used for development of HTML template systems, indexing of HTML content and many other tasks.


Highlights of the day
Active Label ActiveX
Barcode ActiveX? Much more - the design and printing inside your WEB application
SQLite3 COM
SQLite3 COM ActiveX embeds the SQLite3 database engine and interface to it. Supports paremeterized views and triggers.
Active Local Pages 1.2
Write desktop apps in ASP and CGI. Create wutorun CDs using WEB technologies - yes it is possible!
ActiveX Pack1 family
Desktop Windows, CE/CE.NET and PocketPC! About 50 powerful components for all the Windows platforms.
AXGate 1.1 (new)
Script dafely any ActiveX in Pocket IE. Build applications in HTML and use local resources and components in them.
IE ScriptBar
Create complex toolbars for Microsoft Internet Explorer easier than you may have expected.

Licensing types legend
(M) Single machine license
(U) Unlimited per-company license
(D) Unlimited development license
(S) Special type of licensing

ASP Experts

Quick contact
General
zmeyinc@newobjects.com
Support
support@newobjects.com
Sales
sales@newobjects.com

Jan

Active visitors
106
Suggested links
Suggest this page to the other visitors. Click the button below to place this page in the list above .

 SQLite COM database (part of AXPack1)   
Price: FREEWARE Discount for resalers FREEWARE
Information Download Buy
SQLite COM Overview
Database interface illustrated
Download

SQLite COM Overview

Related products and tools
ActiveX Pack1
Core of the AXPack1 family -  SQLite COM needs it. About 30 components for CE and desktop.
NetStreams
Networking addition to ActiveX Pack1 family.
Active Local Pages
Write desktop applications in ASP and CGI. (the pack is also included with it).
AXGate
Script any ActiveX in Pocket IE
CE App manager Inovker
You may need this for your Pocket PC installations.
Script service
If you want to build Windows NT/XP service in script.
NDL
newObjects Development Library - combined documentation.
ASP Compiler
Compile scripts in DLL through VB or/and Create active projects to generate static content. Uses ActiveX Pack1 as run-time library.
Fully functional in-process SQL database engine

SQLite COM (or precisely SQLite2 COM) is a zero-configuration, in-process, SQL database engine which is implemented in a single DLL. It is a member of the newObjects ActiveX Pack1 Family and depends on the AXPack1 core DLL only. 

The SQLite COM is based on the source code of the version 2.8.15 of the popular SQLite database engine (see www.sqlite.org ). However SQLite COM contains not only the engine but also the COM interface to it and set of added features making it more convenient for Windows environments.

The key features in short

Because SQLite COM is based on a public domain source code the features specific to SQLite COM (not inherited from the SQLite original source code) are marked in the list below.

  • The databases are single file - all tables, views, triggers and other DB objects are kept in a single file.
  • No static configuration is needed. The application just opens a database, optionally adjusts the behavior of the interface and executes SQL queries over the opened database.
  • Fairly good level of SQL92 support. Support for triggers, views, indices.
  • Autorun ready. (SQLite COM specific) The library is compatible with the ALP autorun specification - can be used on-the-fly not without need of registration with the system.
  • Common database file format on all the platforms. No matter where your application works - on a Pocket PC, on a desktop or on a smartphone the database file has the same format and can be copied without conversion between the platforms and used immediately. 
  • Transactions support. While nested transactions are not supported the one-level transactions can pack unlimited number of SQL statements.
  • Faster than most of the other embedded databases.
  • Active scripting compatible DB interface. (SQLite COM specific)
  • Independent of ADO, Jet, OLEDB. No compatibility and version issues if the both DLL are with your application nothing else is needed.
  • OLE Date/time types internal support. (SQLite COM specific) A set of DB functions provides text-to-date and reverse conversions, date based calculation and comparison.
  • UTF-8 internal format. All the national characters are preserved in the database and there is no need to specify code pages!
  • Supports: Windows 95/98/ME, Windows NT4/2k/XP/2k3 and later, Windows CE 3.0/CE.NET 4.0 and later including Pocket PC and Smartphone.

The database interface 

Although most developers are used to recordsets SQLite COM deviates from that popular practice. The results are unexpectedly convenient! Combined usage with Sprintf/SCprintf and SAprintf from the StringUtilities object from AXPack1 core the simple SQLite COM database interface allows all the database operations to be implemented in 3 to 4 times less code with drastically reduced memory and temporary file usage (compared to the recordset based interfaces).

The SQLite COM interface resembles features from recordsets and ADO's GetRows method in a fashion that preserves the most useful features, but eliminates the need of additional operations and simplifies the access to the database fields. It is simple and easy to learn. See the illustration of SQLite COM usage.

Type-less but aware of the field types

SQLite is by default type-less database. This implies, for instance, that each field can be treated as MEMO and as short text field as appropriate. This is almost unique among the databases and may look strange to those who meet it for the first time. However it takes nothing from the functionality and yet provides some otherwise impossible opportunities. This means that the application may or may not obey field size limitations depending on what is more convenient for it.

On the other hand SQLite COM is type aware. The COM interface can be adjusted through a few simple properties to perform automatic type conversions when the data is fetched from the database and thus serve the application with ready-to-use values converted to the types implied by the field definitions and the SQL expressions. As the SQLite DB engine is not interested in the details each application can define its own field type names and their meaning. This is particularly useful when porting SQL from another database engine - where porting to another database engine may require re-definition and conversion of the database structure SQLite COM can be configured at run-time to resemble the types of the another database engine.

Can it be used on servers?

Yes, of course! It can be employed on a WEB server or you can even build a small database server with TCP/IP connectivity using the NetStreams member of the AXPack1 family in a few hours. Still the SQLite COM is primarily designed to serve as embedded database and it is not a replacement for a database server that services thousands of concurrent clients, but for small offices and databases not used too intensively it can do fairly good job for zero price!

Licensing

As like the entire newObjects ActiveX Pack1 Family SQLite COM is freeware. Support is offered for all the customers who have a development oriented license for one or more of our products that include the ActiveX Pack1 family as run-time library.



Copyright newObjects (ZmeY soft) 2001-2005