Changes:

28.05.2004:

• Unofficial release of SQLite Client/Server, called SQLite_On_Sockets is posted here: http://www.it77.de/sqlite/sqlite_sockets.htm

28.05.2004:

• Prototype for network version with sockets and threads. Windows binaries and sources.

31.03.2004:

• Project File and DFM Files added to the contribution file.
• SQlite_Quick.pas: TSL_Table.Open method modified. Version Number added (0.1).

Prototype for network version of SQLite

• Server Package:
  SQLite_Server.exe Windows binary. Multithreaded Server for SQLite. Based on sqlite sources of version 2.8.13
  This library (multi-thread support) is needed by the server : cc3250mt.dll
  Example database mydb.sqlite contains one table "test" with 2 columns and 1 row.
• Client Package:
  Client library which communicates with the server: sqlite.dll This is not the same as provided by sqlite download section. You need this in order to test network interface. But the interface is the same except custom functions and all the printf... methods.
  To test this library I patched my SQLite_Browser.exe (You need it also)
• How to test :
  1. First test we do localy: Copy both packages on the same machine, start SQLite_Server, then start SQLite_Browser.
  2. In Browser go to File|Open Remote Database, do not change anything and just click on OK.
  3. You should see the structure of mydb.sqlite database.
  4. If this works proceed with a proper network test:
  5. Copy Server Package on one PC (This will be the Server PC) and start SQLite_Server.
  6. Copy Client Package on another PC which has network connection to the Server PC and start SQLite_Browser
  7. In Browser go to File|Open Remote Database, change "localhost" to the IP Address or Name of the Server, click OK
  8. You should see the structure of mydb.sqlite database.
  9. Copy another database file in Server Package directory and try to open it remotely from SQLite_Browser (see step 7) (dont't forget to change the name "mydb.sqlite" to your filename in the prompt :-) )
  10. Report results, suggestions to the sqlite wiki : http://www.sqlite.org/cvstrac/wiki?p=ClientServer

   

• Sources contains some GPL parts (ezsocket). Threads and Object files were written by me for another project (AnT4669) which is also under GPL. So currently all sources have to be under GPL. All parts are portable to Linux, but i didn't try to compile and test (need Makefiles). Some files are automatically generated from methods.def and templates(not included) using my own code generator (not included). I am thinking about to put it on Source Forge. But i will have not so much time for coding ...
  Sources (GPL) download: source.zip (sqlite sources needed by the server are not included)

28.05.2004, Alex K.

SQLite Quick: Delphi Classes for SQLite

SQLite is a free SQL Database programmed in C. See the Hompage for details http://www.sqlite.org

Some code (how to use dll) was taken from the http://wiki.sqlite.dubaron.com/

The main idea was to provide fast wrapper classes using the sqlite data structures to store the data.

SQLite provides two methods of retrieving data. The hole table in one turn or callback's for every row.
Both methods were wrapped as classes, based on a common interface (row-based). They can be connected to a database(the third wrapper class)

This package contains :

SQlite_Quick.pas: Delphi Wrapper for sqlite
SQlite_DateTimeFunctions.pas: Date/Time and other Functions for sqlite
SQlite_Browser.exe : Browser for sqlite tables
BestStringGrid.pas : Source for improved StringGrid (real multiselect)

sqlite.dll : library compiled with borland bcc
sqlite_test.pas : source for SQlite_Browser (=example of using files above)
table_edit.pas : "

Project File and Formular Files needed to compile with Delphi 7

Download sqlite_contribution.zip (484 kb) Last Updated 31.03.2004

Download sqlite.dll (160 kb) Version 2.8.6 compiled with borland bcb. Compatible only with this wrappers, because of prefix "_" in dll functions

Visits: