On Fri, Apr 11, 2014 at 1:38 PM, Simon Slavin <slav...@bigfraud.org> wrote:

> I seem to recall that the sqlite3_open() call dos not really open the
> database.  The open actually happens when the data is
>
first accessed.  So to do the above "one process that opens the
> database" does one need to do some kind of access (presumably a harmless
> SELECT) ?
>

There was recently a post to this effect, where Richard said:


On Mon, Sep 2, 2013 at 10:52 PM, Richard Hipp <d...@sqlite.org> wrote:

> sqlite3_open() and sqlite3_open_v2() defer the actual opening of the
> database file until you do something with the database.  This is to give
> you the opportunity to issue PRAGMA statements that might influence the
> opening process.
>
> Running a very simple statement like
>
>      SELECT 1 FROM sqlite_master LIMIT 1;
>


-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to