On Fri, Sep 26, 2008 at 12:46 AM, Joey K. <pguser@gmail.com> wrote:
After reading all your requirements, I have a question, will you be
hosting the app yourself, or will your customers be hosting it? If
you are, then the security issues you bring up are inconsequential, as
it will be code you control the accesses the db.
Oracle most certainly supports schemas. Most modern DBs do. Only one
I can think of that doesn't is MySQL.
Text in pgsql is automagically compressed if it's large enough (> 4k
or so) with an algorithm that is fast but will compress down fairly
well.
Using multiple databases means that any connection pooling will have
to have separate pools to each database, greatly increasing the number
of open connections. Schemas can do pretty much what multiple
databases can do in pgsql.