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

[Kevin <ke...@dr...>]

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
>


--=20
Kevin