MySQL parameterization in Ruby

Question

Is there any MySQL library for Ruby that supports parameterization? The documentation for mysql2 gives this example:

escaped = client.escape("gi'thu\"bbe\0r's")
results = client.query("SELECT * FROM users WHERE group='#{escaped}'")

And that seems kind of clunky and screw-up-able to me.

emboss · Accepted Answer · 2011-08-25 02:11:07Z

3

Sequel does, too. But for MySQL it only simulates them:

The MySQL ruby driver does not support bound variables, so the bound variable methods fall back to string interpolation.

answered Aug 25, 2011 at 2:11

emboss

39.7k7 gold badges103 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mchl · Accepted Answer · 2011-08-24 22:39:23Z

3

answered Aug 24, 2011 at 22:39

Mchl

62.4k9 gold badges121 silver badges121 bronze badges