Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Databases and tied hashes.

by chorg (Monk)
on Feb 11, 2001 at 23:26 UTC ( #57763=note: print w/ replies, xml ) Need Help??


in reply to Databases and tied hashes.

All good points, but why even worry about it? Grab MySQL, take 20 min and install it, use the DBI, and then your system will be good up to about 1-2 million records (Use Postgres for more) _plus_ no locking worries about your data. It'll take the same amount to time to install the latest Berkley DBM. Your talking about expansion - and using a web server to handle access to your data , and dont forget about generating reports based on the nature of your data, adding and deleting records, type safety etc. If your are unfamiliar with SQL, the time to get aquainted is now, as opposed to when there are 200 000 records in your dbm.
_______________________________________________
"Intelligence is a tool used achieve goals, however goals are not always chosen wisely..."


Comment on Re: Databases and tied hashes.
Re: Re: Databases and tied hashes.
by arhuman (Vicar) on Feb 11, 2001 at 23:46 UTC
    Using MySql at work, I just want to warn you about some weakness :

    Error logging. It's especially difficult to know what wen wrong during an import.
    Advanced SQL order. some useful features like sub-select are lacking in my version (not the latest although).
    crash. unexpected RARE crash of the server occurs sometimes, with no data-loss/corruption, just restart the server and it's ok (I've read on the net that other site had similar behaviour)

    BUT

    Mysql is amazilgly FAST and easy to setup !(nothing compare to ORACLE or even Postgres...)
    The Perl DBI interface to Mysql is simple and powerful (BTW shouldn't we state that any sentence with Perl and easy is a pleonasm ? ;-)
      I hear you about lack of advanced SQL commands in the earlier versions - I was using it at work as well - when I started, I did not miss/know about subselects and the like, but when I was looking at a 7 line query to make a reports page, I realized that I really needed all those features - hence Postgresql... I still love MySQL though - I'll check the newest verson - if it has the features I need then I'm comin' home!!!
      _______________________________________________
      "Intelligence is a tool used achieve goals, however goals are not always chosen wisely..."

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://57763]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (17)
As of 2014-10-23 14:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (125 votes), past polls