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

Re^3: [OT] Why I don't use Mysql for new projects

by perrin (Chancellor)
on Jul 10, 2008 at 17:57 UTC ( [id://696767]=note: print w/replies, xml ) Need Help??


in reply to Re^2: [OT] Why I don't use Mysql for new projects
in thread [OT] Why I don't use Mysql for new projects

It can be changed on the client, but the default is set on the server. Someone would have to intentionally change it in order to have this problem. If a malicious user has access to your database, changing the SQL mode is the least of your worries.

Replies are listed 'Best First'.
Re^4: [OT] Why I don't use Mysql for new projects
by Mutant (Priest) on Jul 10, 2008 at 18:06 UTC

    It still means you have to be wary about who/what you give access to the DB. For some (most?) apps you'd do that anyway, but others might benefit from a more open policy. What if someone has a legacy app build for 4.x ... the quickest way to get it working is just to set the mode to "traditional". It might be a minor thing, but it's something you simply won't have to worry about with Postgres. (Unless there's a way to disable a mode completely on the server, in which case ignore me :)

      It still means you have to be wary about who/what you give access to the DB.

      I can't believe anyone would seriously give out write access to their shared database to non-trusted users, and if they did, they'd deserve whatever they get.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2024-03-19 09:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found