> > Does that mean that I can also be totally sure that the changes are on > > the phsycical disk? > Yes, to the extend that there is a physical disk. > http://www.sqlite.org/transactional.html
Yes, ok clear. If the system underneath behaves "different" then, well, we're lost anyway. > > Does SQLite e.g. do a fsync() or sync() after it > > executed the changes? > Yes, or similar. > http://www.sqlite.org/pragma.html#pragma_synchronous Ok. I'm asking as I was looking at some application using SQLite which executes an explicit sync() after each query it executes. I'm not a database expert but I always thought that the whole idea behind databases were that you could rely on, well, the whole ACID idea. And I'm very happy to see that SQLite does so! Folkert van Heusden -- Nagios user? Check out CoffeeSaint - the versatile Nagios status viewer! http://www.vanheusden.com/java/CoffeeSaint/ ---------------------------------------------------------------------- Phone: +31-6-41278122, PGP-key: 1F28D8AE, www.vanheusden.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
