[sqlite] convert zip to sqlar file

2020-04-15 Thread Peng Yu
Hi, I'd like to convert zip files to sqlar files. Is there a command line tool that I can help with the conversion? Thanks. -- Regards, Peng ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

[sqlite] Troubleshooting corrupt indexes

2020-04-15 Thread Jens Alfke
something as simple as the `seq` index could go awry… —Jens [doggedly denying the existence of the new forum] PS: We're using SQLite 3.28, statically linked into the app, on Android. ___ sqlite-users mailing list sqlite-users@mailingl

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Richard Hipp
On 3/24/20, Luuk wrote: > "The mailing list is deprecated. You need to go to > https://sqlite.org/forum/ for the sqlite forum." > > Can anyone give the source of this? https://www.sqlite.org/support.html https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Hick Gunter
the company VPN from home" in between. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Luuk Gesendet: Dienstag, 24. März 2020 09:26 An: sqlite-users@mailinglists.sqlite.org Betreff: Re: [sqlite] The mailing list is deprec

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Luuk
OK i must have must the posts from the 12th of March till the end of that week , being busy with other things. On 24-3-2020 09:19, Hick Gunter wrote: See announcement on the mailing list dated march 12th -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Hick Gunter
See announcement on the mailing list dated march 12th -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Richard Hipp Gesendet: Donnerstag, 12. März 2020 21:18 An: General Discussion of SQLite Database Betreff: [EXTERNAL

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Petite Abeille
> On Mar 24, 2020, at 09:13, Luuk wrote: > > No, i do NOT mean the source of the forum, but the source for "The list is > deprecated" http://sqlite.1065341.n5.nabble.com/New-SQLite-Forum-established-this-mailing-list-is-deprecated-td111358.html But that's just

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Norman Dunbar
: "The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum." Can anyone give the source of this? No, i do NOT mean the source of the forum, but the source for "The list is deprecated" ____

Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Luuk
On 24-3-2020 09:04, Luuk wrote: "The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum." Can anyone give the source of this? No, i do NOT mean the source of the forum, but the source for "The list

[sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

2020-03-24 Thread Luuk
"The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum." Can anyone give the source of this? On 23-3-2020 14:35, Hick Gunter wrote: The mailing list is deprecated. You need to go tohttps://sqlite.org/forum/ for the sq

Re: [sqlite] [EXTERNAL] No such column error

2020-03-23 Thread Hick Gunter
The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum. Can you replicate the problem while using the sqlite shell? Are you checking column names returned from the second statement? Note that a.BIRTH.YYY from your example looks a bit weird

[sqlite] No such column error

2020-03-23 Thread Aydin Ozgur Yagmur
as SQLITE_OK. Do you have any idea what is going on? Thank you very much in advance, _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Use of same aliases in single query

2020-03-23 Thread Rob Golsteijn
Hi list, Accidentally I discovered that I could use the same table aliases for 2 tables in a single sql statement. As long as I do not use a column name that exists in both tables Sqlite accepts this. It looks strange to me that I can use the same aliases multiple times, and that they co-exist

Re: [sqlite] Fwd: [sqlite-forum] Convert datetime string to second since Epoch with millisecond precision

2020-03-17 Thread Keith Medcalf
select (strftime('%J', '2016-06-13T09:36:34.123Z') - 2440587.5) * 86400.0; 1465810594.123 -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Dominique

[sqlite] Fwd: [sqlite-forum] Convert datetime string to second since Epoch with millisecond precision

2020-03-17 Thread Dominique Devienne
Reposting to the ML, maybe I'll have more luck there, than in the forum? --DD -- Forwarded message - From: ddevienne Date: Tue, Mar 17, 2020 at 5:09 PM Subject: [sqlite-forum] Convert datetime string to second since Epoch with millisecond precision To: Forum post by ddevienne

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

2020-03-16 Thread Domingo Alvarez Duarte
several new connections and even professional opportunities. I value those relationships. I'm sorry this forum will cease to be a place where new ones will develop. --jkl ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

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

2020-03-16 Thread James K. Lowden
ase to be a place where new ones will develop. --jkl ___ 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-15 Thread Jens Alfke
little affordances and edge cases like this. It’s not the sort of thing one blithely wades into. That’s part of the reason I gave for leaving forum software implementation to the experts, or at least to those who’ve had years to fix these kinds of mistakes. —Jens ____

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-15 Thread J.B. Nicholson
Richard Hipp wrote: Please try again. Thanks, this change allows me to read the articles. ___ 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-15 Thread nomad
On Fri Mar 13, 2020 at 11:22:46AM -0400, 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 S

Re: [sqlite] REMOVE ME

2020-03-14 Thread Jose Isaias Cabrera
Click at the link at the bottom of the email... From: sqlite-users on behalf of Edmondo Borasio Sent: Saturday, March 14, 2020 03:34 AM To: SQLite mailing list Subject: [sqlite] REMOVE ME ___ sqlite-users mailing

[sqlite] REMOVE ME

2020-03-14 Thread Edmondo Borasio
___ 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

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

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

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

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

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

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

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

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

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

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

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 mailin

Re: [sqlite] New SQLite Forum requires Javascript?

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

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

Re: [sqlite] New SQLite Forum requires Javascript?

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

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 h

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

2020-03-13 Thread Philip Bennefall
. ___ 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 Richard Hipp
at. 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.or

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 SQL

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

2020-03-13 Thread Philip Bennefall
. ___ 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 Richard Hipp
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

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

Re: [sqlite] New SQLite Forum requires Javascript?

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

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,

Re: [sqlite] New SQLite Forum requires Javascript?

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

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

[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
mendous contributions > > to > > the SQLite community. > > > I would say to the SQL world. > > josé > _______ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://m

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 li

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

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

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

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

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

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

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

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

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

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

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread J Decker
> > > 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? > > ___ > &g

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 wit

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 http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

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

2020-03-12 Thread Wout Mertens
's prowess, and while the interface is decidedly engineerish, it's very usable. I look forward to seeing it in action! _______ 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-12 Thread Wout Mertens
t; Good luck with it. > > > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > >-Original Message- > >From: sqlite-users On > >Behalf Of Richard Hipp > >Sent: Thursday, 12 March, 2020 15:29 &g

Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-12 Thread Wout Mertens
f 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] New SQLite Forum requires Javascript?

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

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

2020-03-12 Thread Stephen Chrzanowski
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@ma

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

2020-03-12 Thread Warren Young
On Mar 12, 2020, at 6:15 PM, Jens Alfke wrote: > > I strongly disagree with your using a homemade forum rather than something > like Discourse. Unlike SQLite proper, the Fossil project accepts outside contributions without a whole lot of gatekeeping. I myself have made a few imp

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

2020-03-12 Thread J. King
preciate that you like to 'eat your own dog food'. However, I >strongly disagree with your using a homemade forum rather than >something like Discourse. I will never be able to understand how anyone could hold up Discourse as superior to, well, anything. It's slow, it has poor UI feedback,

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

2020-03-12 Thread J. King
J. King _______ 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-12 Thread Jens Alfke
memade forum rather than something like Discourse. In a messaging system, the user interface is critically important. 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. What's important is usability — following discussion

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

2020-03-12 Thread Petite Abeille
> On Mar 13, 2020, at 01:04, Keith Medcalf wrote: > > Uck. That is the most horrible looking thing I have ever seen in my life. > Good luck with it. If only this was confine to the esthetics. But yes, horrible sums it up. ___

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

2020-03-12 Thread Petite Abeille
erience. Unsubscribed. To each their own I guess. _______ 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-12 Thread Keith Medcalf
Uck. That is the most horrible looking thing I have ever seen in my life. Good luck with it. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Ric

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

2020-03-12 Thread BohwaZ
. It would be a perfect solution for my use of Fossil as well. Would that feature would be accepted in Fossil if someone (probably not me, I lack the time right now sorry) would submit a patch? Cheers. ___ sqlite-users mailing list sqlite-users

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

2020-03-12 Thread Domingo Alvarez Duarte
community for a couple of years, and has worked well. See the second link above for more information. ___ 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-12 Thread Petite Abeille
> On Mar 12, 2020, at 21:17, Richard Hipp wrote: > > a replacement for this mailing list: Tragic. Oh well. Anyhow, thanks for SQLite itself :) _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.or

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

2020-03-12 Thread Warren Young
tarted the forum, despite all the complaints leading up to the move. Meanwhile, the forum is just as busy as the old mailing list was, maybe more so. This SQLite mailing list has a higher posting rate than the Fossil Forum, but it probably also a greater percentage of “just plain users” than for F

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

2020-03-12 Thread Richard Hipp
On 3/12/20, no...@null.net wrote: > I am wondering what (apparently invisible) > anti-spam features are present. I will be happy to discuss that, and any other questions you have, on the Forum. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite

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

2020-03-12 Thread nomad
s anonymous. -- Mark Lawrence _______ 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-12 Thread Scott Robison
They can subscribe to the forum too. :) On Thu, Mar 12, 2020, 2:40 PM Simon Slavin wrote: > Well, that'll annoy the nabble people. And I can live with that. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlit

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

