Re: [pysqlite] lifetime of connection handle

Roger Binns <[email protected]> Tue, 18 Nov 2008 02:53:35 -0800
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Eric S. Johansson wrote:
> if I open a pysqlite connection in the process, then fork that process, can the
> child safely use that connection? 

Absolutely not.  SQLite does not support it in any way.  Someone on the
sqlite mailing list recently tried it.  All they did was an open in the
parent process and then called close in the child.  The close hung.

See last paragraph: http://sqlite.org/faq.html#q6

Roger

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkkinqwACgkQmOOfHg372QQtIwCgpgfsJboeP8WHSQgSUQlPlw4z
vZwAoMFP77Y3h5iEIELIKeB8wAsFJgDK
=ULCw
-----END PGP SIGNATURE-----