Re: [sqlite] internals. IPC or disk write based?

2013-01-24 Thread Patrick
You stated off by making some assumptions which would normally be correct, but are not valid for SQLite. Your last two paragraphs suggest you realized what was really happening. There is no persistent SQLite Server process, accepting requests from many users. SQLite has no multi-user model

Re: [sqlite] internals. IPC or disk write based?

2013-01-24 Thread Simon Slavin
On 24 Jan 2013, at 2:41pm, Patrick wrote: > I bought the Apress book. There is a chapter on internals. I have tried to > read what I could find on the net too but I am still mixed up about something. > > I don't know how sqlite interacts with visitors while

[sqlite] internals. IPC or disk write based?

2013-01-24 Thread Patrick
Hi Everyone I bought the Apress book. There is a chapter on internals. I have tried to read what I could find on the net too but I am still mixed up about something. I don't know how sqlite interacts with visitors while maintaining state. If everything was read into memory it would be easy