if I can have a primary key of t+user (which would be ideal) how can I do a search? Can I do a key partial key scan in sqlite? For instance, give me the record for user 'foo' from time 'x to y' ?
On Sat, Feb 25, 2012 at 9:03 AM, Kit <kit.sa...@gmail.com> wrote: > 2012/2/24 Rita <rmorgan...@gmail.com>: > > I was wondering if there is a better way to normalize this data. And > also, > > I will be doing queries like, what is the most recent price for the > > user,mson, and what is the average price for mson in the last 3 days, > etc... > > Your table is already normalized. The primary key is t+user, attribute > price is dependent on the entire primary key. No dependency between > attributes or between parts of the primary key. > > However, a problem might occur if the user at the same time wants to > make 2 records. > -- > Kit > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --- Get your facts first, then you can distort them as you please.-- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
