_Stack Overflow_ is a little like this list, and Joel Spolsky, CEO of _Stack Overflow_, considers what makes an acceptable question for _Stack Overflow_ here:
<https://www.joelonsoftware.com/2018/04/23/strange-and-maddening-rules/> Just for fun I'm listing ten common types of question I see here. I've messed with them a little to give the essence without poking fun at any specific individual. 1) I've found a bug in SQLite and here is my SQL which triggers it. The code posted has syntax errors so will not actually run. Enough syntax errors that it's not obvious what it's meant to be. 2) I've created one index for each column in each table of my database. I now have 74 indexes. Yet my SELECT still runs slowly. Why ? (Poster hasn't noticed that each INSERT now takes a lifetime and database filesize is huge.) 3) Here is my problem, which obviously requires procedural programming or at least scripting and can't be done entirely within SQL. How can I solve my problem ? PS: I only know Excel macros so please do it in Excel. 4) Do my CS205 homework for me. Bonus points if the question is obviously taken directly from a Computer Science textbook. 5) I've accepted a programming job involving data. The web pages say that SQLite handles data. How do I use SQLite to my job ? My poorly-conceived database design, with single-letter entity names which I didn't explain and will forget in a month, is attached to this post. Followed-up 24 hours later with "bump". 6) Polite question on an ambiguity in SQLite documentation, clearly phrased and illustrated with neat comparisons with MS Server and MySQL. Poster is concerned that future versions of SQLite might interpret the point differently and wants assurance that the developer team understands the ambiguity and has intentionally picked the way SQLite does it. Bonus points if OP is Chinese and writes better English than English people do. 7) Well-phrased and clear question by someone making a bad assumption about SQL, for example that SELECT without ORDER BY should return rows in the order in which they were inserted. 8) Reasonable question about a tricky aspect of SQL, e.g. an obscure interaction between triggers and foreign keys, which is answered in the SQLite documentation but only if you find the right section of the right web page. (9) Reasonable question about SQL which is answered by all the following: (A) The obvious page in the documentation (B) the SQLite FAQ (C) The top three answers on Google (D) the top three answers when searching _Stack Overflow_. (10) Question about SQLite's file handle management which could concern only someone writing C code which accesses SQLite internals. Can be answered only by someone who understands SQLite's conventions and source code very well, i.e. a member of the development team. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