2020-03-12 Thread Simon Slavin
Well, that'll annoy the nabble people. And I can live with that. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

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

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Keith Medcalf
erministic but "datetime('now', '+1 day')" is not even though they all have the same result. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. ___ sqlite-users maili

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Richard Hipp
ransaction0 0 1 0 01 usesStmtJournal=0 24Goto 0 1 000 -- D. Richard Hipp d...@sqlite.org _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlit

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Doug
(a, abs(0), abs(1), abs(2)) FROM t1; Just curious... Doug > -Original Message- > From: sqlite-users > On Behalf Of Richard Hipp > Sent: Thursday, March 12, 2020 7:41 AM > To: SQLite mailing list > Subject: Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short- > circui

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread David Raymond
ssing For Date/Time Functions The built-in date and time functions of SQLite are a special case. These functions are usually considered deterministic. However, if these functions use the string "now" as the date, or if they use the localtime modifier or the utc modifier, then they are

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Keith Medcalf
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] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Simon Slavin
https://sqlite.org/pragma.html#pragma_recursive_triggers> _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread David Raymond
1 OR NEW.Field2 is not OLD.Field2 OR ... --Think you want to exclude LastUpdate from this OR'd list of changed fields to check ) _______ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Ling, Andy
UPDATE ON recursively? >Perhaps a pragma or inSQLite are triggers non-recursive by default? It looks like this answers your question... https://stackoverflow.com/questions/21223434/do-sqlite-triggers-trigger-other-triggers Andy Ling *

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread David Blake
n to avoid infinite calls, but maybe I am fooling myself. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Richard Hipp
instructions 13 and 14 and omits the abs() function. The abs() function is now computed on instructions 7 and 8, but those instructions only run one time due to the "Once" opcode on instruction 6. -- D. Richard Hipp d...@sqlite.org ___ sq

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Doug
Richard, what does the explain look like with your code change, please. Doug > -Original Message- > From: sqlite-users > On Behalf Of Richard Hipp > Sent: Thursday, March 12, 2020 3:09 AM > To: SQLite mailing list > Subject: Re: [sqlite] [EXTERNAL] Re: COALESC

