RE: [sqlite] vers 3.0 concurrency issues

2004-05-06 Thread Thomas, Basil
uld not page locking at least be implemented by the pager module to increase concurrency(very naive...but better than file locking). -Original Message- From: Christian Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 9:38 AM To: Thomas, Basil Cc: [EMAIL PROTECTED] Subject: R

RE: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Thomas, Basil
I think once SQLite ver 3.0 stabilizes, all of the enhancements to the SQL language capabilities will be addressed then. Once the the file format and low level engine enhancements are in production, I am sure many of us will want more compliant SQL code similar to SQL

[sqlite] reading tables from api function call

2004-02-10 Thread Thomas, Basil
Is it possible to read a table from a api function call without executing a sql statement that returns the table as a resultset?? I would like to do a index nested loop join specifically based on info in the table that simulates the tree structure of an XML document. [EMAIL PROTECTED]