Hello,

on 11/18/2005 09:12 PM jonbouyw said the following:
>> I figured that the problem is that when you change the schema of an
>> SQLite database, existing database connections are not made aware.
>>
>> The driver test script may add tables for testing auto-increment and
>> BLOBs. The connection that tests these features is not aware right away.
>>
>> The solution was to change the driver test script to close and reopen
>> the database connection after a schema change. It works now.
>
> Yes, the alternative as I understand it would be to insert a 'VACUUM'
> on the database in between, but I think it is far more efficient to
> close and re-open.

I am not sure if a VACUUM would notify the other connections. Anyway,
that is documented now in the driver notes.


>> I also added support to use composite primary keys. The way you had
>> assumed that only the auto-increment field could be a primary key.
>>
> Great stuff, I just implemented a clumsy hack just to get it working,
> I really appreciate your input on this.

No problem. I also implemented support for table renaming and column
adding. That will only work when SQLite 3 library is used with the PHP
distribution.

Anyway, I just updated the documentation adding your name and e-mail
address to the credits. Please take a look and let me know if it is ok
for you, as I am about to make a new release:

http://www.meta-language.net/metabase.html

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/