Re: [sqlite] Corrupted FTS5 index? disk image is malformed - Part II

2020-03-12 Thread OrenKishon
ce rowids change, the references between the fts table to the content table are broken. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Richard Hipp
On 3/12/20, Hick Gunter wrote: > Exactly what I gained from the EXPLAIN output. > > The SQL "compiler" is extracting the constant expression ABS(...) and > evaluating it in the program prolog (where schema is checked and locks > taken). See instructions 11 and 12 Exactly

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Ling, Andy
ne. 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. ____

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Jean-Luc Hainaut
UPDATE ON My_table FOR EACH ROW WHEN NEW.lastupdated < OLD. lastupdated BEGIN UPDATE song SET lastupdated = DATETIME('now') WHERE id = NEW.id END As far as I know, updating the current row in a "before" trigger is a "nop" in SQLite since this row doe

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread David Blake
I try defining a trigger this way this >> > in my favorite db dbrowser. >> >> Thank you very much for keeping the error message secret. >> >> When I fix the wrong table table name and add the missing semicolon after >> the UPDATE statement, this trigger works

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread David Blake
ead of <. > > > However I get SQL errors when I try defining a trigger this way this > > in my favorite db dbrowser. > > Thank you very much for keeping the error message secret. > > When I fix the wrong table table name and add the missing semicolon after > the UPDATE stateme

Re: [sqlite] Maintaing a Last updated timestamp column using triggers

2020-03-12 Thread Clemens Ladisch
owser. Thank you very much for keeping the error message secret. When I fix the wrong table table name and add the missing semicolon after the UPDATE statement, this trigger works fine. Regards, Clemens _______ sqlite-users mailing list sq

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-12 Thread Hick Gunter
icht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Jay Kreibich Gesendet: Mittwoch, 11. März 2020 20:53 An: SQLite mailing list Cc: 38866424f8f6fc429174ff1ab2355...@mail.dessus.com Betreff: [EXTERNAL] Re: [sqlite] COALESCE() does not short-circuit sometim

  1   2   3   4   5   6   7   8   9   10   >