[Phpwebsite-developers] Phatform and Postgres

[Jim W. <spi...@us...>]

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