Re: Number of tables

[Mike Ivanov <mikei(at)activestate(dot)com>]

Greg Stark wrote:
> You may
> not expect to be need to run queries which combine multiple users'
> data now but you will eventually.
>   

We store cross-user data in a separate schema, which solves all *our* 
problems.

> This doesn't work so great when each user is going to be specifying
> their own custom schema on the fly 

This works fine, at least we didn't encounter any issues with that.

> but that's not really what
> relational databases were designed for. 

Sometimes you have to.. you know, unusual things to meet some specific 
requirements, like independent user schemas. It's not a conventional web 
app we run :-)

I'm not arguing this is a bit extremal approach, but if one is forced to 
go this path, it's quite walkable ;-)

Mike