SQLite Database written on read

Question

I have been playing around with inotify and a sqlite database as I wanted to know how often the database file was written.

The thing is that the database file is written everytime I send a query. It does not matter if it is to read (SELECT) or to modify (UPDATE). The inotify flag IN_CLOSE_WRITE is always activated after that.

I wanted to avoid as much writing as possible. Am I missing anything here? Should not the database only be written when performing operations to modify it?

CL. · Accepted Answer · 2016-04-15 18:36:45Z

3

The IN_CLOSE_WRITE flag does not indicate that something was written, only that the file was openend for writing.

The database does not know whether you will write something later, so it opens the file with write access to avoid having to reopen it.

If you know you never want to write, use the SQLITE_OPEN_READONLY flag.

answered Apr 15, 2016 at 18:36

CL.

182k18 gold badges241 silver badges282 bronze badges

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

3 Comments

Nacao Over a year ago

Thanks for your answer. I found the problem that I opened all my connections with SQLITE_OPEN_READWRITE, that is why it was always opened for writing. Do you know any mechanism to know if a file was indeed written?

CL. Over a year ago

You mean, you want to know if inotify has a flag for modifications?

Nacao Over a year ago

Sorry, I just realized that I have to check the IN_MODIFY flag. It is triggered always twice though. Thanks for your help.

Collectives™ on Stack Overflow

SQLite Database written on read

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related