Good to hear that OpenACS is of use! Remember to link your
site when it's up and running if you go with OpenACS!
(1) Postgres is not as scalable or reliable as Oracle. Although, I
have a friend who tells me that his Oracle 8i database crashes
(whole thing core dumps) consistently on a particular piece of
SQLJ, so who knows where Oracle is going by adding more
bloat to their core server. Regardless, Postgres should be able
to support a moderately popular site with reasonable hardware.
We're not talking yahoo.com, but certainly a site that takes a
couple million hits a day (again, given the right hardware).
(2) OpenACS has every plan of maintaining Postgres support for
the foreseeable future. We may attempt to separate out the SQL
well enough that we can also offer Interbase compatibility, but I
don't see us switching altogether.
We encourage you to use OpenACS! We don't have any huge
sites currently running it, but the technology is solid. Our biggest
site so far is http://community.aolserver.com
