Re: [Phpwebsite-developers] Phatform and Postgres

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

You are correct. Both Form Generator and Photo Album will not run under
Postgresql. They are conversions of modules, not rewrites.
Unfortunately, they still retain the problems of their previous version.

We plan on rewriting both modules under 1.x in the future.

On Fri, 2007-04-13 at 12:57 -0400, Jim Wilson wrote:
> Hello,
> 
> 
> It looks like Phatform was never updated to run with Postgres.  I'm assuming this will require the following adjustments:
> 
> 1) Standardizing the SQL create statements in install.sql.
> 
> 2) Changing the columnames to be all lower case so that (for example) fieldName becomes field_name.
> 
> Am I missing something?
> 
> Regarding changes to install.sql.  Modifying all the "int(10) unsigned" or "int(1)" to default "int" looks like it'd really have no effect on the application other than maybe using a tiny bit more storage in the database.
> 
> The more significant issue is probably the wide use of the "mediumtext" type.  My understanding is the regular "text" type has a 64k limit in a mysql database.
> 
> The size of the "text" type in Postgres is essentially unlimited.  Would we be stuck here?
> 
> 
> Thanks,
> 
> Jim Wilson
> 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
-- 
Matthew McNaney
Electronic Student Services
Appalachian State University
http://phpwebsite.appstate.edu