IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / Database is excellent IPC mechanism
Post #191,928
by tuberculosis
Picture of tuberculosis
1/27/05 9:40:05 AM
Reply
New Database is excellent IPC mechanism
for certain apps.

Consider a workflow management system. Basic architecture communication style is blackboard - shared data store with each module looking at the datastore for things it can help with.

Database is great for this. Extra bonus - you get ACID semantics via the db's transaction mechanism on the cheap - thus avoiding the need for external transaction managers ala j2ee.

Communication is via polling task tables via regular intervals.

Works really well. It is not highly responsive (polling intervals introduce latency), but it is highly reliable and allows graceful degredation when some participating processes are down.


"Whenever you find you are on the side of the majority, it is time to pause and reflect"   --Mark Twain

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."   --Albert Einstein

"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses."   --George W. Bush
Post #191,952
by FuManChu
Picture of FuManChu
1/27/05 11:50:14 AM
Reply
New It's almost the *only* IPC mechanism for PHP ;)
Web-based PHP persistence, that is.
Post #191,984
by pwhysall
Picture of pwhysall
1/27/05 2:05:35 PM
Reply
New Never thought of it that way...
...probably because the traffic management systems I deal with have short timeouts and periodic requirements to internally exchange lots of data on a tight deadline (i.e. before the RS485 connection RTS/CTS timeout drops the line and necessitates re-negotiation).

Peter
[link|http://www.ubuntulinux.org|Ubuntu Linux]
[link|http://www.kuro5hin.org|There is no K5 Cabal]
[link|http://guildenstern.dyndns.org|Home]
Use P2P for legitimate purposes!
     Database is excellent IPC mechanism - (tuberculosis) - (2) - Jan. 27, 2005, 09:40:05 AM EST
         It's almost the *only* IPC mechanism for PHP ;) - (FuManChu) - Jan. 27, 2005, 11:50:14 AM EST
         Never thought of it that way... - (pwhysall) - Jan. 27, 2005, 02:05:35 PM EST

Write that down!
81 ms