MySQL connexion

inteloide

Hello !

Is there any way to link Sketchup to a MySQL database in pure ruby ?

I look for in history of posts, I only see answers from years now, and I guess new version of Sketchup (with ruby core update) can do it more easily.

I know that I can link through javascript/php code. I wonder if a pure ruby code can be simply written to do so.

This may required installation of Gem and DevKit, but please if somebody can explain step by step how to proceed, it would help me a lot !

Thank you for your help.
Best regards.
Inteloide

Dan Rathbun

Whoops,.. (3) above was incorrect.

Should be Gem::install "dbi"
... not "ruby-dbi"

[Corrected that post.]

Also.. have sent corrected URLs to the website hosting the DBI tutorial:
http://www.tutorialspoint.com/ruby/ruby_database_access.htm

(Received a reply back promising corrections.)

Dan Rathbun

Is there any way to link Sketchup to a MySQL database in pure ruby ?

(1) I believe, You or whomever runs the Server still need to install MySQL:
http://dev.mysql.com/downloads/windows/installer/

From Ruby Console:

(2) Gem::install "ruby-mysql"
(Pure-Ruby edition - C edition is "mysql" gem.)
source: https://github.com/tmtm/ruby-mysql
gem: https://rubygems.org/gems/ruby-mysql
doc: http://www.rubydoc.info/gems/mysql/

(3) Gem::install "dbi"
gem: https://rubygems.org/gems/dbi
doc: http://www.rubydoc.info/gems/dbi

(4) Gem::install "ruby-odbc"
gem: https://rubygems.org/gems/ruby-odbc
doc: http://www.rubydoc.info/gems/ruby-odbc