Re: how to design db

From: Bob Badour <>
Date: Mon, 08 Dec 2008 15:02:58 -0400
Message-ID: <493d6f65$0$5465$>

ilochab wrote:

> I'm using sqlite.
> I need a DB that contains:
> - a set of general tables
> - a variable number of sets of users tables.
> The first set is accessed by every-one.
> Each of the users' set 'is identical in structure to the others,
> but it is specific in content respect to the owner.
> I can manage authentication through my application.
> What I don't know how to do in a suitable way is the design of a group
> of identical tables repeated for each user.

You don't. Any design that encodes data in table names that is readily encoded in the values of the tables is a poor design.

For each set of identical tables, use a single table and use restrict to limit what data individual users can manipulate.

> Could anyone help?
> Thanks
> Ciao, Licia.
Received on Mon Dec 08 2008 - 20:02:58 CET

Original text of this message