Re: how to design db
Date: Wed, 10 Dec 2008 15:09:16 GMT
> ilochab schrieb:
>> 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.
> Bob is right, that's not the way to do it. Instead, you have one table, > with the user id in one column as part of the key. Then you can have > views that add a "where user = getusername()" or something to your > queries and instead-of triggers for DML. If it's not a cellphone, I'd > suggest you consider a bigger database system like mysql, or sqlserver > express. > > Lots of Greetings! > Volker
You are both really rigth (of course), but let me specify a little more
My DB is not big, and the application is not a production one (it's just
a diet journal http://dieta.sw.googlepages.com/).
It's a GUI application that can be run by multiple user, but only one at
My DB is not big, and the application is not a production one (it's just a diet journal http://dieta.sw.googlepages.com/). It's a GUI application that can be run by multiple user, but only one at a time.
I understand quite well that if, for any reason, the two data stuctures do not evolve together they become unusefull. This is why I asked for help.
I thank you for the answer and I wait for a followup.
Licia Received on Wed Dec 10 2008 - 16:09:16 CET