RE: [Phpgroupware-developers] Calendar module without entries

[Alex Borges]

schema_proc does part of the job.

Weve also built, for the new addressbook, the sql_builder framework.
Grab a snapshot at co.com.mx/~jarg/phpgroupware

The sql builder framework is an object-relational mapping system
designed by Eald, Jarg and a little bit by myself.

Its point is that you can model the relational schema as classes and
that info is/should be enough to generate lots/most of the SQL
statements you need, no matter how complex the schema is.

It comes out of the necesity to handle the extra complexity in the new
addressbook database schema and eald generalized it for use in other
apps, even outside phpgroupware.


El lun, 01-09-2003 a las 07:20, Kai Hofmann escribió:
> > -----Original Message-----
> > From: Chris Weiss [mailto:address@hidden
> > Sent: Friday, August 29, 2003 9:15 PM
> > 
> > are you talking about using stored procs?  i thought we had 
> > been over this....
> 
> No I have not - and I will never be, because stored proceedures are NOT
> compatibel between different databases.
> I am only talking about the database schema and about using it in a more
> API style way.
> 
> > Kai Hofmann (address@hidden) wrote:
> > >
> > >> I think there are other ways (better ways) to achieve it than
> > >> rewriting the db schema, but I could be wrong.
> > >
> > >I think its the best way to start at the database level,
> > >because this will move a lot of logic from the phpgw (api)
> > >to the database level which is optimized for handling data.
> > >
> > >So this will allow more cooperation and als will increase
> > >the speed and handling of the whole groupware.
> > >
> > >But thats my point.
> 
>