Pharo Smalltalk and mySql

Question

I am looking for someone who knows how to interface Pharo Smalltalk and mySql. I just want to do the basic things like "select * from names" and then read the result into Pharo.

Does anyone know anything about this? If you have a screen video that would be super and I would buy you a beer.

Answer 1

Check out DBXTalk. Mariano Peck gave a presentation on it at ESUG 2011. Here's the abstract and video. I'll take a Blue Moon, please ;-)

Answer 2

And what do I get? ;) Now, really, let us know if you have any problem. There are more videos ans slides in: http://dbxtalk.smallworks.com.ar/media/.

Your scenario is pretty simple. You will need to install the MySQL client library and OpenDBX library. If it is in linux it is easy to install and compile. In windows, you can get directly the dlls. Check because all info should be in the website.

Answer 3

there is a package originally developed by Diego Gomez Deck and meanwhile updated in Squeaksource.

Use my metacello config script to load ODBC support and start with ODBCConnection class.

For further help you can consult the (outdated) documentation.

(Source)