Hi Simon, One of my colleague asked me if SQLite have any "Database redundancy support"? So i was trying to correct him saying that Data redundancy is an issue and why should an RDBMS support an issue? So from his words what i understood was a mechanism like 'Managed Backups'. That was what i tried to convey by calling it Automatic Backup.
Another doubt is like : When you say sorting contents in the DB, is this the same as Querying? Thanks & Regards, Sen ____________________________________** On 4/12/2010 11:45 AM, Simon Slavin wrote: > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
