--- In metabase-dev@yahoogroups.com, Manuel Lemos <mlemos@a...> wrote:
Hi Manuel

I've just tested the latest CVS version and it's working great apart
from when running for the first time with a persistent connection.
PHP throws up this warning:

Warning: sqlite_close(): 244 is not a valid sqlite database resource
in c:\Dev\htdocs\public\docs\metabase\metabase_sqlite.php on line 89
And still I have to restart Apache to be able to delete the resultant
file after using a persistent connection.

I'm a bit chained to my development environment, due to other projects
I'm working on at the moment, which is PHP 5.0.5 running on Apache
1.3.3 as a module, so its hard for me to check this on different
setups presently.

>
> 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.

This is great I've seen the source and it's given me the framework to
add the functions to support renaming and column alterations for the
2.8.x library, when I get the time to implement them.

>
> 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:
>

I feel honoured by that, thank you ;)

> 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/
>