On Wed, 4 Feb 2009 17:55:38 -0500, "D. Richard Hipp"
wrote in General Discussion of SQLite
Database :
>The hot backup API has not yet been released. Look for version 3.6.11.
>
>If you open your database using the special name ":memory:" then it is
>held entirely in memory with no duplication o
On Feb 7, 2009, at 4:56 PM, Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Thursday 05 February 2009 02:48:25 D. Richard Hipp
> написал(а):
>> The SQLite core will call the locking methods, but they can be no-
>> ops. The read method can be a no-op too, I suppose, if you are only
>> using
Hello!
В сообщении от Thursday 05 February 2009 02:48:25 D. Richard Hipp написал(а):
> The SQLite core will call the locking methods, but they can be no-
> ops. The read method can be a no-op too, I suppose, if you are only
> using the VFS to make a backup. Oh, and the writes will all be page
On Feb 4, 2009, at 6:38 PM, Brown, Daniel wrote:
> Hi Richard,
>
> Thanks for the advice: I will take a look into a barebones VFS
> implementation for backup purposes. I assume it won't need the usual
> locking functionality that normal VFS implementations require: pretty
> much just read, write
aniel
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of D. Richard Hipp
> Sent: Wednesday, February 04, 2009 3:19 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Saving and loading SQL
On Feb 4, 2009, at 6:09 PM, Brown, Daniel wrote:
>
> I currently use SQLite by opening ":memory:" and then copying the
> tables
> I want from read only storage into ":memory:" via an attached read
> only
> database, which I drop after copying is complete. My issue is saving
> and loading the
-Original Message-
>The hot backup API has not yet been released. Look for version 3.6.11.
I will look forward to seeing that release! Is there anything I can do
to help with the development?
>If you open your database using the special name ":memory:" then it is
>held entirely in memo
> That depends. If the change was made using the same database
> connection that was passed into sqlite3_backup_init(), then only those
> pages that changed are recopied. However, if an independent database
> connection made the change, then the backup process has no way of
> knowing exac
On Feb 4, 2009, at 5:48 PM, Nicolas Williams wrote:
> On Wed, Feb 04, 2009 at 05:19:13PM -0500, D. Richard Hipp wrote:
>> http://www.sqlite.org/draft/c3ref/backup_finish.html
>
> Does this work at the page level? Or can one have pre-created the
> destination DB with a different page size than th
On Feb 4, 2009, at 5:51 PM, Eric Minbiole wrote:
>
> "If the source database is modified [...] then the backup will be
> transparently restarted by the next call to sqlite3_backup_step()"
>
> Does this mean that the backup is restarted *to the beginning*, or
> is it
> able to re-copy only those
On Wed, Feb 04, 2009 at 05:19:13PM -0500, D. Richard Hipp wrote:
> http://www.sqlite.org/draft/c3ref/backup_finish.html
Does this work at the page level? Or can one have pre-created the
destination DB with a different page size than the source DB?
Nico
--
___
On Feb 4, 2009, at 5:48 PM, Brown, Daniel wrote:
>
> What version(s) of SQLite contain this experimental functionality?
> I am
> using version 3.6.10 non-amalgamation but I can't find the functions
> mentioned on that page. If I understand this backup API correctly
> then
> its functionality
> http://www.sqlite.org/draft/c3ref/backup_finish.html
This is excellent! I've been looking for a clean way to perform live
backups. This (draft) API looks perfect.
I have one clarification question about source database changes made
during the backup. The documentation states:
"If the so
ruary 04, 2009 2:19 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Saving and loading SQLite pages from a buffer
On Feb 4, 2009, at 5:12 PM, Brown, Daniel wrote:
> Good Afternoon List,
>
> I've been looking at how best to save/load SQLite database that is
> 1
On Feb 4, 2009, at 5:12 PM, Brown, Daniel wrote:
> Good Afternoon List,
>
> I've been looking at how best to save/load SQLite database that is
> 100%
> in memory to and from a memory buffer instead of a file via a VFS
> operating system wrapper. I had initially thought that implementing a
> Vi
Good Afternoon List,
I've been looking at how best to save/load SQLite database that is 100%
in memory to and from a memory buffer instead of a file via a VFS
operating system wrapper. I had initially thought that implementing a
Virtual File System (VFS) was a solution but then I realised that wo
16 matches
Mail list logo
