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

[Dave Hall]

On Mon, 2004-11-15 at 20:25 -0600, Chris Weiss wrote:
> no ALTER TABLE at all, upgrades will need complely specialized for this.
> 

We could look at using something like: http://code.jenseng.com/db/

It could be implemented in schema proc or the sqlite db driver

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

neither does mysql - http://dev.mysql.com/doc/mysql/en/UPDATE.html

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

huh? not according to the docs -
http://www.sambar.com/syshelp/sqlite/lang.htm#insert

> 
> IF EXISTS like "DROP TABLE IF EXISTS temp;"

Not currently used.

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

That is logical anyway - the primary key should always be auto_increment
INTs

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

I don't see the need for that based on what I looked at.  I am not
saying we make sqlite the recommended db, just another choice.

For 18 it looks like we will have full support for:
* mysql
* pgsql
* mssql
* orcale
* maxDB/sap

Maybes:
* DB2
* sqlite

Defintely out:
* Progress - PoS!
* MS Access - are you on crack?
* CSV files - over my dead body ;)

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

sqlite isn't aimed at major installs - but for a 1 or 3 user install, it
should be adequate.

Cheers

Dave

> 
> 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
> > 
> >
> 
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers