On 06.10.2019 22:02 Keith Medcalf wrote:
> On Sunday, 6 October, 2019 13:03, Kadirk wrote:
>
>> We already have an application specific WAL file, sqlite updates +
>> application data is in this WAL file. We are taking snapshot of sqlite +
>> application data to the disk to truncate WAL file, then
On Sunday, 6 October, 2019 13:03, Kadirk wrote:
>We already have an application specific WAL file, sqlite updates +
>application data is in this WAL file. We are taking snapshot of sqlite +
>application data to the disk to truncate WAL file, then we can rebuild
>latest state whenever needed
On 6 Oct 2019, at 8:03pm, Kadirk wrote:
> I expect there might be a way to take backup of sqlite in memory while
> updates are still being processed (as in on disk online backup). Maybe
> something like copy on write memory for that?
You can't clone something which is changing. Obviously.
Simon, Keith thanks for the answers, let me give some more details.
We already have an application specific WAL file, sqlite updates +
application data is in this WAL file. We are taking snapshot of sqlite +
application data to the disk to truncate WAL file, then we can rebuild
latest state
On Saturday, 5 October, 2019 15:44, Kadirk wrote:
>How to do online backup of an in memory database (to disk)?
An in memory database is a transient object. Why would you want to back it up?
>Planning to use in memory database with 10 gb+ data, there are queries
>continuously so stopping
How do you know that the "error" is related to the use of a caret?
Perhaps your .net wrapper is diddling text strings that contain carets for some
reason known only to the wrapper writer? Have you checked the wrapper
documentation to see if such diddling is documented, and if so, how to turn
On 5 Oct 2019, at 10:43pm, Kadirk wrote:
> Whenever an update comes in,
> backup process starts over so it won't finish. Any idea how to solve this?
How do you expect to take a perfect copy of something which is constantly
changing ? Do you expect the changes to stop affecting the database
On 6 Oct 2019, at 5:56am, André Borchert wrote:
> The odd thing is that the sql statement works just fine when I use DB Browser
> for SQLite.
Try the SQLite command line tool. That's written by the team which maintains
SQLite itself, and it should give the connonically correct result. If it
Hello,
I have a request for two API additions: sqlite3_vconfig() and
sqlite3_db_vconfig(). The naming convention is borrowed from vprintf() and
friends. The functions would be identical to sqlite3_config() and
sqlite3_db_config() except they would take a va_list instead of variadic
arguments.
How to do online backup of an in memory database (to disk)?
Planning to use in memory database with 10 gb+ data, there are queries
continuously so stopping application is not an option. Looks like for on
disk databases it is possible with a non-blocking fashion but I couldn't
find a way to do it
Hello,
in my C# program which uses DllImport for sqlite.dll (3.29) I get Error 19
(SQLITE_CONSTRAINT) with this statement:
INSERT INTO CompanyDetails (RIC) VALUES('AMBEUR.IP^G19')
The ^ symbol is part of the text I want to save, its not a filter or so, its
just plain text.
The odd thing is
11 matches
Mail list logo