[sqlite] convert zip to sqlar file

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

[sqlite] Troubleshooting corrupt indexes

We've found a few database instances with index corruption, and I'm unsure how to troubleshoot it. The symptom is SELECT queries failing with SQLITE_CORRUPT. I've looked at the database files, and `pragma integrity_check` spits out five "row missing from index" errors on one index, and "wrong

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

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/msg119468.html --

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

Weren't we all... When I requested working from home office on march 10th, the company went from "No, we can't do that until it is mandated by the law" to "Come to the office only if you can't work from home" in a matter of days. With "Please verify if you can access the company VPN from home"

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

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

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

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]

> 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 DRH. The mailing list is

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

It originally came from Dr Richard Hipp. It's official. HTH Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 On 24/03/2020 08:13, Luuk wrote: On 24-3-2020 09:04, Luuk wrote:

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

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 is deprecated"

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

"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 sqlite forum.

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

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

[sqlite] No such column error

I have been developing a c++ program in windows. In this program, in a loop, I open database, query and update the records then close it. I am encountering randomly with "No such column error". Query looks like that (but there are more columns than this STATUS table): "select a.BIRTH_DATE,

[sqlite] Use of same aliases in single query

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

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

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 Devienne

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

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

Hello James ! Definitely you've made a very good point ! Thumbs up ! Cheers ! On 16/3/20 17:37, James K. Lowden wrote: On Fri, 13 Mar 2020 11:22:46 -0400 Richard Hipp wrote: 4. Your email address is never displayed, even to subscribers. While I have no illusions of altering the online

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

On Fri, 13 Mar 2020 11:22:46 -0400 Richard Hipp wrote: > 4. Your email address is never displayed, even to subscribers. While I have no illusions of altering the online trajectory of this ML, I'd like to point out that email addresses foster community. Studies and experience both show that

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

> On Mar 15, 2020, at 4:54 AM, no...@null.net wrote: > > By chance or by design most emails to this list, like yours above, came > wrapped at a length suitable for text-based readers. Yet every message > I've received from the forum is a shocking cut-words-in-half affair in > my terminal.

Re: [sqlite] New SQLite Forum requires Javascript?

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

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 SQLite Forum. Remember, all

Re: [sqlite] REMOVE ME

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

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

> 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

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

> 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

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

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

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

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

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

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?

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

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

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

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

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

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

> 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

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

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

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?

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

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?

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

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

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

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

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

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.

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

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

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

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,

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

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

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

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

On Fri, Mar 13, 2020 at 1:15 AM Jens Alfke wrote: > > > On Mar 12, 2020, at 1:17 PM, Richard Hipp wrote: > > > > I have set up an on-line forum as a replacement for this mailing list: > > Oh crap. > > > The Forum is powered by Fossil. > > I appreciate that you like to 'eat your own dog food'.

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

The nice thing about web browsers, you can apply your own styling. There's extensions that help with that, like StyleBot. Wout. 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. > > > -- >

Re: [sqlite] New SQLite Forum requires Javascript?

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,

[sqlite] New SQLite Forum requires Javascript?

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

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

I've read a bunch of the posts here, and quite honestly, I'm kind of looking forward to having Fossil send me notes that messages have been added, then, if I want to reply, I just log into the site and do the reply. I'm not 100% sure about the anon sending to Fossil, if that's a thing I thought I

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

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

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

On March 12, 2020 8:15:15 p.m. EDT, Jens Alfke wrote: > > >> On Mar 12, 2020, at 1:17 PM, Richard Hipp wrote: >> >> I have set up an on-line forum as a replacement for this mailing >list: > >Oh crap. > >> The Forum is powered by Fossil. > >I appreciate that you like to 'eat your own dog

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

On March 12, 2020 8:06:47 p.m. EDT, Petite Abeille wrote: > >Also, would it be possible to actually mark such emails to include >proper List Header Fields, e.g.: I had the same thought, but would that really be appropriate? Unless you could post to it like a list, anyway. -- J. King

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

> On Mar 12, 2020, at 1:17 PM, Richard Hipp wrote: > > I have set up an on-line forum as a replacement for this mailing list: Oh crap. > The Forum is powered by Fossil. I appreciate that you like to 'eat your own dog food'. However, I strongly disagree with your using a homemade forum

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

> 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. ___ sqlite-users

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

> On Mar 13, 2020, at 00:54, BohwaZ wrote: > > So that people wishing to use emails could still do it by subscribing > to alerts and then replying to notifications. Also, would it be possible to actually mark such emails to include proper List Header Fields, e.g.: List-Id: List Header

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

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

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

Kia ora, Like with the Fossil list I did subscribe and switch to the forum, but wouldn't it be 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

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

Hello Richard ! I like the concept of fossil including the forum functionality ! With that said we are in a database forum and most of us know that one common problem/task with databases is migration, there is any plan/attempt to migrate the actual mailing list to the new fossil forum ?

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

> 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

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

On Mar 12, 2020, at 2:59 PM, no...@null.net wrote: > > I would like to add my resistance "vote." If experience on the Fossil mailing list is any guide, this mailing list will be a ghost town soon. There have been just a few threads on the mailing list in the years since we started the forum,

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

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

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

