Text Database or DBM FILE 3

[perlone]

If you're gonna hold more than 30,000 records, which database is right for you? Also I heard that DBM Files has limited space storage. Is this true?

-Aaron

 

[stillflame]

although goBoating or someone will likely elaborate on this much more, yes flatfile databases have a limited effecient storage capacity. 30,000 records sounds like it's probly above this capacity. i would definitely suggest using a better database - mySQL, Postgre, mSQL, Oracle, &c. i can't really recomend any of those over each other, but for just starting, you could give mySQL a try, as it's free to use.

HTH "If you think you're too small to make a difference, try spending a night in a closed tent with a mosquito."

 

[perlone]

I like to learn MySQL but is there any site i could download it or you can just use in your perl script? I went to mysql.com and it's just confusing since they have millions of files. Is there any recommended file that i should download? Thanks again for responding...

 

[stillflame]

http://www.mysql.com/downloads/mysql-3.23.html

is the latest stable version. select your os from the 'standard binary (tarball) distributions:' list and that's the download link...
good luck "If you think you're too small to make a difference, try spending a night in a closed tent with a mosquito."

 

[perlone]

Thanks again. I'll let you know how it goes

 

[goBoating]

I agree that 30,000 records will likely be well beyond what you would want to do with flat file(s). I also suggest MySQL. This may be a lot to take on, if you have never done any of it before. However, everyone who is doing it now started somewhere. It is free and fairly easy to learn. You will need to learn some 'SQL' and check out some MySQL tutorials.

Try,

http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

or,

http://www.devshed.com/Server_Side/MySQL/Intro/

or,

http://docs.serendipity.org.za/db/mysql.html

' just a few quickly found on the web. I did not check them for completeness and such, but, they seen to hit the major points.

Also, I recommend the book 'Programming the Perl DBI' by Alligator Descartes and Tim Bunce from O'Reilly Press,

http://www.oreilly.com/catalog/perldbi/.

If you are going to play these tricks, that is a good book.

'just my $0.02 worth of concurrence


keep the rudder amid ship and beware the odd typo

 

[perlone]

Thanks, i'll try those