Re: how to design db
Date: Fri, 12 Dec 2008 12:07:03 +0000 (UTC)
I just wrote:
>> from meal join energytable using (foodname)
>> where meal.username=<BoundParameter>
>>where BoundParameter is SQLite's way of putting the username into your
>>For inserts it becomes just another value to enter and for update/delete
>>it goes into the where clause.
>This (the ability to run queries on combined shared and non-shared data)
>is a big advantage of both Bob's/Volker's and 'my' approach.
Of course you're trying to allow this by adding per-user tables to the database, but that only has drawbacks compared to B's/V's approach.
-- ReinierReceived on Fri Dec 12 2008 - 13:07:03 CET