Allen Fowler wrote: > I have several CGI and cron scripts and that I would like coordinate via a > "First In > / First Out" style buffer. That is, some processes are adding work > units, and some take the oldest and start work on them. > > Could SQLite be used for this? > > It would seem very complex to use SQL for just a FIFO, but then again, SQLite > would take acre of all ACID / concurrency issues. > > Has this been done before? > > You can use simple triggers to manage a fifo in a table.
See http://www.mail-archive.com/sqlite-users@sqlite.org/msg12121.html for an example. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users