Forum OpenACS Q&A: Another (hopefully last) big OpenACS 4/PG datamodel change

Thought I'd post here since I think everyone drops by this forum...

Dan Wickstrom suggested that limiting the maximum numbers of immediate
descendents of a node in our trees to 32768 would be too limiting,
particular for the acs_objects table which has a flatter topology than
I'd imagined.  He convinced me that he's right.

So I've changed the PG datamodel to use 32 bit keys (we still use one
byte for short keys).  The actual ranges are 0-127 in a short key, 128
-  2^31-1 in a long key.  That should be plenty of immediate
descendents - somewhat over two billion of them allowed per node.

This only required some code changes in postgresql.sql but does
require that you reinstall.

As mentioned in the subject line I do believe this to be the last
widescale change to the core datamodel for this release cycle.

Sorry for any inconvenience but we want to get this stuff *right*
before we issue a beta and then final release.

Don,

This does not affect the Oracle side, right?

Right.  This is PG only.  Oracle's been quite stable and will remain so...
Hi Don,

We have used OpenACS4 code pre change of tree sort keys.  Although
the sites are not very large there are some contents like news, cms,
file-storage.  We do have 1 site that has about a hundred users
already.

What would be the best way to upgrade the datamodel for this sites?

Do a pg_dump, reinstall with the new code, edit the pg_dump and
restore?

Or create custom export scripts, reinstall, use custom import
scripts?

Don, while you're giving an update on major changes, could you
also please tell us which modules are still likely to undergo
major bug fixes or modifications before first release and which
ones you are confident are mostly ready?
Answering Michael's question, I intend to work on improving the search package tonight. I'm probably going to change the datamodel and service contracts in order to accomodate new features like package-specific search, etc.
Jun - you'll have to write custom export/import sripts I'm afraid.

If the sites you have are working reasonably well, and you don't expect a huge growth in users, you might just leave them alone.  On the other hand, if you think you'll ever have to upgrade it, you're probably better off doing it ASAP.

Michael - for the most part I think packages are pretty stable.  I don't expect much change at all (I think getting Neophytos's improvements to search are important, though).  Folks at Jun's company have been working on doing some additional porting but I don't know if they'll get done in time for this release (I need to check with them soon, I guess).

Ok we will give out the custom scripts once its finished so someone else can use it.

Regarding the porting:

Rob is pretty much with news

Roel is finished with the ad_server

I am not sure about the simple survey.

Hopefully my changes on modetp will get integrated to etp and make it in the beta cycle =)