You should be able to implement a classic circular buffer in SQL and make it a VIEW for easy access. ROWIDs can be the buffer pointers and a second table can store the current values.
Allen Fowler wrote: > Hello, > > 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? > > Thanks, > :) > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users