Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

You may also want to look at libjlog https://labs.omniti.com/labs/jlog enjoy, -jeremy On Thu, Sep 30, 2010 at 10:11:54AM +0200, Lynton Grice wrote: > Hi there, > > > > I am a HUGE SQLite fan and have an interesting question I have been > scratching my head about for a couple days now. > >

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

I've used SQLite for exactly this. I have no gripes with it at all. I ended up using just one table in one DB as indexing makes things simple and fast. WAL i've been trying these last few days and seems trouble-free. ___ sqlite-users mailing list

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

al Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrew Davison Sent: 01 October 2010 12:43 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE? I've used SQLite for exactly this. I have

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

I've used SQLite for exactly this. I have no gripes with it at all. I ended up using just one table in one DB as indexing makes things simple and fast and I support arbitrary queues with multiple readers. WAL i've been trying these last few days and seems trouble-free. On 30/09/2010 6:11 PM,

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Database Subject: Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE? Quoth Lynton Grice <lynton.gr...@logosworld.com>, on 2010-09-30 12:05:18 +0200: > BTW: What is WAL WAL mode uses a write-ahead log instead of a rollback journal, which can help reduce write activity but require

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Quoth Lynton Grice , on 2010-09-30 12:05:18 +0200: > BTW: What is WAL WAL mode uses a write-ahead log instead of a rollback journal, which can help reduce write activity but requires the use of shared memory to keep things consistent between database handles. If I

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

-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 <lyn

Re: [sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Quoth Lynton Grice , on 2010-09-30 10:11:54 +0200: > Bottomline: We have one writer and multiple readers per queuefine. > > 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

[sqlite] SQLite is perfect for FILE based MESSAGE QUEUE?

Hi there, I am a HUGE SQLite fan and have an interesting question I have been scratching my head about for a couple days now. First off my daily job is very much around "messaging" and I am very familiar with message queue products like Websphere MQ and Fiorano MQ. When you install