Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased
On Friday, 13 March, 2020 20:14, Justin Ng wrote: >I just encountered something weird with "temp" and "sqlite_master". >I was wondering if it was another bug, or intentional. The sqlite_master table in "temp" is called "sqlite_temp_master" (temp.sqlite_temp_master) even though it responds to the spelling temp.sqlite_master as well. In either case the alias name is "sqlite_temp_master", not "sqlite_master". You can specify your own alias name which will be respected. Three level qualifiers are not recognized. That is, you cannot use .. to identify a column -- it won't work. I cannot answer why this is as it is, merely that this is indeed how it is. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased
> On Mar 14, 2020, at 03:14, Justin Ng wrote: > > This works fine, > > SELECT >x.sql > FROM >temp.sqlite_master AS x; > As is this: SELECT sql FROM temp.sqlite_master; Hmm. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased
I just encountered something weird with "temp" and "sqlite_master". I was wondering if it was another bug, or intentional. - This throws a "column not found" error, SELECT sqlite_master.sql FROM temp.sqlite_master; - This throws a "column not found" error, SELECT temp.sqlite_master.sql FROM temp.sqlite_master; - This works fine, SELECT x.sql FROM temp.sqlite_master AS x; - Referring to temp.sqlite_master columns directly in the WHERE clause also causes the error. I assume it's the same for every other part of a query. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
> On Mar 13, 2020, at 23:09, Michael Falconer > wrote: > > So I'll take the opportunity now to thank (too many to single out) the many > contributors to this list who have made it unique, and well...just a nice > place to be. So long, and thanks for all the fish :) Will miss this place. Good bye and good luck to all. Take care. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Ahthe inevitable becomes reality. I knew when this stuff surfaced a few years back that it was not going to go away, and this outcome was just a matter of time. Not a great a great shock as a life in programming has seen so much change. I don't need to Fossil, because I am one. Also a bit of a lurker who has enjoyed lurking here for years because of the excellent standard of technical replies and the interesting banter that evolves from differing technical opinions. So I'll take the opportunity now to thank (too many to single out) the many contributors to this list who have made it unique, and well...just a nice place to be. So while you are all off playing with your interface, javascript forum thingy's I guess I'll have to find somewhere else to go. You'll notice I did not mention any specific technical objections and that's because sometimes (even in I.T.) it's just not about the tech! Can't help feeling that someone just shot my dog! On Sat, 14 Mar 2020 at 07:01, Jim Dodgen wrote: > Another lurker here ... > I have always preferred mailing lists and found forums to be too fat. That > said, I like the fossil forum. It was referred to bring a "enginerish" > style which is fine given the audience > Kudos for its speed and light weight, No fluff just data. > > Jim "Jed" Dodgen > j...@dodgen.us > > > On Fri, Mar 13, 2020 at 12:24 PM Simon Slavin > wrote: > > > On 13 Mar 2020, at 6:50pm, Thomas Kurz wrote: > > > > > Why can't the forum just forward all new postings to this mailing list > > and vice versa? Then everyone could chose what to use ;) > > > > I think one of the objectives of moving away from email is to prevent > > email spam. > > ___ > > 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 > -- Regards, Michael.j.Falconer. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Another lurker here ... I have always preferred mailing lists and found forums to be too fat. That said, I like the fossil forum. It was referred to bring a "enginerish" style which is fine given the audience Kudos for its speed and light weight, No fluff just data. Jim "Jed" Dodgen j...@dodgen.us On Fri, Mar 13, 2020 at 12:24 PM Simon Slavin wrote: > On 13 Mar 2020, at 6:50pm, Thomas Kurz wrote: > > > Why can't the forum just forward all new postings to this mailing list > and vice versa? Then everyone could chose what to use ;) > > I think one of the objectives of moving away from email is to prevent > email spam. > ___ > 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
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 13 Mar 2020, at 6:50pm, Thomas Kurz wrote: > Why can't the forum just forward all new postings to this mailing list and > vice versa? Then everyone could chose what to use ;) I think one of the objectives of moving away from email is to prevent email spam. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
In a way it already does… not to the mailing list but to the email address of everyone registered on the forum. The key thing you can’t do is post via email. My personal view is there never be a solution that will please everyone. But it is Richard’s software and Richard’s game, and we have to take his word that the web-based forum is better and give it a chance. That way we can focus on solving SQLite-related problems instead of web/email/forum related problems. Fwiw, I like the new forum because of the few key differences already mentioned by Richard – editing, formatting, threading (and don’t like a few things – readability, styling – but these can be tweaked). I know many don’t like it, but that is how it is. I hope we can give the new forum a chance. > On Mar 13, 2020, at 7:50 PM, Thomas Kurz wrote: > > Why can't the forum just forward all new postings to this mailing list and > vice versa? Then everyone could chose what to use ;) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Why can't the forum just forward all new postings to this mailing list and vice versa? Then everyone could chose what to use ;) - Original Message - From: Richard Hipp To: General Discussion of SQLite Database Sent: Thursday, March 12, 2020, 21:17:59 Subject: [sqlite] New SQLite Forum established - this mailing list is deprecated I have set up an on-line forum as a replacement for this mailing list: https://sqlite.org/forum https://www.sqlite.org/forum/forumpost/a6a27d79ac Please consider subscribing to the new Forum. The intent is that the forum will eventually replace this mailing list. The Forum is powered by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. -- D. Richard Hipp d...@sqlite.org ___ 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
Re: [sqlite] sqlite-users Digest, Vol 147, Issue 13
Thank you, thank you! Balaji Ramanathan -- Forwarded message -- From: Richard Hipp To: General Discussion of SQLite Database < sqlite-users@mailinglists.sqlite.org> Cc: Bcc: Date: Thu, 12 Mar 2020 16:17:59 -0400 Subject: [sqlite] New SQLite Forum established - this mailing list is deprecated I have set up an on-line forum as a replacement for this mailing list: https://sqlite.org/forum https://www.sqlite.org/forum/forumpost/a6a27d79ac Please consider subscribing to the new Forum. The intent is that the forum will eventually replace this mailing list. The Forum is powered by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum requires Javascript?
On 3/13/20, J.B. Nicholson wrote: > > But every link in that table which would (again I assume) point to a page > with that > thread's text instead points to https://sqlite.org/forum/honeypot . Ah. That's the anti-robot defense mechanism. See https://fossil-scm.org/fossil/doc/trunk/www/antibot.wiki for details. Since the Forum does not (yet) have diffs and annotations and tarballs and all the other features of Fossil that cause mindless robots to burn CPU cycles on the server, I suppose I can disable that mechanism for the Forum, which I have now done. Please try again. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
> I’m not sure I’d agree with that. People tend to quote when replying to > mail, even if just one line, to provide context. That’s a lot less true of > the forums, especially if you’re responding to a one line question or comment > on the message right above yours. Since the forum emails only quote the new > message, there is much less context in any given message. Part of why I like > email lists is that they may be old school, but people that use them well > make sure there is very very little state in the conversation. That’s the > exact opposite with forum posts. Couldn't agree more. I am a teenager who has to go to school and attend classes regularly, and some of the days I am very, very busy. The natural quoting style ubiquitous in emails means that I can quickly scan through the message without missing much context. At the end of the day I need to be productive. On Fri, Mar 13, 2020 at 11:15 PM Jay Kreibich wrote: > > > > On Mar 13, 2020, at 10:22 AM, Richard Hipp wrote: > > > > On 3/13/20, Huỳnh Trần Khanh wrote: > >> [On a mailing nlist] I can > >> filter the posts, sort them, search through them, archive them, > >> forward them to a friend, > > > > You can do all of that with the SQLite Forum. Remember, all content > > is still delivered directly to your in-box, just like with a mailing > > list, > > I’m not sure I’d agree with that. People tend to quote when replying to > mail, even if just one line, to provide context. That’s a lot less true of > the forums, especially if you’re responding to a one line question or comment > on the message right above yours. Since the forum emails only quote the new > message, there is much less context in any given message. Part of why I like > email lists is that they may be old school, but people that use them well > make sure there is very very little state in the conversation. That’s the > exact opposite with forum posts. > > I’m not saying the forum isn’t better for the team, simply that they’re not > equal. And at the end of the day, forums must be engaged in actively (I need > to go visit it), while email is passive (it comes to me in a media I scan > regularly). For someone that is largely a lurker these days, it was easy to > just watch messages go by and jump in if needed, having most of the context > of the conversation. With a forum, the email notifications are much less > useful (and less likely to trigger the “Oh, I know that..” response), and I’m > never going to go visit the forum just to see what’s up. > > This might be better for the community, but it largely means I’m out of the > community. I’m not sure that’s a particular loss for me, or the community, > as I’ve not been very active for a decade or so. > > -j > > > ___ > 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
Re: [sqlite] New SQLite Forum requires Javascript?
Richard Hipp wrote: As far as I know, the forum only uses javascript to scroll to the most recent posting when you load a new thread. So if you don't mind scrolling manually, I think everything else will just work. Did you try it? I did try it and your description does not match my experience. Here's what I tried: I visited https://sqlite.org/forum which redirected me to https://sqlite.org/forum/forummain and there I see a list of "Most recent threads" with a table of (I assume) recent threads and text at the bottom telling me how long it took to generate that page. But every link in that table which would (again I assume) point to a page with that thread's text instead points to https://sqlite.org/forum/honeypot . Visiting https://sqlite.org/forum/honeypot returns a 1-paragraph page which says "Please enable javascript or log in to see this content". Hence I don't get to read the threads from the thread table. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 3/13/20, Philip Bennefall wrote: > Should I write to you directly, or to the Fossil forum? Either one (or both) will be fine. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
I am happy to do that, but I can't promise any kind of timeline as it will have to be in my free time only. Can't really sign well, though, as I am totally blind. But I guess we'll cross that bridge if I come up with a working audio captcha solution. I'll have a look at the Fossil captcha code this evening and write back if I have questions. Should I write to you directly, or to the Fossil forum? Thanks! Philip On 3/13/2020 5:16 PM, Richard Hipp wrote: On 3/13/20, Philip Bennefall wrote: I submitted a thread a while back offering to work on an audio captcha for Fossil, I don't recall that thread. But if you want to submit code that generates an audio file of some kind that speaks the text of a Fossil Captcha, that would be great. I will build it into the system, assuming it works, does not have onerous external dependencies, and you can get me a signed CLA. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 3/13/20, Philip Bennefall wrote: > I submitted > a thread a while back offering to work on an audio captcha for Fossil, I don't recall that thread. But if you want to submit code that generates an audio file of some kind that speaks the text of a Fossil Captcha, that would be great. I will build it into the system, assuming it works, does not have onerous external dependencies, and you can get me a signed CLA. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
> On Mar 13, 2020, at 10:22 AM, Richard Hipp wrote: > > On 3/13/20, Huỳnh Trần Khanh wrote: >> [On a mailing nlist] I can >> filter the posts, sort them, search through them, archive them, >> forward them to a friend, > > You can do all of that with the SQLite Forum. Remember, all content > is still delivered directly to your in-box, just like with a mailing > list, I’m not sure I’d agree with that. People tend to quote when replying to mail, even if just one line, to provide context. That’s a lot less true of the forums, especially if you’re responding to a one line question or comment on the message right above yours. Since the forum emails only quote the new message, there is much less context in any given message. Part of why I like email lists is that they may be old school, but people that use them well make sure there is very very little state in the conversation. That’s the exact opposite with forum posts. I’m not saying the forum isn’t better for the team, simply that they’re not equal. And at the end of the day, forums must be engaged in actively (I need to go visit it), while email is passive (it comes to me in a media I scan regularly). For someone that is largely a lurker these days, it was easy to just watch messages go by and jump in if needed, having most of the context of the conversation. With a forum, the email notifications are much less useful (and less likely to trigger the “Oh, I know that..” response), and I’m never going to go visit the forum just to see what’s up. This might be better for the community, but it largely means I’m out of the community. I’m not sure that’s a particular loss for me, or the community, as I’ve not been very active for a decade or so. -j ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
If you are comfortable doing that for any blind users who stop by, then of course that would be a quick fix. But it feels like taking a step backwards, from being able to subscribe without assistance to having to contact the author of whatever Fossil forum this applies to. I submitted a thread a while back offering to work on an audio captcha for Fossil, but cannot locate the exact post. I did not receive much response at the time, but am wondering if this would be of interest? Thanks! Kind regards, Philip Bennefall On 3/13/2020 4:53 PM, Richard Hipp wrote: On 3/13/20, Philip Bennefall wrote: Is there a solution in the pipeline for the inaccessible captcha in the forum for visually impaired users? The solution is for you to send me a private email asking for me to create your account for you, as doing that is way, way easier than trying to engineer an audible captcha. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 3/13/20, Philip Bennefall wrote: > Is there a solution in the pipeline for the inaccessible captcha in the > forum for visually impaired users? The solution is for you to send me a private email asking for me to create your account for you, as doing that is way, way easier than trying to engineer an audible captcha. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Hi Richard, Is there a solution in the pipeline for the inaccessible captcha in the forum for visually impaired users? I brought this up when the forum was first released and you kindly created an account manually for me, but it doesn't seem as though the problem was actually solved in the system itself. I just tried to create an account on the SqLite forum, but could not. The absolute majority of captcha systems offer some kind of audio version now, which is very important for me and other blind users. Kind regards, Philip Bennefall On 3/13/2020 4:22 PM, Richard Hipp wrote: On 3/13/20, Huỳnh Trần Khanh wrote: [On a mailing nlist] I can filter the posts, sort them, search through them, archive them, forward them to a friend, You can do all of that with the SQLite Forum. Remember, all content is still delivered directly to your in-box, just like with a mailing list, so anything you can do with content received from a mailing list can also be done with content from the forum. But there are many things that the forum provides that a mailing list does now. For example, if you want an archive of the forum activity, you can clone the entire history with one command: fossil clone https://sqlite.org/forum sqlite-forum.fossil Then periodically "sync" to keep your private archive up-to-date. Now you have all historical content, neatly packaged in an SQL database. You can extract and search and manage the content in this archive in any way you want. The only thing that you can do with a mailing list that the SQLite Forum does not allow is to submit new postings via email. You must use the web interface in order to post a message. In my experience, this forces people to take a little extra time to think about what they are saying, and to format and arrange their thoughts for clarity, and hence results in a better experience for the readers. There are other important features that the forum provides that mailinglists typically do not: 1. You can format your postings using Markdown 2. You can add hyperlinks to your postings that are consistently displayed and are not dependent on the idiosyncrasies of various email clients. 3. You can edit prior posts to fix typos or mistakes. 4. Your email address is never displayed, even to subscribers. 5. It is much easier to contribute anonymously to a web-based forum than it is to contribute on a mailing list. There is no verification process to go through. You just type in what you want to say and press "Submit". 6. Moderators have much better control over spam and other malicious content. The first point (use of Markdown) is the killer feature for me. There was a recent thread on this mailing list that involved people posting EXPLAIN output. That text gets hopelessly jumbled on most email readers. If those messages had been formatted with Markdown, they would have been much easier to read and understand. I've been using both this mailing list and the Forum on Fossil regularly for two years now. The forum is so much nicer that I have come to dread having to work with the legacy mailing list, at least for complex subjects. It is time for a switch to better technology. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum requires Javascript?
On 3/13/20, Warren Young wrote: >> >> Is there a way to use this without running the Javascript? > > It should be, but I lack the time right now to test it. What I can do is > point you to our documentation on how Fossil uses Javascript now: > > https://fossil-scm.org/fossil/doc/js-use-doc/www/javascript.md > > If there’s some problem that prevents you from using the forum without > JavaScript, we’ll certainly consider it a significant issue to be addressed. As far as I know, the forum only uses javascript to scroll to the most recent posting when you load a new thread. So if you don't mind scrolling manually, I think everything else will just work. Did you try it? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 3/13/20, Huỳnh Trần Khanh wrote: > [On a mailing nlist] I can > filter the posts, sort them, search through them, archive them, > forward them to a friend, You can do all of that with the SQLite Forum. Remember, all content is still delivered directly to your in-box, just like with a mailing list, so anything you can do with content received from a mailing list can also be done with content from the forum. But there are many things that the forum provides that a mailing list does now. For example, if you want an archive of the forum activity, you can clone the entire history with one command: fossil clone https://sqlite.org/forum sqlite-forum.fossil Then periodically "sync" to keep your private archive up-to-date. Now you have all historical content, neatly packaged in an SQL database. You can extract and search and manage the content in this archive in any way you want. The only thing that you can do with a mailing list that the SQLite Forum does not allow is to submit new postings via email. You must use the web interface in order to post a message. In my experience, this forces people to take a little extra time to think about what they are saying, and to format and arrange their thoughts for clarity, and hence results in a better experience for the readers. There are other important features that the forum provides that mailinglists typically do not: 1. You can format your postings using Markdown 2. You can add hyperlinks to your postings that are consistently displayed and are not dependent on the idiosyncrasies of various email clients. 3. You can edit prior posts to fix typos or mistakes. 4. Your email address is never displayed, even to subscribers. 5. It is much easier to contribute anonymously to a web-based forum than it is to contribute on a mailing list. There is no verification process to go through. You just type in what you want to say and press "Submit". 6. Moderators have much better control over spam and other malicious content. The first point (use of Markdown) is the killer feature for me. There was a recent thread on this mailing list that involved people posting EXPLAIN output. That text gets hopelessly jumbled on most email readers. If those messages had been formatted with Markdown, they would have been much easier to read and understand. I've been using both this mailing list and the Forum on Fossil regularly for two years now. The forum is so much nicer that I have come to dread having to work with the legacy mailing list, at least for complex subjects. It is time for a switch to better technology. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum requires Javascript?
On Mar 12, 2020, at 9:19 PM, J.B. Nicholson wrote: > > Richard Hipp wrote: >> The Forum is powered by Fossil. It has been in active use in the >> Fossil community for a couple of years, and has worked well. > > Is there a way to use this without running the Javascript? It should be, but I lack the time right now to test it. What I can do is point you to our documentation on how Fossil uses Javascript now: https://fossil-scm.org/fossil/doc/js-use-doc/www/javascript.md If there’s some problem that prevents you from using the forum without JavaScript, we’ll certainly consider it a significant issue to be addressed. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite forum posts are about the forum, not SQLite
That should be. Also as stated in a previous email, I want to interact with the forum via email also. I mean, I have been using web forums for a long time and I find the UX _really,_ really lacking. GitHub allows me to comment on issues by email, which is more convenient for me. On Fri, Mar 13, 2020 at 8:47 PM Dominique Devienne wrote: > > I hope that's only a temporary situation... --DD > ___ > 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
[sqlite] SQLite forum posts are about the forum, not SQLite
I hope that's only a temporary situation... --DD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
No. Web-based forums are terrible. I prefer mailing lists. I can filter the posts, sort them, search through them, archive them, forward them to a friend, The same experience **can't be replicated** on a web-based forum. Also the styling is terrible. At the very least I'd love a feature where I could subscribe to the forum and interact with the forum in the same way I would with mailing lists. On Fri, Mar 13, 2020 at 8:14 PM Jose Isaias Cabrera wrote: > > > x, on Friday, March 13, 2020 09:01 AM, wrote... > > > > * I truly hope Keith you'll continue making your tremendous contributions > > to > > the SQLite community. > > > I would say to the SQL world. > > josé > ___ > 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
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
x, on Friday, March 13, 2020 09:01 AM, wrote... > > * I truly hope Keith you'll continue making your tremendous contributions > to > the SQLite community. > I would say to the SQL world. josé ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
* I truly hope Keith you'll continue making your tremendous contributions to the SQLite community. Ditto. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Since Fossil was founded and is developed by drh as well, this step was not that unpredictable. If you compare the forum to the mailing list the only drawback I can see is that one is no longer able to contribute via mail: | Mailing list | Forum ---+--+- Web Interface | Read [0] | Read & Write Mail Interface | Read & Write | Read Like BohwaZ already suggested, this could be mitigated by making it > possible to add the ability in Fossil to handle incoming > email replies to forum posts? > > So that people wishing to use emails could still do it by subscribing > to alerts and then replying to notifications. Of course only mails by registered users should be accepted, to keep spam low. Maybe someone wants to open a feature request over at the Fossil SCM forum for this [1]. my 2 cent [0] https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/ [1] https://fossil-scm.org/forum/forum ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
As an occasional poster I like the idea of a forum as for me it's easier to dip in and follow threads (after lots of years of using System.Data.Sqlite I'm reluctantly moving over to using the Microsoft drivers because it supports EF Core). For the look and feel, it's plain but it's functional. I'm reminded of the quote from Deng Xiaoping "No matter if it is a white cat or a black cat; as long as it can catch mice, it is a good cat." Cheers, Mike On Thu, 12 Mar 2020 at 20:18, Richard Hipp wrote: > I have set up an on-line forum as a replacement for this mailing list: > > https://sqlite.org/forum > https://www.sqlite.org/forum/forumpost/a6a27d79ac > > Please consider subscribing to the new Forum. The intent is that the > forum will eventually replace this mailing list. > > The Forum is powered by Fossil. It has been in active use in the > Fossil community for a couple of years, and has worked well. See the > second link above for more information. > > -- > D. Richard Hipp > d...@sqlite.org > ___ > 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
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
> Please consider subscribing to the new Forum. The intent is that the forum > will eventually replace this mailing list. Having just had a go at subscribing, I screwed up and mistyped my email address. Is there any way for me to change it? Regards Andy Ling ** DISCLAIMER: Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On Fri, 13 Mar 2020 10:09:38 +, you wrote: >On 13 Mar 2020, at 09:35, Peter da Silva wrote: > >> What do you mean there have been "just a few threads" in the mailing list? >> I can barely keep up with it. > > As a lurker I can say that this mailing list suits just > fine. Another forum means another username/password I have > to manage. I'm mostly a lurker myself. I lurk many mailing lists, all require a username/password. One more doesn't matter much. My experience with the fossil-forum is positive, it has not changed my reading habits. I just subscribed to its email notifications, and I get everything threaded in the same way as a mailing list. > On a list, the contributions come in date order > which is easier to manage than, rather than as with a forum, > having them grouped by thread. In fact, with this list, > there's no management at all required. An advantage of > writing one's own email client is extra added features which > are just right for me: I can limit the size of a mailbox to > a certain number of mails. For the sqlite list, it's 10k > mails. More than that and the oldest get moved to the Trash > automatically. > It's all I need. With a subscription to email notifications of the sqlite-forum you can lurk in just the same way as the sqlite-users mailing list. Threaded or in date order, whatever your email client supports. Just try it, your worries will vanish soon. -- Regards, Kees Nuyt ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On Fri, Mar 13, 2020 at 1:05 AM Keith Medcalf wrote: > Uck. That is the most horrible looking thing I have ever seen in my > life. Good luck with it. > I truly hope Keith you'll continue making your tremendous contributions to the SQLite community. Things will inevitably move over to the Forum I'm afraid, but I'd rather you registered to the forum (one time setup, with email notifications) and replied on the (deprecated) ML, rather than having none your usual insightful answers because you decided to stay exclusively on the ML (or worse, if you completely gave up on both). FWIW. --DD PS: I kinda recall the prospect of switching to a forum wasn't exactly well received last time it was discussed on this ML, and especially so from "heavyweights" of this ML, it's thus disappointing Richard forced that switch on us. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On 13 Mar 2020, at 09:35, Peter da Silva wrote: > What do you mean there have been "just a few threads" in the mailing list? > I can barely keep up with it. As a lurker I can say that this mailing list suits just fine. Another forum means another username/password I have to manage. On a list, the contributions come in date order which is easier to manage than, rather than as with a forum, having them grouped by thread. In fact, with this list, there's no management at all required. An advantage of writing one's own email client is extra added features which are just right for me: I can limit the size of a mailbox to a certain number of mails. For the sqlite list, it's 10k mails. More than that and the oldest get moved to the Trash automatically. It's all I need. -- Cheers -- Tim ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum requires Javascript?
On Thu, Mar 12, 2020 at 10:32 PM Wout Mertens wrote: > Hi, > > I normally wouldn't do this on the internet, but this mailing list > goes deep. Not sure how that will go now that we have to use the > forum, but here goes. > > JavaScript makes websites much nicer to work with, by a wide margin, > especially those with lots of interaction like forums. Furthermore, it > is quite hard and expensive to make sites that work well with and > without JS. > > Nowadays even microcontrollers can run JS - there are no browsers that > can't run JS, even the text based ones. > > So IMHO, you are asking "please use time/money to achieve this state > that I prefer but that doesn't make a difference for the vast majority > of people". > > Or am I missing something? > Lynx doesn't support JS... (it's the only one I know) https://stackoverflow.com/questions/9353519/lynx-with-javascript http://elinks.or.cz/ is another text based browser (from that) a little more searching there's https://www.brow.sh/ > Wout. > > On Fri, Mar 13, 2020 at 4:19 AM J.B. Nicholson > wrote: > > > > Richard Hipp wrote: > > > The Forum is powered by Fossil. It has been in active use in the > > > Fossil community for a couple of years, and has worked well. > > > > Is there a way to use this without running the Javascript? > > ___ > > 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 > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
What do you mean there have been "just a few threads" in the mailing list? I can barely keep up with it. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
On Fri, 13 Mar 2020 at 08:15, Jens Alfke wrote: > In a messaging system, the user interface is critically important. Agree absolutely! I don't think it matters much whether the SQLite forum can render a page in > "about 0.003s" as it says in the footer. But I take issue with this -- I find latency is a critical part of a user interface, and the vast majority of websites and mobile apps I encounter just get worse and worse in this area. Granted most of that is probably not rendering time, but I find it incredibly frustrating having to wait for billions of cycles for the UI to get ready to accept my input. What's important is usability — following discussions, finding new content, > reading it, and composing messages. The forum, from my brief experience today, is really awkward. > I can't figure out what you're actually objecting to, because the information currently on the forum seems be arranged sensibly and fit the criteria of being easy to read and follow. Finding content is impossible to assess at present, although the search functionality seems broken -- which I posted about and the composition process was painless. -Rowan ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New SQLite Forum established - this mailing list is deprecated
Can we clone (push, pull, sync) the forum fossil? Ingo On 12-3-2020 21:17, Richard Hipp wrote: The Forum is powered by Fossil. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users