Mail Archives: djgpp/2004/08/10/10:16:51

X-Authentication-Warning: mail set sender to djgpp-bounces using -f
Newsgroups: comp.os.msdos.djgpp
Subject: Re: Re: database library?
References: <20040808140001.CGNK19099.fep14@[]>
Message-ID: <>
Date: Tue, 10 Aug 2004 10:11:43 -0400
From: boohiss <boohiss AT cubesource DOT net>
MIME-Version: 1.0
User-Agent: Opera M2/7.52 (Win32, build 3834)
X-Trace: 1092147105 (10 Aug 2004 09:11:45 -0500)
Organization: 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet!
Lines: 87
X-Comments: This message was posted through's, FREE publicly accessible Usenet Server - ""
X-Comments2: IMPORTANT: does not condone, nor support, spam or any illegal or copyrighted postings.
X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!!
X-Report: Please report illegal or inappropriate use to <abuse AT usenet DOT com>
X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS)
To: djgpp AT delorie DOT com
DJ-Gateway: from newsgroup comp.os.msdos.djgpp
X-MIME-Autoconverted: from Quoted-Printable to 8bit by id i7AEF3IG031837
Reply-To: djgpp AT delorie DOT com

**** Post for FREE via your newsreader at ****

On Sun, 8 Aug 2004 17:02:37 +0300, <alexbodn AT 012 DOT net DOT il> wrote:

> on the other hand, the sqlite api is much simpler, and with the same  
> effort on your side, you can perform complex data manipulation and  
> querying.
> performing an sql query prorovides a printf like interface, and the  
> result may be collected in an array of char *'s.
> although parsing values from strings is more time consuming than reading  
> into binary form, the number of records to sequentially scan can be  
> highly reduced using sql.
> just to take into consideration the prospective growth of your software  
> project, i believe you will surely exploit sqlite better than btrieve,  
> for most normal usage.


	Thank you for responding to my message, and thank you for your hard
work on both btrieve and sqlite!  At first glance, SQLite seemed perfect  
me, since I use SQL in my programming on a daily basis.  I compiled it  
with DJGPP
and the library seemed to work okay (despite my inability to get the DIFF  
patch to work).

	The only difficulty I have is that I am very much used to programming with
DAO or ADO.NET in VB or C# respectively, and the documentation was hard  
for me to grasp.  There
was also a lack of very simple examples that my tiny brain can  
comprehend.  The SQLite
library and the shell program that came with it seemed very comprehensive  
and well-done,
but I really don't need anything beyond a few simple queries, and I was  
unable to get
even a simple SELECT query to work.

	I really would like to use SQLite, however.  Could you provide me with  
(very) simple examples to give me a push in the right direction, perhaps?   
For instance,
just a simple program to create a table, put a few rows in it, and then  
query it.

Thanks very much for your help so far,


Using Opera's revolutionary e-mail client:

- *** - The #1 Usenet Newsgroup Service on The Planet! ***
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored

- Raw text -

  webmaster     delorie software   privacy  
  Copyright 2019   by DJ Delorie     Updated Jul 2019