Re: [sqlite] Things you shouldn't assume when you store names

2019-11-12 Thread Richard Damon
On 11/12/19 2:42 PM, Michael Tiernan wrote: > On 11/10/19 1:21 AM, Gary R. Schmidt wrote: >> So what happens when someone from a family who only uses first- and >> last-names moves to Kansas? >> >> Do they have to make up a middle-name so that he idiots can fill out >> the forms? > > I am most

Re: [sqlite] Things you shouldn't assume when you store names

2019-11-12 Thread Michael Tiernan
On 11/10/19 1:21 AM, Gary R. Schmidt wrote: So what happens when someone from a family who only uses first- and last-names moves to Kansas? Do they have to make up a middle-name so that he idiots can fill out the forms? I am most definitely not going to take one side or the other. My only

Re: [sqlite] JSON_EXTRACT does not work with non-BMP characters

2019-11-12 Thread Serhiy Storchaka
10.11.19 19:54, Richard Hipp пише: On 11/8/19, Serhiy Storchaka wrote: JSON_EXTRACT [1] produces gibberish for encoded non-BMP characters. Thanks for the bug report and test case. I checked in candidate fix here: https://www.sqlite.org/src/timeline?c=51027f08c0478f1b I need to do additional

[sqlite] Checkin df51ae19c1 pager.c line 4866 nUri undefined

2019-11-12 Thread Keith Medcalf
nUri is only defined if SQLITE_DEBUG is defined. Should this line be #ifndef SQLITE_DEBUG? -- 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

Re: [sqlite] Why does Python turn UTF8 data in SQLite into Latin1?

2019-11-12 Thread Winfried
Sorry. Windows 7 32 bits US + with French locale + Python 3.7.0. Turns out it had nothing to do with SQLite, and everything to do with Python's write(), which uses the default locale, so the following is required to output data as UTF-8 instead of cp1252 used on this computer:

Re: [sqlite] Custom window functions vs builtin

2019-11-12 Thread Merijn Verstraaten
> On 12 Nov 2019, at 14:58, Dan Kennedy wrote: > > No, they don't need to handle that. The rows will always be added/removed in > ORDER BY order for all window functions (and will be removed in the same > order in which they were added if the ORDER BY order is ambiguous). Ah, excellent!

Re: [sqlite] WAL2 mode

2019-11-12 Thread Dan Kennedy
On 12/11/62 19:00, Simon Slavin wrote: On 12 Nov 2019, at 10:06am, Dan Kennedy wrote: This branch might interest you: https://www.sqlite.org/src/timeline?r=begin-concurrent-pnu-wal2 " In wal2 mode, the system uses two wal files instead of one. The files are named "-wal" and "-wal2""

Re: [sqlite] Custom window functions vs builtin

2019-11-12 Thread Dan Kennedy
On 12/11/62 18:50, Merijn Verstraaten wrote: I already asked this question without an answer, but as it hidden somewhere nested deeply in another thread I think it may have simply gone under the radar. Apologies for the duplication if you already saw it! How is the behaviour of (custom)

[sqlite] Wrong initialization for pPager->zJournal in sqlite3PagerOpen

2019-11-12 Thread Mariano Quesada Morales
The zJournal path must have at least 2 null characters at the end of the string or an "Acess violation reading" exception can be thrown. With the current code the second null characters is overridden by these instructions: ... pPager->zWal = >zJournal[nPathname+8+1]; memcpy(pPager->zWal,

Re: [sqlite] database disk image is malformed

2019-11-12 Thread Andreas Kretzer
Just to make sure, you didn't oversee that (like I was ...): Daemonizing a process is also a fork() - and this invalidates your connection! I used the daemon() function in my program (together with a few other processes) that used a DB connection. I opened this connection _before_ I called

Re: [sqlite] database disk image is malformed

2019-11-12 Thread Jukka Marin
On Mon, Nov 11, 2019 at 05:37:37PM +, Simon Slavin wrote: > On 11 Nov 2019, at 5:13pm, Jukka Marin wrote: > > > The main process first opens the databases and checks that their > > version matches that of the software and if not, the databases are > > closed and initialized by running a

Re: [sqlite] Things you shouldn't assume when you store names

2019-11-12 Thread Amit Chaudhuri
Ha ha ha - Oh Simon.what *have* you done? [Apologies for the noise - could not resist this one.] On Sat, 9 Nov 2019 at 19:26, Simon Slavin wrote: > > Since I don't see many posts yet this weekend, please excuse one of mine > which isn't exactly on charter. Feel free to argue me out of

[sqlite] WAL2 mode

2019-11-12 Thread Simon Slavin
On 12 Nov 2019, at 10:06am, Dan Kennedy wrote: > This branch might interest you: > > https://www.sqlite.org/src/timeline?r=begin-concurrent-pnu-wal2 " In wal2 mode, the system uses two wal files instead of one. The files are named "-wal" and "-wal2" " Could this be changed to -wal1 and

[sqlite] Custom window functions vs builtin

2019-11-12 Thread Merijn Verstraaten
I already asked this question without an answer, but as it hidden somewhere nested deeply in another thread I think it may have simply gone under the radar. Apologies for the duplication if you already saw it! How is the behaviour of (custom) window functions defined? Specifically, in the

Re: [sqlite] proposal for write-lock on "commit" rather than "begin transaction"

2019-11-12 Thread Dan Kennedy
On 25/10/62 23:07, Brannon King wrote: This is a request for a small change to the handling of multiple connections. I think it would significantly enhance the usefulness there via allowing multiple "views" of the data. Consider that I have two simultaneous connections to one file, named Con1