Re: [sqlite] SQLite as a IPC mechanism

2008-01-16 Thread Roger Binns
Joshua D. Boyd wrote: I have a system that currently consists of 2 C programs and 3 python programs. Currently the python programs transfer data between themselves via pickles. The C programs transfer data between themselves via streaming structs, and the C programs talk to one of the python

[sqlite] SQLite as a IPC mechanism

2008-01-15 Thread Joshua D. Boyd
I have a system that currently consists of 2 C programs and 3 python programs. Currently the python programs transfer data between themselves via pickles. The C programs transfer data between themselves via streaming structs, and the C programs talk to one of the python programs via a fairly

Re: [sqlite] SQLite as a IPC mechanism

2008-01-15 Thread Clay Dowling
Seems like it would work, but maybe overkill. What's stopping you from working out a fairly direct protocol to exchange data with? Sending key, type, val for all of your IPC seems reasonable. A mem-mapped file, a local socket or a network socket seem reasonable, depending on the structure of

Re: [sqlite] SQLite as a IPC mechanism

2008-01-15 Thread Ken
Joshua, I don't think sqlite was designed to be used that way. It would work very well for your persistent data, that is written to disk. However, not so well using it as an IPC. The database is locked, not the table, row or even page. The entire DB is locked when you write (insert, update or