*** 32,37 **** --- 32,38 ---- 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) + A) No. ------- Q) Is there a standard way of backing up SQlite databases aside from simply copying the database file to another location *************** *** 46,51 **** --- 47,53 ---- Q) Is it possible to output queries and associated results into an output text file? ------ Q) Is there a simple way to figure out the primary key(s) of a table through sql? + A) Only by doing a select on the master table. ------ Q) Does SQLite have a bulk loading tool? ------ *************** *** 54,59 **** --- 56,62 ---- Q) Where do I get the header file (i.e. sqlite3.h) matching the precompiled binary (i.e. sqlite-3.2.1.so.gz) ? ------ Q) Are there any advantages of using either a static library over the linked library (Performace, Speed, Compatibality)? + A) Depends, but on Windows platforms hardly. It matters startup times and perhaps the ease of deployment. ------ Q) Why do the prototypes from the C api reference and the Quick Start guide not match up? ------
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|