Tuesday, December 7, 2010

SQLite Wrapper

Harbour wrapper for SQLite
I did use the Harbour compiler to made a program to gain access to a
database (with several tables inside) in SQLite format and I want to share
my experience with you.
SQLite is a C library that implements an embeddable SQL database engine.
Programs that link with the SQLite library can have SQL database access
without running a separate RDBMS process.
The distribution comes with a standalone command-line access program
(sqlite) that can be used to administer an SQLite database and which serves
as an example of how to use the SQLite library.
SQLite is not a client library used to connect to a big database server.
SQLite is the server.
The SQLite library reads and writes directly to and from the database files
on disk.
The HbSQLite program is based in the SQLite version 2.8.6.
The program is quite basic, it hasn't OOP aproach, its final goal is to show
the versatility of Harbour to gain access to other database formats.
With HbSQLite is possible the interaction between dbf files and SQLite
tables.
HbSQLite gives the possibility of using a simple, small in size, but
powerful SQL database like SQLite, with the ability to make transactions
using the simplicity of Clipper language.
It's a simple and cheap way of introducing yourself to the world of SQL
databases (with prices usually in range of thousands of U.S. dollars).
The program was specifically built to be used in console mode (DOS window)
for the windows 9x platform and maybe (I haven't tried yet) in the NT
family.
As the source code is provided, and sqlite is originally developed using the
Linux platform, it's possible with some work to get a version of the program
for this operative system.
Although I use the Harbour compiler 042 and the Borland C++ compiler BCC55,
someone who has the Microsoft C51 compiler which was used to build Clipper
5.x and with intermediate knowledge of C language, would get it a Clipper
version.

Download it from here Harbour SQLite....

No comments: