SQLite3 client/server experiment

[Paul Squires]

I started a new client/server project using SQLite3 as the database backend. This project is almost two weeks old with a couple of good PowerBASIC friends encouraging me along the way to keep with it.

My "goal" is to make this my primary database product that I would use in all my future projects (like that accounting program that I still have only partly built!). This project will replace Cheetah Database development if all goes well.

The files can be obtained from:  http://planetsquires.com/support/index.php?topic=2307.0

I will also make a post about this over on the PB forum but I wanted you guys to know about it first. 

[José Roca]

 
Hi Paul,

I have run your test and it works fine in my computer. Windows XP SP2.

[Paul Squires]

Thanks José !

Still a bit of stuff left to work on but the main guts of the program is working extremely well.

[Paul Squires]

I just uploaded the newest version of the files (we'll call these Ver 0002) 

http://www.planetsquires.com/files/sqlite_test_0002.zip  (This file is about 3.7 megs)

2007-09-06   ver 0002
Added zLib1 compression.
Added much faster concatenation function that creates the recordset buffer to be sent to the client.
Added catalog.db3 test database (over 51,000 rows)
Added catalog.bas sample code for testing records in catalog.db3
Added PRAGMA synchronous = off when opening a database (allows for faster disk i/o)