-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/20/2011 06:23 PM, Jay A. Kreibich wrote: > On Sun, Feb 20, 2011 at 05:23:09PM -0800, Roger Binns scratched on the wall: >> If you want to use SQL then use Postfix. > > I might suggest PostgreSQL instead. > (Sorry, Roger, I couldn't resist.)
Yeah, long night :-) However, technically SQL over SMTP is possible and would actually work. And if anyone is insane enough to try that then using Postfix and Postgres are a good combination. >> If you need lots of processes on the network to access data quickly then >> consider memcached. > > More seriously, in this category you might also consider Redis. > Redis allows your data to have some structure, The Python binding pylibmc does structure the data for you automagically. > plus it has the > ability to persist the data to disk. The moment you talk about persistence you then have significant overlap with databases. My personal favourite is MongoDB but there are loads of others such as Cassandra, HBase, Tokyo Cabinet etc. I like the ones that don't have a schema the best. > I've been playing around with connecting SQLite virtual tables to > a Redis server, and it is producing some interesting results. A while back I implemented a virtual table that talks to CouchDB. I suspect you'll have similar issues. You may find the documentation of interest as you'll likely encounter similar issues. http://apidoc.apsw.googlecode.com/hg/couchdb.html What programming language are you using to implement the virtual tables? Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1h6+wACgkQmOOfHg372QT/DACfQFOCo/Ku/kHXZGQ0eiXqWDcJ XQwAnRaBR8/uNgSKNBKXKiG5i/y7G1wm =1v5a -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users