> > 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 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.
>
Since this sounds like it's been done before, can you direct me to tutorial or
how-to on the subject? (SQL newbie here...)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
