Re: lisp mail archive software

On Sun, 2003-07-06 at 11:39, Sven Van Caekenberghe wrote:
> On Sunday, July 6, 2003, at 07:19 PM, Miles Egan wrote:
> 
> > I haven't really thought very hard about this yet but I was leaning
> > towards using Eric Marsden's PG postgresql library. The cool thing 
> > about
> > PG is that it speaks PG's network protocol directly and doesn't require
> > FFI bindings.
> 
> I have good experiences using this code: it works well (as well as 
> fast), doesn't need FFI and the implementation is quite readable and 
> understandable (I made a couple of changes to it).

Good to know.  I definitely like the approach.  Do you know offhand if
it supports autoincrement fields the way the native client libs do?  I
think the native libs let you execute a special select after inserting a
new row with an autoincrement key.  The client libs supposedly retain
this as a per-thread value.

> > I'd like to avoid using a database at all if possible but the more I
> > think about the more it seems like I'd have to implement enough of one
> > by hand that I might as well just accept it.
> 
> Then maybe you should have a look at Object Prevalence, I did a proof 
> of concept implementation for common lisp ( 
> http://homepage.mac.com/svc/prevalence ). I am currently doing a 'real' 
> project where I will be using my Common Lisp Prevalence code - so I 
> might still change.

I've actually considered this too.  I'm a bit concerned that the memory
requirements for this application might be a bit too steep to do this. 
I want to be able to support mailboxes of over 200 MB and I'll probably
be running this on servers with ~ 512 MB of ram.  Still, I might be able
to find a way to make this work.  I'll have a look.  I definitely like
the idea.

miles

_______________________________________________
Clump mailing list
[email protected]
http://manly.caddr.com/mailman/listinfo/clump

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQA/CHPAU4Jq/wH1PVERAscvAKCtIa3j1hg/C4gZ6Pvnc2zq06GzaQCg8Llt
Hpc1lbDUg0DarNUoDphGNk8=
=78OJ
-----END PGP SIGNATURE-----