Hello! The weekend I was reading a book "Programming in Linux" and I found something for me very cool!. I so that you could Lock a File for write but just a part of the file. And I am wondering if in Linux SQLite would be able to lock just a Page of the B-tree when you are doing the insert and the update, that will be better I think that Lock all the File (database).
The function is in the header <fcntl.h> and the function is: int fcntl(int fd, int cmd, struct flock *lock_type); Thank you!