Re: [sqlite] the sqlite3 documentation would be pretty good if it wasn't tragic...

The syntax diagrams are created by a tcl script, not drawn by hand: https://wiki.tcl-lang.org/page/Generating+Syntax+Diagrams+Using+Tk I think a lot of the documentation assumes the reader already knows the basics of sql... What kind of examples are you thinking of? On Tue, Jun 25, 2019, 8:16

[sqlite] Incorrect results after upgrading to 3.28.0

Hello, We recently updated from version 3.26.0 to version 3.28.0. Now we're seeing different (incorrect) results for the following query. Our database is available here:

[sqlite] the sqlite3 documentation would be pretty good if it wasn't tragic...

...that the person(s) that has no problem writing small, but solid, walls of technical detail and drawing intricate circularly recursive syntax diagrams which require multiple levels of detail to coherently represent, can't be bothered to write example sql code for the top dozen things that most

Re: [sqlite] nested set tree: how to change order of one node?

On 18 Jun 2019, at 14:19, Sam Carleton wrote: > > The tree in question contains categories, subcategories and finally image > galleries. It is common for the user to want to sort all the subordinates > of one level a different way, at times alphanumeric, other times simply to > their liking. I

[sqlite] behavior with inconsistent pragma journal_mode

process: - create a new db and set pragma journal_mode=PERSIST - create a table - open the same db again, without setting journal mode - create another table Result: second create table statement returns SQLITE_IOERR (code 10) after notable delay Honestly, I'm not very proud of this use