Re: how to design db

From: rpost <>
Date: Fri, 12 Dec 2008 12:07:03 +0000 (UTC)
Message-ID: <ghtk57$2d0v$>

I just wrote:

>>select sum(energytable.calories*meal.amount)
>> from meal join energytable using (foodname)
>> where meal.username=<BoundParameter>
>>where BoundParameter is SQLite's way of putting the username into your
>>sql query.
>>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.

Received on Fri Dec 12 2008 - 13:07:03 CET

Original text of this message