Phatform and Postgres

[Jim Wilson]

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
Phpwebsite-developers@...
https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

[Matthew McNaney]

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
> Phpwebsite-developers@...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

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


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Phpwebsite-developers mailing list
Phpwebsite-developers@...
https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers