title: SQLAlchemy, sqlite and fork()
body: <p>What is the best way to use <code>fork()</code> in a <em>SQLAlchemy</em> + <em>sqlite</em> project?</p>
  
  <p>The <em>SQLAlchemy</em> documentation <a href="http://www.sqlalchemy.org/docs/core/connections.html" rel="nofollow">mentions</a> that one should call <code>create_engine()</code> in the child but doesn't mention any other caveats, of which I am sure there are plenty (write locks, busy_timeout, dispose/connection-issues, etc).</p>
  
  <p>Would the design issue of whether to use transactions or scoped sessions matter?</p>