On Thu Mar 12, 2020 at 04:17:59PM -0400, 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 I know this topic has already been discussed deeply on this list, but I

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

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

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

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

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

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

>So is "julianday('now')" non-deterministic while "julianday()" _is_ >deterministic? That seems a little weird considering they're the same >thing... right? Yes. Same as "datetime(julianday(), '+1 day')" and datetime(datetime(), '+1 day') are deterministic but "datetime('now', '+1 day')" is not

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

On 3/12/20, Doug wrote: > > Something triggered me when I looked at the generated code: you use the > contents of register 2 for the constant value each time through the loop. > What if the select looks like this, with more than one function call in the > coalesce? Do you handle it properly? > >

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

Thanks, Richard. Something triggered me when I looked at the generated code: you use the contents of register 2 for the constant value each time through the loop. What if the select looks like this, with more than one function call in the coalesce? Do you handle it properly? SELECT

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

> Alternatively, you can use the new GENERATED ALWAYS AS (...) STORED to make > it an automatically updated stored field and you do not need triggers at all, > just a version of SQLite3 that does generated columns (version 3.31.0 from > 2020-01-22 or later). > > create table MyData > ( > id

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

On Thursday, 12 March, 2020 09:37, David Blake wrote: >What stops the >UPDATE ports SET timeofday = CURRENT_TIMESTAMP WHERE id = NEW.id ; >from also triggering the AFTER UPDATE ON recursively? >Perhaps a pragma or inSQLite are triggers non-recursive by default? >I am using (now I have by

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

On 12 Mar 2020, at 3:36pm, David Blake wrote: > What stops the > UPDATE ports SET timeofday = CURRENT_TIMESTAMP WHERE id = NEW.id ; > from also triggering the AFTER UPDATE ON recursively? > > Perhaps a pragma or inSQLite are triggers non-recursive by default? Bingo.

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

> What stops the > UPDATE ports SET timeofday = CURRENT_TIMESTAMP WHERE id = NEW.id ; > from also triggering the AFTER UPDATE ON recursively? > > Perhaps a pragma or inSQLite are triggers non-recursive by default? > > I am using (now I have by semi-colons right) > CREATE TRIGGER tgrUpdate AFTER

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

>Thanks Andy >> In addition, the role of the "when" clause is unclear. Is it necessary? >> >> I don't think it is. I have a very similar trigger which I've been >> using for several years And it doesn't have the where... >> >> CREATE TRIGGER [UpdatePortTime] AFTER UPDATE ON ports FOR EACH ROW

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

Thanks Andy > In addition, the role of the "when" clause is unclear. Is it necessary? > > I don't think it is. I have a very similar trigger which I've been using > for several years > And it doesn't have the where... > > CREATE TRIGGER [UpdatePortTime] AFTER UPDATE ON ports > FOR EACH ROW >

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

On 3/12/20, Doug wrote: > Richard, what does the explain look like with your code change, please. Test case: CREATE TABLE t1(a); explain SELECT coalesce(a, abs(-9223372036854775808)) FROM t1; Before the change: addr opcode p1p2p3p4 p5 comment

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

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: COALESCE() does not short- >

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

According to your pragmas you have vacuum done once in a while. Vacuum alters the rowid values of a table, unless the rowid is declared explicitly as "INTEGER PRIMARY KEY" (probably not the case here). See from here : /If the rowid is not aliased by

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

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. SQLite tries to factor

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

>On 12/03/2020 08:47, David Blake wrote: >> I'm looking for an easy way to maintain a last updated column for each >> record in several tables and considering if using a triggers is viable. >> >> I thought that defining a trigger like this on each table would work >> >> CREATE TRIGGER

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

On 12/03/2020 08:47, David Blake wrote: I'm looking for an easy way to maintain a last updated column for each record in several tables and considering if using a triggers is viable. I thought that defining a trigger like this on each table would work CREATE TRIGGER my_update_trigger BEFORE

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

Ha, my error - missing ";" in the UPDATE clause but I was blind. On Thu, 12 Mar 2020 at 08:18, David Blake wrote: > Thanks for such a swift reply, good to know that it should work (without > typos) > > >Thank you very much for keeping the error message secret. > > near "END": syntax error: > >

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

Thanks for such a swift reply, good to know that it should work (without typos) >Thank you very much for keeping the error message secret. near "END": syntax error: I'm testing out ideas using DB Browser, but will try in my app and see if this is just a DB Browser issue On Thu, 12 Mar 2020 at

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

David Blake wrote: > CREATE TRIGGER my_update_trigger BEFORE UPDATE ON My_table > FOR EACH ROW WHEN NEW.lastupdated < OLD. lastupdated > BEGIN > UPDATE song SET lastupdated = DATETIME('now') WHERE id = NEW.id > END > > The WHEN clause is an attempt to avoid infinite recursion that

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

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 asql> explain select coalesce((SELECT

  1   2   3   4   5   6   7   8   9   10   >