Re: [Phpgroupware-developers] Support for SQLite/php5

[Chris Weiss]

no ALTER TABLE at all, upgrades will need complely specialized for this.

no UPDATE...FROM, I don't know if we use this, can be usefull for upgrades

INSERTs leaving cols out so that get defaults values doesn't work

IF EXISTS like "DROP TABLE IF EXISTS temp;"

auto_increment only work if the col is an int and is primary key

Since we've takin an "all SQL is equal" aproach, some of these in
certain cases will cause some odd workarounds to have to be
implemented.

most apps won't be a problem, some will be impossible without an
"if(is_sqllite()" type hack... or kill performance alltogether.

On Tue, 16 Nov 2004 12:18:10 +1100, Dave Hall
<address@hidden> wrote:
> On Mon, 2004-11-15 at 19:00 -0600, Chris Weiss wrote:
> 
> 
> > On Tue, 16 Nov 2004 11:51:09 +1100, Dave Hall
> > <address@hidden> wrote:
> > > SQLite yes - if someone writes a driver :)
> >
> > which could be very difficult due it's very minimal support for SQL 
> > standards.
> 
> Looks ok compared to pgsql or mssql - http://www.sqlite.org/lang.html
> 
> 
> 
> >
> >
> > _______________________________________________
> > Phpgroupware-developers mailing list
> > address@hidden
> > http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
> 
>