Commit data in sqlite3 python

Question

Hi I have this silly question, but I want to be sure. I have created a database based on sqlite3. I trigger the commit() after 1000k operations so I will not have too much disk I/O. When I seek data on the database, will the select query search only in the database file or will it check the uncommited data too ?

Thanks.

possible duplicate of in sqlite3, can a select succeed within a transaction of insert? — Maxime Lorant
– Maxime Lorant, Commented May 18, 2014 at 12:30
stackoverflow.com/a/376799/705086 to be precise though, on the same connection you see uncomitted data. on another connection you don't, which is why another process doesn't see it either. — Dima Tisnek
– Dima Tisnek, Commented May 18, 2014 at 17:45

CL. · Accepted Answer · 2014-05-18 12:31:22Z

1

Transactions allow isolation and atomicty regarding other users of the database. Any changes you make are visible in your own connection immediately.

answered May 18, 2014 at 12:31

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bill Over a year ago

So uncommited data are visible inside my program . In case that the database is public others won't see those data , right ?

Larry Lustig Over a year ago

While they won't be visible to other programs using the database, they will only be visible to your program inside the same connection that issued the INSERT statements. Other simultaneous connections in your own program won't see the data. Not a problem if you're using only a single database connection but potentially confusing if you are using multiple connections.

Larry Lustig · Accepted Answer · 2014-05-18 12:33:27Z

0

If you are using the same SQLite connection for reading as you are for writing the database, then the effects of the writing will be visible to the reader, as expected.

If you are using different connections -- even within a single thread -- for reading and writing, the reader will not see uncommitted writes to the database unless you go to rather significant lengths to allow it to do so.

answered May 18, 2014 at 12:33

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Collectives™ on Stack Overflow

Commit data in sqlite3 python

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related