[sqlite] Order by table reads

Hi, i've a question about how to control the order in which sqlite reads tables. here is the basic setup: table foo (f_id integer primary key, foo text, prio integer); table bar (b_id integer primary key, bar text, prio integer); table foobar (fb_id integer primary key, f_id integer, b_id

RE: [sqlite] Concurrency

// wrapper for sqlite3_prepare_v2 which retries creating statements if the db returns SQLITE_BUSY or SQLITE_LOCKED int sql_prepare(sqlite3 *db, const char *sql, sqlite3_stmt **ppStmt, int wait) { #ifdef SQL_DEBUG printf(sql); printf("\n"); fflush(stdout); #endif int