Improve SQLite statement handling

The Guix Build Coordinator would segfault, and this seemed to come when
preparing statements. I think this is happening because the (sqlite3) bindings
finalize statements when they're out of scope, and this happens in the garbage
collector thread. SQLite is running in multi-threaded mode, which means
actions relating to one database connection shouldn't happen concurrently in
different threads, hence I think this is leading to a segfault.

To work around this behaviour, pass #:cache? #t to sqlite-prepare so
statements are long lived where possible, or in the few cases where the SQL is
dynamic, make sure to finalize it before the garbage collector gets a chance.

This'll hopefully mean that there's less segfaults...

0 files changed, 0 insertions, 0 deletions