*** 162,164 **** --- 162,179 ---- </HTML> 30.04.2004 / e + ----- + OK. I have looked at TDS. Seems to be a rather complex thing. I also examined the SQLite code. In SQLite the sqlite_exec method uses the VM API. The sqlite_get_table uses sqlite_exec and several xxx_printf routines uses either sqlite_exec or sqlite_get_table. So making VM API network capable, we can than take code from sqlite itself to make other routines network capable. + + The VM API could be extended to return multiple rows in one turn, instead of calling the _step method once for each row. This would improve performance for + long queries. + + Other restriction are custom functions. It would be rather slow to establish a connection every time, function is called by sqlite. This functions have to + be installed on the server. + + The authorization can be done through the sqlite_open method. Instead of file name we pass kind of URL e.g. "user:passwort@192.168.0.1:5000/mydatabase". + + The specified database must contain table with users and their passwords. (Suggested table name : sqlite_users). Of course the server have to restrict every access to this table. + + 03.05.2004 / Alex K. + ----
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|