Re: [Phpwebsite-developers] DB Issues for 1.x

[Matthew M. <ma...@tu...>]

On Mon, 2005-05-23 at 21:29 -0700, Greg Morgan wrote:
> I was answering this forum post tonight
> https://sourceforge.net/forum/message.php?msg_id=3165794, when I came
> across some of my old notes that should be taken care of in 1.x.  If the
> database issue is not resolvable, then mysql should be the only database
> offered at setup time.  The users have an expectation of multi database
> support when it isn't there, yet.

Fallout (1.x) was written with Postgres. I have stopped for a bit to
address some 0.10 compatibility issues but testing within Postgres will
begin again soon.

> Users would like to use PostgreSQL, Oracle, and I suppose MS SQL, etc.
> There are two problems that affect database portability.  One, tools
> like phpmyadmin make for helpful development environments.  However,
> when mysql exports the table, incompatible create table syntax
> statements are generated by the mysqldump command.  The link below and
> another private email message summarize the problem.

I noticed that as well. To compensate:
1) 1.x looks for db specific traits and normalizes them
2) 1.x has an export function which creates a very 'vanilla' db dump
output.


> Two, databases like PostgreSQL and Oracle limit the table name to 32
> chars as I recall.

I did not know that. Thanks for letting me know.

>   phpWebSite code and third party module code would
> have to be rewritten to use smaller table names.  Table prefixes added
> during installation and branch sites along with mod_ prefix convention
> further complicate the problem.  The concatenated prefixes make for some
> very small names when all you have to work with is 32 chars.

I am using more simple table names now. No more
"mod_modulename_whatever". I am dropping the "mod_" portion. Not a lot
of extra room but 1/8 of the total allowed char space ain't bad ;-)

Table prefixes have always been a pain to me. At some point we have to
draw the line for the inflexible user. If you are using a 10 character
table prefix on Oracle with 4 branch sites, want language translation
but do not want to compile gettext into php, etc. then we will just have
to say, "Sorry, this product is not for you."

Thanks for the feedback Greg.
Matt

-- 
Matthew McNaney
Electronic Student Services
Appalachian State University
http://phpwebsite.appstate.edu