• Login
sketchucation logo sketchucation
  • Login
⚠️ Libfredo 15.4b | Minor release with bugfixes and improvements Update

MySQL connexion

Scheduled Pinned Locked Moved Developers' Forum
3 Posts 2 Posters 342 Views 2 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    inteloide
    last edited by 9 May 2015, 09:31

    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

    Humanity will do a huge step when the IT professionals will understand that computers are tools...

    1 Reply Last reply Reply Quote 0
    • D Offline
      Dan Rathbun
      last edited by 10 May 2015, 10:57

      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.)

      I'm not here much anymore.

      1 Reply Last reply Reply Quote 0
      • D Offline
        Dan Rathbun
        last edited by 10 May 2015, 10:58

        @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

        I'm not here much anymore.

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        1 / 1
        • First post
          3/3
          Last post
        Buy SketchPlus
        Buy SUbD
        Buy WrapR
        Buy eBook
        Buy Modelur
        Buy Vertex Tools
        Buy SketchCuisine
        Buy FormFonts

        Advertisement