[sqlite] Reusing built-in sqlite3_io_methods

2018-12-20 Thread Albert Banaszkiewicz
scratch or copy it from sqlite source code ? Best Regards, Albert Banaszkiewicz ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Odp.: Creating and dropping tables with multiple connections

2018-11-21 Thread Albert Banaszkiewicz
First of all, sorry, for posting the code that did not compile. My intention was to simply show whats going on rather than provide copy-paste-able example. @RichardHipp Thank you for your suggestion. It works as You described. @All Thanks for Your input Regards, Albert

[sqlite] Creating and dropping tables with multiple connections

2018-11-20 Thread Albert Banaszkiewicz
Hi everybody, I have a question regarding multiple connections to the same DB from the same process. I was expecting that modifying a DB via a certain connection should also be visible for all other opened connections. Is my assumption incorrect ? (both operations being transactions). In

[sqlite] ODP: ODP: Cancelling sqlite3_wal_checkpoint

2016-05-03 Thread Albert Banaszkiewicz
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: >

[sqlite] ODP: Cancelling sqlite3_wal_checkpoint

2016-05-03 Thread Albert Banaszkiewicz
] 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 interru

[sqlite] Cancelling sqlite3_wal_checkpoint

2016-05-03 Thread Albert Banaszkiewicz
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

[sqlite] ODP: ODP: Controlling of check-pointing of WAL Dbs

2016-04-28 Thread Albert Banaszkiewicz
On 4/28/16, Albert Banaszkiewicz wrote: > I assume (I will test it later), that by killing the process you mean simply > shutting it down (regularly) without ever calling sqlite3_close, am I right > ? Yes -- D. Richard Hipp drh at sqlite.org _

[sqlite] ODP: Controlling of check-pointing of WAL Dbs

2016-04-28 Thread Albert Banaszkiewicz
Od: sqlite-users-bounces at mailinglists.sqlite.org w imieniu u?ytkownika Richard Hipp Wys?ane: 27 kwietnia 2016 15:23 Do: SQLite mailing list Temat: Re: [sqlite] Controlling of check-pointing of WAL Dbs On 4/27/16, Albert Banaszkiewicz wrote: > Hello. > > I am new her

[sqlite] ODP: Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Albert Banaszkiewicz
/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 27 April 2016 at 12:38, Albert Banaszkiewicz wrote: > Hello. > > I am new here, thus I would like to apologize in advance if the question I am

[sqlite] ODP: Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Albert Banaszkiewicz
at mailinglists.sqlite.org w imieniu u?ytkownika Clemens Ladisch Wys?ane: 27 kwietnia 2016 13:51 Do: sqlite-users at mailinglists.sqlite.org Temat: Re: [sqlite] Controlling of check-pointing of WAL Dbs Albert Banaszkiewicz wrote: > 1. Is there a way to control (i.e. disable) check-point

[sqlite] Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Albert Banaszkiewicz
Hello. I am new here, thus I would like to apologize in advance if the question I am going to rise was already asked in the past. I am using SQLite 3.11.1 (actually it is a NDS consortium customized version based on it). According to documentation, in case of WAL mode enabled databases, final