Slashcode

I have a need for a site that will support both short time articles and documents that have a very long life (on the order of over 5 years).

Before re-inventing this I wanted to ask if there was a plugin or something that allowed me to have a storage area for documents that have a very long life. For example policies and procedures.

I would like to have a index page for these items generated automaticly and also be able to announce them in a regular story.

For a real example one thing I would like to be able to do is to post scores from a weekly match (USPSA) and have an index page that will show each weeks history. In addition a story would be posted with a link to that weeks scores. Another use would be to have a series of "white papers" that are avaiable from an index page and are also announced in a story.

I've just managed to get slash 2.2.6 installed with mySQL 4.0.12 and apache 1.3.27 on a Debian system (local network.) Things appear to be working except that slash doesn't seem to be disconnecting from mySQL after serving up a page - each page eats a new mySQL thread which remains sleeping until enough threads are created such that I run out of memeory (128M.) Is this normal for slash, unique to mySQL 4.0 or debian, or am I just lucky?

I'm still running Slash 1, but currently converting to Slash 2, albeit slowly. For some reason RSS/RDF feeds are generated only onec a hour. My question is: Is it possible to force slash1 generate RDF more frequently and if it's configurable in slash2? For some reason I haven't found RDF generation interval in configuration files.

I'm managing the technical aspects of a growing private community. I have noticed that the vast majority of my users are not very participatory. We have a core group of about 80-150 active users (posters/commenters/journals/etc), and 400-900 lurkers on any given day. Due to various email invites, our user base is now over 10k users. My site is invitation only, and there are no anonymous users. Thus, I can definitely identify all of my users.

My questions for the slashcode community are these:

1. How many unique users does your slashsite get in a day as compared with the total number of users that you have?
2. Is it typical to have only 6% of your user base active and less than 1% of them regularly interactive?

FYI, my calculations for these figures come from the accesslog as:
select count(distinct uid), dayofyear(ts) as day from accesslog group by day;

For sites that allow anonymous users, the following would return (kinda) similar results:
select count(distinct host_addr), dayofyear(ts) as day from accesslog group by day;

Keep in mind that the type="op" is the syntax that is saved. Most have multiple forms. Also keep in mind that to use links you need to have Slash::Relocate installed and Slash::Blob. For image and file uploads all you need is Slash::Blob.
Read one for the entire list: