in reply to Would you use SQLite?
Maybe. It actually sounds like a good fit for my current major undertaking.
I'm writing a server that
listens to Cisco Netflow data, does some real-time statistics (the flows are saved for heavy-duty processing), looks for interesting developments and notifies somebody if needed. The coolest part is the client which connects to the sever over SSL, and allows you to query the current store of data. This sounds like a job for SQLite!!! The data doesn't need to be kept
for long, speed is needed to keep up with the flows, the intended audience has a better grasp of SQL than
perl (the current client part of the server is a eval $_ while(<>) type of loop), and it's read-only to boot.
Sounds like a winner to me.