Re: [sqlite] Support for Backup

2010-04-12 Thread Simon Slavin

On 12 Apr 2010, at 6:46am, Navaneeth Sen B wrote:

> I just want to know whether SQLite support automatic backup of the DB 
> contents.
> Or is there any other DBs which support this feature?

What do you mean by 'automatic backup' ?  I don't think this term has a 
commonly used definition.

I can tell you the following: If a database isn't in use you can just copy the 
once file and get the entire database.  SQLite does supply an API for copying a 
database which is in use, but you can't just copy the files.  SQLite does not 
support undo once a transaction is committed.  Committed transactions are 
flushed to disk very quickly.  SQLite supports ACID about as well as the 
underlying OS and file system can.

If you'd like to give a definition of 'automatic backup' we may be able to help 
more.

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


[sqlite] Support for Backup

2010-04-11 Thread Navaneeth Sen B
Hi all,

I just want to know whether SQLite support automatic backup of the DB 
contents.
Or is there any other DBs which support this feature?

Regards,
Sen




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