[sqlite] Busy management

[Ludovic Ferrandis]

Hi,

Newbie to SQLite, so maybe my question will seems trivial.

I want to manage the SQLITE_BUSY error like this: If it fails, sleep X
ms then try the command Y times. I found 2 ways to do it:

----- First is to manage a loop like:

tryIt = X;

do
{
        err = sqlite3_exec(...)
} while (err == SQLITE_BUSY && tryIt-- && sleep(Y))

-- Alternative (??)

sqlite3_busy_timeout(sqlite3*, Y);
tryIt = X;

do
{
        err = sqlite3_exec(...)
} while (err == SQLITE_BUSY && tryIt--)


----- The second is to set a busy callback

sqlite3_busy_handler(sqlite3*, foo, void*)

And in 
int foo(void*,int count)
{
        if (count > X)
                return 0;

        sleep(Y);
        return 1;
}

-----

The second solution seems better to me, because we don't have to manage
a loop for each function that can return SQLITE_BUSY (like exec, step or
even close).

In a lot of example, the first solution is often use. Is there any
issues with the second one?

Any advise ?

Thanks.