Useful MySQL Routines

[Lawrence D'Oliveiro]

I've done a writeup on some of the basic routines I frequently use here
<http://codecodex.com/wiki/index.php?title=Useful_MySQL_Routines>.

 

[Tino Wildenhain]

I've done a writeup on some of the basic routines I frequently use here
<http://codecodex.com/wiki/index.php?title=Useful_MySQL_Routines>.

Why is that specific to mysql?

Btw, the bulkinserter could be better done by using executemany
and select usefull batch sizes. If you allow query construnction
better don't forget appropriate quoting of table- and column names
too to be on the safe side.

Regards
Tino

 

[Lawrence D'Oliveiro]

Why is that specific to mysql?

Because that's all I've used so far. Though sqlite looks interesting for
single-user stuff...

Btw, the bulkinserter could be better done by using executemany
and select usefull batch sizes.

Hmm, I've never bothered with executemany. The code as written copes
comfortably with 10,000 records or so.

If you allow query construnction
better don't forget appropriate quoting of table- and column names
too to be on the safe side.

Hmm, I never worried about that, because I was I tried to be careful in the
names I chose. And I've never allowed object names to come from user input
.

Besides, how do you deal with characters that are still illegal when quoted
<http://dev.mysql.com/doc/refman/5.0/en/identifiers.html>?

 

[Tino Wildenhain]

Because that's all I've used so far. Though sqlite looks interesting for
single-user stuff...

There are other more powerfull free alternatives to MySQL as well

Hmm, I've never bothered with executemany. The code as written copes
comfortably with 10,000 records or so.

Would be interesting to see the difference. However executemany
would be much more portable - and as I see it transfers at least
a bit less data over the wire.

Hmm, I never worried about that, because I was I tried to be careful in the
names I chose. And I've never allowed object names to come from user input
.

Not you, but if others use it, it might be that they don't see a problem
and then - oops

Besides, how do you deal with characters that are still illegal when quoted
<http://dev.mysql.com/doc/refman/5.0/en/identifiers.html>?

Don't know. I personally avoid dealing with mysql altogether (I mean,
commands hidden in sql comments? Heaven!

Cheers
Tino

 

[Lawrence D'Oliveiro]

Would be interesting to see the difference.

Go on, give it a try and let us know how it goes.