[sqlite] Delete an existing module

Hello, Is it possible to delete a module and the associated client data ? I tried to pass a NULL pointer as the third parameter of sqlite3_create_module_v2, sqlite3_create_module_v2( db, zName, NULL, NULL, NULL ); but I got a SQLITE_MISUSE error. Thanks.

[sqlite] Version 3.13.0 coming soon

Original message From: Richard Hipp Date: 03/05/2016 13:33 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] Version 3.13.0 coming soon > Yes.? Apparently that is the new standard for security on unix systems.? Write lets you create new temp files.? Execute lets

[sqlite] Make mmap_size dynamic?

Mikael wrote: > On Tuesday, 3 May 2016, Richard Hipp > wrote: > >> On 5/2/16, Mikael wrote: >>> >>> If I just force it on (by hacking the build script), as long as mmap_size >>> always is 2^63, will Sqlite access the file via memory accesses only, and >>> never using fread/fwrite which would lead

[sqlite] Version 3.13.0 coming soon

On Tue May 03, 2016 at 08:33:30AM -0400, Richard Hipp wrote: > On 5/2/16, Rolf Ade wrote: > > > > Richard Hipp writes: > >> A change summary for 3.13.0 is at > >> https://www.sqlite.org/draft/releaselog/3_13_0.html > > > > Change the temporary directory search algorithm on Unix to allow > >

[sqlite] Delete an existing module

On 5/3/16, gwenn wrote: > Hello, > Is it possible to delete a module and the associated client data ? > I tried to pass a NULL pointer as the third parameter of > sqlite3_create_module_v2, > sqlite3_create_module_v2( > db, > zName, > NULL, > NULL, > NULL > ); > but I got a SQLITE_MISUSE

[sqlite] Version 3.13.0 coming soon

On 5/3/16, Graham Holden wrote: > >> Yes. Apparently that is the new standard for security on unix > systems. > > New? I remember FTP repositories from the mid 80s (funic, wustl?) where this > scheme was common place for the "upload" directory so random visitors The capability is not new, but th

[sqlite] ODP: ODP: Cancelling sqlite3_wal_checkpoint

Thank you! Od: sqlite-users-bounces at mailinglists.sqlite.org w imieniu u?ytkownika Richard Hipp Wys?ane: 3 maja 2016 15:41 Do: SQLite mailing list Temat: Re: [sqlite] ODP: Cancelling sqlite3_wal_checkpoint On 5/3/16, Albert Banaszkiewicz wrote: > I se

[sqlite] ODP: Cancelling sqlite3_wal_checkpoint

I see. How safe it will be with respect to data integrity ? Are there any chances data can get lost ? Will it affect other read connections in any way ? If the process is terminated like this, what will happen when sqlite3_wal_checkpoint is called again ? Is the process going to be resumed fro

[sqlite] Version 3.13.0 coming soon

On 5/3/16, nomad at null.net wrote: > On Tue May 03, 2016 at 08:33:30AM -0400, Richard Hipp wrote: >> >> Yes. Apparently that is the new standard for security on unix > > The way I understood Rolf's comment was that he was pointing out a > typo: Ah. You are correct: I completely missed Rolf's p

[sqlite] Cancelling sqlite3_wal_checkpoint

Hi all, Is it possible to cancel check-pointing operation in any way ? I could find how to interrupt queries (?sqlite3_interrupt) but I assume it won't work for check-pointing (not really a query). However, like long-lasting queries, check-pointing can take a while, thus I am wondering if th

[sqlite] FTS offsets() reporting SQLITE_CORRUPT with empty string, redux

Hi all, I'm running into a bug where the FTS offsets() function is returning a null string, causing SQLITE_CORRUPT to be reported for SELECT query results in both SQLite 3.11 and 3.12.2. This is similar to a previously reported issue with SQLite from a while back -

[sqlite] SQLite vs GPLed software

>From a purely numerical point of view, the largest numbers would be found in devices, eg phones, cars, TVs, clocks/timers, etc. Lots of GPL in there, but also lots of other licences too. I have no idea how the GSM stack is licensed, for example, but I think there are more GSM phones than instances

[sqlite] Differences for DELETE with EXISTS

>> I observe a difference in results of a DELETE query using the EXISTS >> operator between Sqlite version 3.8.11.1 and 3.9.0. > > Thanks for the bug report. > > Ticket: https://www.sqlite.org/src/info/dc6ebeda9396087 > Candidate fix: https://www.sqlite.org/src/info/3f221f592a9a1900 > -- > Richard

[sqlite] ODP: Cancelling sqlite3_wal_checkpoint

On 5/3/16, Albert Banaszkiewicz wrote: > I see. > How safe it will be with respect to data integrity ? Are there any chances > data can get lost ? SQLite is designed to handle this without data loss. And we actually run a lot of tests for that as well. > Will it affect other read connections in

[sqlite] Cancelling sqlite3_wal_checkpoint

On 5/3/16, Albert Banaszkiewicz wrote: > Hi all, > > > Is it possible to cancel check-pointing operation in any way ? > You can kill the thread or process that is running the checkpoint. Other than that, there is not currently any way to interrupt a checkpoint in progress. -- D. Richard Hipp dr

[sqlite] Version 3.13.0 coming soon

On 5/2/16, Rolf Ade wrote: > > Richard Hipp writes: >> A change summary for 3.13.0 is at >> https://www.sqlite.org/draft/releaselog/3_13_0.html > > Change the temporary directory search algorithm on Unix to allow > directories read and execute permission, but without read permission, > to

[sqlite] Make mmap_size dynamic?

Aha, great! So what I was asking for was already in the box, and a mmap_size of say 2^63 will be fine then! One reason that I asked for this was that I want to use it on OpenBSD, and there, mmaping in Sqlite is disabled altogether, in the absence of a unified buffer cache (UBC) in the OS. If I j

[sqlite] Version 3.13.0 coming soon

Richard Hipp writes: > A change summary for 3.13.0 is at > https://www.sqlite.org/draft/releaselog/3_13_0.html Change the temporary directory search algorithm on Unix to allow directories read and execute permission, but without read permission, to serve as temporary directories. ..

[sqlite] SQLite vs GPLed software

On 3 May 2016, at 12:42am, Richard Hipp wrote: > There are countless other GPL projects without which life as > we know it would come to an end: valgrind, gcc, bash, to name but a > few. But I cannot think of any that have extensive usage outside the > geek community, and hence for all their i