which db should I use?

[Jim Richardson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 13 May 2002 00:09:01 -0400,
 Peter Hansen <peter at engcorp.com> wrote:
> Jim Richardson wrote:
>> 
>> I have a project that I want to do with python. It involves a database
> 
> It's unclear even after your description why you want to use a 
> relational database.  Is it simply because that's part of the 
> learning experience you've set for yourself, or are there particular
> performance requirements or a need for relational operations?
> 

probably because I am a clewless newbie and don't know any other options
:) What is available that isn't relational?

>> table with  some 100,000 rows, total size about 400MB and climbing. I
>> will be adding about 700 rows a day, and occasionally want to do a
>> query, but only occasionally. (I am putting all the posts from an active
>> newsgroup in to a db for data gathering, 
> 
> Why not just store them as files in the file system?

searches are really slow with grep, on an ext3 filesystem. I wouldn't
mind a file based system, but will probably go with a db system in order
to learn more about SQL


> 
>> and to learn python and sql stuff) 
> 
> Well, okay, if it's just to learn SQL.  But you might find better
> types of data for that purpose.
> 
> Just my thoughts on the matter...
> 
> -Peter


Well, probably better data out there, but this gets two birds with one
stone. 

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

iD8DBQE832Xwd90bcYOAWPYRAmJlAJ9XZxBpUQRq4lqWyzWIoPQX6zM9UwCfTVsa
v6pRJRFCiIZB9J1DTbos2TA=
=p+yY
-----END PGP SIGNATURE-----

-- 
Jim Richardson
	Anarchist, pagan and proud of it
http://www.eskimo.com/~warlock
Linux, from watches to supercomputers, for grandmas and geeks.