*** 13,15 **** --- 13,17 ---- A) Use some system API funtion like IsFileExists(DB_filename) before calling sqlite_open(DB_filename) ------- Q) Is it possible to let the programmer choose - commit or rollback the transaction that was begun with BEGIN and some INSERTS/UPDATES, but was not finished due to system hangup or power failure, instead of automatically rollback it on opening the DB??? (assume the transaction journal file integrity is fully correct) + ------- + Q) Is there a standard way of backing up SQlite databases aside from simply copying the database file to another location?
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|