Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Re: Databases and tied hashes.

by arhuman (Vicar)
on Feb 11, 2001 at 23:46 UTC ( #57765=note: print w/ replies, xml ) Need Help??


in reply to Re: Databases and tied hashes.
in thread Databases and tied hashes.

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 ? ;-)


Comment on Re: Re: Databases and tied hashes.
Re: Re: Re: Databases and tied hashes.
by chorg (Monk) on Feb 12, 2001 at 01:07 UTC
    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://57765]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (16)
As of 2014-10-20 18:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (85 votes), past polls