Re: [Fofredux-devel] Re: FoFRedux mailing list

[Andrew T. <ajt...@hi...>]

I'll have a look at it tonight. I think supporting other databases is
perhaps a good idea - though I'm concerned about the expense to
readability of the code. I think a huge benefit to FoFRedux is the
simplicity and understability of the code for users and hackers (like
ourselves) to modify.

Are there directions on setting up another db?

In related news - I finished most of the baseline mods last night -
just need to add "Search" into the fofredux code from my personal
modified fof.

Andy

On 11/16/05, Kevin <ke...@dr...> wrote:
>
> Here's a link to my work.  Please have a look and let me know if you guys
> think this is a good direction to go in.
>
> http://www.drule.org/fofredux-adodb.tar.gz
>
> >
> > Hi, I've been working on cleaning up the database code and making it mo=
re
> > easily portable to other RDBMSs.
> >
> > I started by converting it to use PEAR_DB.   Athough I eliminated all t=
he
> > "mysql_" function calls, the queries and table structure is still very
> > mysql specific.
> >
> > A couple of days ago I scraped my PEAR_DB work and started working with
> > ADODB.  I am *very* pleased with the results so far.  I have it working
> > fairly well on both mysql and postgresql.
> >
> > One of the nice features of ADODB is its support for handling database
> > metadata an abstract (non-dbms specific) way.
> >
> > http://phplens.com/lens/adodb/docs-datadict.htm
> >
> > By using the $dict->ChangeTableSQL() method,  It will either: create th=
e
> > table if it is missing, or alter the table to match the definition
> > provided.
> >
> > This will make upgrading the database on an existing FoF/FoFR installat=
ion
> > quite easy.
> >
> > ---
> > Kevin
> >
> >
> >> From: Benjamin Stewart <bsii@cr...>
> >
> >>
> >> One thing we need to come up with a solution for is how to handle
> > changes
> >> that require database changes.  We need ways of knowing which features
> > require which database changes, so we know whether or not any given
> > database
> >> change needs to be included in an updater.  This, by the way, is one o=
f
> > the
> >> biggest problems I've never been able to solve really well in past
> > lives.
> >>
> >> --Benjy
> >
> > --
> > Kevin
> >
> >
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_idv28&alloc_id=16845&op=3Dclick
> > _______________________________________________
> > Fofredux-devel mailing list
> > Fof...@li...
> > https://lists.sourceforge.net/lists/listinfo/fofredux-devel
> >
>
>
> --
> Kevin
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_idv28&alloc_id=16845&opclick
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>


--
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA
idealistic technocrat

Photos - http://flickr.com/photos/ajturner
Travel   - http://highearthorbit.com/projects/location/