Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Richard Hipp 
On Sat, Mar 2, 2013 at 3:30 PM, Rob Turpin  wrote:

> So I'm assuming saving in memory databases isn't an option with sqlite4.
>

Not in a single step at this time.

You could, I suppose, implement the equivalent of the ".dump" command from
the shell.

The underlying data storage in SQLite4 is a simple key/value pair database
with blobs for both key and value.  You could probably implement a command
that would very efficiently copy all key/values from one database into
another, in key order.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Rob Turpin 
So I'm assuming saving in memory databases isn't an option with sqlite4.

On Sat, Mar 2, 2013 at 5:58 AM, Richard Hipp  wrote:

> On Sat, Mar 2, 2013 at 5:52 AM, Rob Turpin  wrote:
>
> > The backup API for sqlite3
> >
> > sqlite3_backup_init
> > sqlite3_backup_step
> > sqlite3_backup_finish
> >
> > I can't find anything similar in sqlite4.  Is there any, or plans for it?
> >
>
> There are no pressing plans.  It isn't on the to-do list.
>
> The SQLite3 backup mechanism operates deep down at the page level of the
> b-tree storage engine.  But SQLite4 does not use a b-tree storage engine,
> it uses LSM, so the SQLite3 backup mechanism isn't directly applicable.
> Some entirely need implementation method would need to be devised.
>
>
> >
> > Thanks,
> > Rob
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] backup api for sqlite4?

2013-03-02 Thread Richard Hipp 
On Sat, Mar 2, 2013 at 5:52 AM, Rob Turpin  wrote:

> The backup API for sqlite3
>
> sqlite3_backup_init
> sqlite3_backup_step
> sqlite3_backup_finish
>
> I can't find anything similar in sqlite4.  Is there any, or plans for it?
>

There are no pressing plans.  It isn't on the to-do list.

The SQLite3 backup mechanism operates deep down at the page level of the
b-tree storage engine.  But SQLite4 does not use a b-tree storage engine,
it uses LSM, so the SQLite3 backup mechanism isn't directly applicable.
Some entirely need implementation method would need to be devised.


>
> Thanks,
> Rob
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] backup api for sqlite4?

2013-03-02 Thread Rob Turpin 
The backup API for sqlite3

sqlite3_backup_init
sqlite3_backup_step
sqlite3_backup_finish

I can't find anything similar in sqlite4.  Is there any, or plans for it?

Thanks,
Rob
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users