Re: [SQLObject] Temporary databases / Closing the :memory: database connection

[Maciej (M. B. <ma...@op...>]

On Fri, Oct 18, 2013 at 01:14:46AM +0400, Oleg Broytman wrote:
>    It would be interesting to test if the problem lies in SQLite,
> PySQLite or SQLObject.

Looks like it's not SQLite, the following runs with stable memory use at
about 7MB, I ran it for about an hour:

import sqlite3
while True:
  conn = sqlite3.connect(":memory:")
  c = conn.cursor()
  c.execute('CREATE TABLE foo (bar TEXT);')
  conn.commit()
  conn.close()

At least we know that it can work. I guess the next step will be to use
a memory profiler to figure out what still holds the references but
I haven't gotten around to it yet.

Maciej