Hi Drake, Thanks for your comments, much appreciated.
I will look into your concerns below, thanks. To me it seems like a perfect match, one could even break it up into "one .db file per message queue"...very nice and easy to use. I already have a message queue implementation in Python that uses SQLite but now I am wanting to re-write the "python API" in pure C. BTW: What is WAL mode? Also what is the "worst that can happen" with regard to: "...rollback journal activity multiplying the number of synchronized writes. " Thanks again Lynton -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Drake Wilson Sent: 30 September 2010 11:51 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE? Quoth Lynton Grice <lynton.gr...@logosworld.com>, on 2010-09-30 10:11:54 +0200: > Bottomline: We have one writer and multiple readers per queue....fine. > > Then I scratch my head and wonder why SQLite is not the PERFECT persistence > layer for building an awesome "file based queue" on? It is lightening fast > by default, and also has the same "locking issues" described above. We are > talking milliseconds anyway....between writes.... > > Bottomline: Is there any reason why anyone would think someone like me > coding a solid message queue using SQLite is a bad idea? I don't think it would be a bad idea per se, but I'm not sure it would gain you much over other approaches. It would certainly be simple! If you're going for high performance, I would be a little wary of rollback journal activity multiplying the number of synchronized writes. WAL mode would help with that, but it would increase the underlying complexity WRT filesystem and shared memory accesses. ---> Drake Wilson _______________________________________________ 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
