Re: my $.02 - ignore at will

The Berkeley DB's are basically simple key:value stores; they do *not*
have the ability to keep track of the kind of information we'll need in
non-anonymous versions of the server, thus the planned move to SQL
post-1.0.

        Python has a very nice DB API, currently at version 2.0 (IIRC).
It's quite friendly and very usable for most things, but does tie you
(somewhat) to the specific DB backend you decide to use.  (At least, in
my experience it does.)

        This of the existing shelves as the individual columns of the
future SQL tables, and you probably won't be too far off what's coming
in 1.1.x.

On Thu, 28 Feb 2002, Brian K. Jones wrote:

> Hi,
> 
> I just wanted to say that I like the idea of Current moving to what 
> they call 'Plan F' - moving to a sql database backend.  I think this 
> lends greatly to the future scalability of the project, and also 
> makes development, testing, maintenance and extensibility much easier 
> for those of us more comfortable with a sql interface than having to 
> write/alter code just to see what's going on.  
> 
> I'm very interested in this aspect of the project (design thru 
> implementation), but am at a bit of a loss right now as to where to 
> start.  It's not quite as easy as throwing up a database and start 
> writing sql.  In fact, I haven't developed in Python enough to even 
> know if it has a database abstraction layer, or database dependent 
> sql calls for each database supported.  I'll go read my books again 
> tonight :)
> 
> If anyone who has been messing with this can give me s'more insight 
> or understanding about how to get information about these Berkeley 
> DB's (which I know very little about), I can probably at least come 
> up with some sort of design spec to work from to try to seamlessly 
> replace it with one of the many sql databases.  
> 
> As for Apache/mod_python/mod_ssl(?), someone more hardcore than me 
> will have to tackle that.  I administer this stuff as part of my job, 
> but I don't develop the stuff.  (most of my development, admittedly, 
> is in PHP, with whatever database you want).
> 
> cheers.
> brian
> -- 
> 
> Brian K. Jones
> System Administrator
> Dept. of Computer Science, Princeton University
> [email protected]
> Voice: (609) 258-6080
> _______________________________________________
> Current-server mailing list
> [email protected]
> http://lists.dulug.duke.edu/mailman/listinfo/current-server

-- 
Thank you,
John Berninger

Systems Administrator		[email protected]
Department of Mathematics	Box 8205, Harrelson Hall
NC State University		Raleigh, NC 27695
Phone:  (919)515-6315		Fax:	(919)515-3798

GPG Key ID: A8C1D45C
        Fingerprint: B1BB 90CB 5314 3113 CF22  66AE 822D 42A8 A8C1 D45C
--