> -----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
