MySQL connexion
-
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 -
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.)
-
@inteloide said:
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
Advertisement