Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Keith Medcalf
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

Re: [sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Petite Abeille
> 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] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Justin Ng
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Petite Abeille
> 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.

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Michael Falconer
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Jim Dodgen
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Simon Slavin
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.

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread P Kishor
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Thomas Kurz
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

Re: [sqlite] sqlite-users Digest, Vol 147, Issue 13

2020-03-13 Thread Balaji Ramanathan
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

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread Richard Hipp
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Huỳnh Trần Khanh
> 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

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread J.B. Nicholson
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Richard Hipp
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Philip Bennefall
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Richard Hipp
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Jay Kreibich
> 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 >

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Philip Bennefall
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Richard Hipp
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Philip Bennefall
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

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread Richard Hipp
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: > >

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Richard Hipp
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

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread Warren Young
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

Re: [sqlite] SQLite forum posts are about the forum, not SQLite

2020-03-13 Thread Huỳnh Trần Khanh
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,

[sqlite] SQLite forum posts are about the forum, not SQLite

2020-03-13 Thread Dominique Devienne
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

2020-03-13 Thread Huỳnh Trần Khanh
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Jose Isaias Cabrera
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread x
* 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

2020-03-13 Thread dirdi
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Mike King
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.

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Ling, Andy
> 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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Kees Nuyt
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Dominique Devienne
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Tim Streater
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,

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread J Decker
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, >

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread Peter da Silva
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

2020-03-13 Thread Rowan Worth
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

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

2020-03-13 Thread ingo
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