--- In metabase-dev@yahoogroups.com, Manuel Lemos <mlemos@a...> wrote:
>
> Hello,
>
> on 10/28/2005 11:54 PM jonbouyw said the following:
> > Manuel
> >
> > Hi I've been using metabase now for a few months I use it to develop
> > small apps using sqlite. I have been working with this driver
> > converted for the default php5 sqlite extension, and it has been
> > giving me reliable service and completes the driver_test.php test.
> >
> > Maybe sqlite's autoincrement feature can be included too.
> >
> > I wonder if it will be of any use to your users in the absence of
> > anything else working with PHP5 Sqlite presently.
> >
> > Thanks for the great work that you do.
>
> Great! I was going to do this soon or later but I am glad you did it as
> saves me time.
>
> The original driver was developed for a PHP SQLite extension that is no
> longer supported. So it was obsolete.
>
> Anyway, AFAIK the SQLite extension also works in PHP 4, so this driver
> has greater interest than you can imagine.
>
> I will look into this probably in two weeks and add whatever may be
> missing. Did you try it with the driver_test.php script?
>
> Thank you for you contribution. You will be credited also in the user
> documentation.
>
> --
>
> Regards,
> Manuel Lemos
>
> PHP Classes - Free ready to use OOP components written in PHP
> http://www.phpclasses.org/
>
> PHP Reviews - Reviews of PHP books and other products
> http://www.phpclasses.org/reviews/
>
> Metastorage - Data object relational mapping layer generator
> http://www.meta-language.net/metastorage.html
>
Yes I did run the conformance tests and it passes all of the tests
including NULLS.

I'm not clear on how the autoincrement works within Metabase at the
moment, but as you know SQLite will treat a primary key field of the
type INTEGER as an autoincrement field, I'm investigating how to
incorporate in the Metabase context. I would appreciate any
suggestions you have in this regard.

Also I'm looking into the manager class as I have some ALTER TABLE
functions to emulate the ALTER TABLE functions that are lacking in
SQLite which are implemented by recreating a new table with the
alterations included an then re-writing the original database. This
is slow but does provide full ALTER TABLE functionality. Again I'm
investigating how to include this within the Metabase context.

As well I expect to be able to produce a SQLite PDO driver which
shouldn't be too dissimilar to the SQLite one already provided.

Thanks for the thumbs up ;)