Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

Thanks James. Points taken on board. :-) Chris On Fri, Jun 17, 2016 at 5:24 PM, James K. Lowden wrote: > On Fri, 17 Jun 2016 07:37:16 +0100 > Chris Locke wrote: > > > I fail to see what any of this has to do with sqlite. I thought this >

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

As this is a mailing list, I've not been aware of past history. I thought (albeit wrongly) that an SQLite group was about the product sqlite. Someone posted the other day about a car analogy, so this is like posting to the Ford Engine Forums, askign what air freshner to put in the car. I don't

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On Fri, 17 Jun 2016 07:37:16 +0100 Chris Locke wrote: > I fail to see what any of this has to do with sqlite. I thought this > was a mailing list for sqlite? Seeing queries (no pun intended) on > sql statements is very subjective, especially with the limited data >

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On Thu, 16 Jun 2016 20:53:25 + "Drago, William @ CSG - NARDA-MITEQ" wrote: > CREATE TABLE Apples ( > ID INTEGER PRIMARY KEY, > Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow check Color in ( 'Red', 'Green', 'Yellow' ), -- FTFY > Height REAL,

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On 2016/06/17 3:35 PM, John McKown wrote: On Fri, Jun 17, 2016 at 1:37 AM, Chris Locke wrote: I fail to see what any of this has to do with sqlite. I thought this was a mailing list for sqlite? Seeing queries (no pun intended) on sql statements is very subjective,

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of John McKown > Sent: Friday, June 17, 2016 9:35 AM > To: SQLite mailing list > Subject: Re: [sqlite] Correct, best, or generally accepted database

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On Fri, Jun 17, 2016 at 1:37 AM, Chris Locke wrote: > I fail to see what any of this has to do with sqlite. I thought this was a > mailing list for sqlite? Seeing queries (no pun intended) on sql > statements is very subjective, especially with the limited data

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of Chris Locke > Sent: Friday, June 17, 2016 2:37 AM > To: SQLite mailing list > Subject: Re: [sqlite] Correct, best, or generally accepted database

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

I fail to see what any of this has to do with sqlite. I thought this was a mailing list for sqlite? Seeing queries (no pun intended) on sql statements is very subjective, especially with the limited data provided by the original poster. Everyone will give helpful advice, but it won't stop there,

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On 16 Jun 2016, at 9:53pm, Drago, William @ CSG - NARDA-MITEQ wrote: > Should that function insert its results into a table that looks like the one > below, or is there a better way? > > CREATE TABLE Groups ( > ID INTEGER PRIMARY KEY, > AppleID1 INTEGER > AppleID2

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On 6/16/2016 4:53 PM, Drago, William @ CSG - NARDA-MITEQ wrote: Say I had a table of apples: CREATE TABLE Apples ( ID INTEGER PRIMARY KEY, Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow Height REAL, --Measured in cm Width REAL --Measured in cm Weight REAL --Measured in grams );

[sqlite] Correct, best, or generally accepted database structure for groups of things

All, Say I had a table of apples: CREATE TABLE Apples ( ID INTEGER PRIMARY KEY, Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow Height REAL, --Measured in cm Width REAL --Measured in cm Weight REAL --Measured in grams ); And say I had a function that looks at the Apples table and