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 mind off-topic posts either, but the generic post about 'how do I write this sql?' was extremely basic. Half the group will spin off about third normal forms... Ooh yes, I'll be back! I've a very 'basic' knowledge of SQL, so am picking up bits from the odd post here and there. I craft a lot of databases in vb.net but as my needs are small, sqlite eats this up for breakfast... I'm tempted to set up a beginners SQL forum though... a 'getting started' guide together with a 'how the &%$£ do I do this?' section... I prefer forums to email lists... don't feel so 'spammmy' and noisy... Thanks, Chris On Fri, Jun 17, 2016 at 3:16 PM, Drago, William @ CSG - NARDA-MITEQ < william.dr...@l-3com.com> wrote: > > -----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 > structure > > for groups of things > > > > On Fri, Jun 17, 2016 at 1:37 AM, Chris Locke <ch...@chrisjlocke.co.uk> > > 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 > > > provided by the original poster. > > > Everyone will give helpful advice, but it won't stop there, and as > > > soon as the original poster has another query (no pun intended) which > > > would result in a schema change, this would have to be explained, etc. > > > > > > A specific group on SQL is required. > > > > > > > Perhaps so. But such a group would run into problems because it would > be a > > case of "whose SQL?" The four "big" ones that I know of are: SQLite, > > PostgreSQL, Oracle, and IBM's DB2. The basics are the same, but each has > > their own peculiarities. I don't know what the intent of this forum > really is. It > > is only for SQLite related "perculiarities"? Or does it include > something like > > the OP's question which is basically "how do I do a SQLite query to get > this > > information?" I don't really know. I also monitor the PostgreSQL forums > and > > see this "how do I craft an SQL query to ...?" type question quite > often. What > > is weird to me, is that someone will post such a question on the _bugs_ > > forums, phrasing it as "I did this SQL query and it didn't do what I > expected. > > Please fix your product to make it work." And the reason it didn't work > was > > because the SQL query is garbage. Ah, the ever requested "do what I need, > > not what I said" fix. > > > > I don't know what the actual rules are for this group either. Almost any > database related topic seems to be tolerated if not enthusiastically > embraced. > Chris Locke has only been active here since May of this year (and maybe he > won't be back now that his problem is solved), so maybe he's unaware of > some of (off) topics that have made the rounds. In any case maybe he has a > good point in keeping the mailing list strictly on topic. I personally > don't mind the occasional detour into other realms, especially on a low > activity group like this one, and I usually learn a thing or two along the > way as well, but that is just my opinion. > > -Bill > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any > attachments are solely for the use of the addressee and may contain > information that is privileged or confidential. Any disclosure, use or > distribution of the information contained herein is prohibited. In the > event this e-mail contains technical data within the definition of the > International Traffic in Arms Regulations or Export Administration > Regulations, it is subject to the export control laws of the > U.S.Government. The recipient should check this e-mail and any attachments > for the presence of viruses as L-3 does not accept any liability associated > with the transmission of this e-mail. If you have received this > communication in error, please notify the sender by reply e-mail and > immediately delete this message and any attachments. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users