X-Authentication-Warning: delorie.com: mail set sender to djgpp-bounces using -f Newsgroups: comp.os.msdos.djgpp Subject: Re: Re: database library? References: <20040808140001.CGNK19099.fep14@[212.117.129.234]> Message-ID: Date: Tue, 10 Aug 2004 10:11:43 -0400 From: boohiss Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 User-Agent: Opera M2/7.52 (Win32, build 3834) NNTP-Posting-Host: 128.146.230.62 X-Original-NNTP-Posting-Host: 128.146.230.62 X-Trace: post.usenet.com 1092147105 128.146.230.62 (10 Aug 2004 09:11:45 -0500) Organization: Usenet.com http://www.usenet.com 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet! Lines: 87 X-Comments: This message was posted through Usenet.com's, FREE publicly accessible Usenet Server - "post.usenet.com" X-Comments2: IMPORTANT: Usenet.com 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 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 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from Quoted-Printable to 8bit by delorie.com id i7AEF3IG031837 Reply-To: djgpp AT delorie DOT com **** Post for FREE via your newsreader at post.usenet.com **** On Sun, 8 Aug 2004 17:02:37 +0300, 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. Alex, 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 for 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 some (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, Matt -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ - *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -