Victor Lin schreef: > Now I am now developing a program that base on sqlite3 in python. > But there is a strange problem. > That is, all data I insert into sqlite database do not goes into file > in disk. > It is really strange.... > Why do these data just keep in memory and discarded?
sqlite3 works according to PEP 249, which means among other things that transactions are by default not auto-committed. There are two possible solutions: - manually commit the transaction when it's finished with db.commit() (perhaps the cursor object also has a commit() method; I'm not sure about that) - enable auto-commit. For more info, see the sqlite3 docs (especially the section on controlling transactions: http://docs.python.org/lib/sqlite3-Controlling-Transactions.html) and PEP 249 (http://www.python.org/dev/peps/pep-0249/) -- The saddest aspect of life right now is that science gathers knowledge faster than society gathers wisdom. -- Isaac Asimov Roel Schroeven -- http://mail.python.org/mailman/listinfo/python-list
