*** 1,6 **** **Using SQLite on a Network** ! SQLite database files may be shared accross a network using a network filesystem. This is never a particularly efficient method and may have problems (depending on the filesystem, or may simply not be available. These are alternative techniques for remote access to SQLite databases. --- 1,8 ---- **Using SQLite on a Network** ! SQLite database files may be shared accross a network using a network filesystem. This is never a ! particularly efficient method and may have problems (depending on the filesystem, or may simply not ! be available. These are alternative techniques for remote access to SQLite databases. *************** *** 8,14 **** *uSQLiteServer and Client* (http://users.iol.it/irwin/) ! The uSQLiteServer implements a simple ASCII protocol to access an SQLite database over sockets. The corresponding C client allows access to the server using exec/callback functions similiar to those in the C API interface. It is not a drop in replacement but should be easy to retrofit. There is also a basic security implementation to control access to the database. It is in the public domain. --- 10,19 ---- *uSQLiteServer and Client* (http://users.iol.it/irwin/) ! The uSQLiteServer implements a simple ASCII protocol to access an SQLite database over sockets. The ! corresponding C client allows access to the server using exec/callback functions similiar to those in the ! C API interface. It is not a drop in replacement but should be easy to retrofit. There is also a basic ! security implementation to control access to the database. It is in the public domain. *************** *** 20,30 **** Note that this is in an experimental state and any feedback is appreciated. ! So far it has been tested with SQLite 2.8.15 and SQLite 3.0.7 on Windows NT/2000 in MS Excel 97 (MSQUERY) with SQLite database files created on Linux. It also runs on Linux with unixODBC 2.{0,1}.x and with libiodbc 3.0.6. {linebreak} {linebreak} ! I know that the developer of the SQLite ODBC Driver has no time to continue development in the next months because of his job.{linebreak} ! *Is there someone who could help him to update the ODBC driver to the current SQLite versions 2.8.16 and 3.2.7?* {linebreak} This would also help for the integration of SQLite into OpenOffice 2: (http://dba.openoffice.org/drivers/sqlite/index.html) --- 25,39 ---- Note that this is in an experimental state and any feedback is appreciated. ! So far it has been tested with SQLite 2.8.15 and SQLite 3.0.7 on Windows NT/2000 in MS Excel 97 ! (MSQUERY) with SQLite database files created on Linux. It also runs on Linux with unixODBC 2.{0,1}.x ! and with libiodbc 3.0.6. {linebreak} {linebreak} ! I know that the developer of the SQLite ODBC Driver has no time to continue development in the next ! months because of his job.{linebreak} ! *Is there someone who could help him to update the ODBC driver to the current SQLite versions 2.8.16 ! and 3.2.7?* {linebreak} This would also help for the integration of SQLite into OpenOffice 2: (http://dba.openoffice.org/drivers/sqlite/index.html) *************** *** 40,48 **** *:sqlite3 + TCP/IP server daemon *:HTTP request, XML response *:Includes simple webserver(support WebDAV) ! *:Basic HTTP authentication *:Access control(DB, TABLE) ! *:Support prepared statement *:Extended SQL for admin 1::SHOW DATABASE 1::SHOW USER --- 49,57 ---- *:sqlite3 + TCP/IP server daemon *:HTTP request, XML response *:Includes simple webserver(support WebDAV) ! *:SSL, Basic HTTP authentication *:Access control(DB, TABLE) ! *:Support for prepared statement *:Extended SQL for admin 1::SHOW DATABASE 1::SHOW USER