Is the Rubymine mysql database internal to Rubymine?

This is no doubt a dumb sounding question, but I don't know how this works.


When you selected mysql as the default database, is this some kind of an 'internal mysql' version for RubyMine?  When I externally jump to my version of mysql 5.0.77, none of the RubyMine mysql databases are visible.  All of the RubyMine databases and code are working fine, in version 824. (Yes, I just downloaded the latest version and will try that).

How does this work?  I'm trying to avoid learning everything about mysql, but have worked with databases for years.  Can someone let me know the difference between a standard mysql setup, and the one that RubyMine provides?

7 comments
Comment actions Permalink

Hello DChild,

When you selected mysql as the default database, is this some kind of an 'internal mysql' version for RubyMine?

RubyMine offers user to select database used for Rails applicataion. It allows Rails to generate config/database.yml and some other stuff corresponding to selected database.
RubyMine doesn't have any built-in database engine.

When I externally jump to my version of mysql 5.0.77, none of the RubyMine mysql databases are visible.  All of the RubyMine databases and code are working fine, in version 824. (Yes, I just downloaded the latest version and will try that).

What do you mean "none of the RubyMine mysql databases are visible?"

Wbr,
Oleg

0
Comment actions Permalink

>>RubyMine doesn't have any built-in database engine.<<

Are you saying that it's just a simulated database?  That mysql is not really being used?


>>What do you mean "none of the RubyMine mysql databases are visible?"<<

In the class that I'm taking, the mysql database is called restaurant.  In RubyMine, there's apparently the Development version of restaurant, and the Production version.  But if, external to RubyMine, I run the MysqlShow command line, it shows only Ruby's internal database information_schema, and test.  The MysqlShow command line doesn't show the restaurant database.

My question is whether the restaurant database, configured in RubyMine, is a real mysql database, and if it can be viewed from the standard Ruby tools and third-party tools (like Altova DatabaseSpy or a specialized mysql editor).  Or is the RubyMine database a simulated database, i.e., not really a mysql database?



Regards,

0
Comment actions Permalink

Hello,

Are you saying that it's just a simulated database?  That mysql is not really being used?

RubyMine has nothing to do with databases used with Ruby On Rails. It just helps you to create rails application sceleton im more convient way than running corresponding command in command line.

What do you mean "none of the RubyMine mysql databases are visible?"

In the class that I'm taking, the mysql database is called restaurant. In RubyMine, there's apparently the Development version of restaurant, and the Production version.  But if, external to RubyMine, I run the MysqlShow command line, it shows only Ruby's internal database information_schema, and test.  The MysqlShow command line doesn't show the restaurant database.

My question is whether the restaurant database, configured in RubyMine, is a real mysql database, and if it can be viewed from the standard Ruby tools and third-party tools (like Altova DatabaseSpy or a specialized mysql editor).  Or is the RubyMine database a simulated database, i.e., not really a mysql database?

Unfortunally RubyMine 1.0 doesn't have any builtin database configuration tools, probably we'll add them in future versions,

so you should manually create databases described in config/database.yml.

Hope this helps,

Oleg

0
Comment actions Permalink

Hi DChild,

My question is whether the restaurant database, configured in RubyMine, is a real mysql database, and if it can be viewed from the standard Ruby tools and third-party tools (like Altova DatabaseSpy or a specialized mysql editor).  Or is the RubyMine database a simulated database, i.e., not really a mysql database?

Yes, it real mysql database.

DChild, if you just wrote database name in "database.yml"  ruby, rails or RubyMine will not created real database. This is just description of configuration. You should create database manually using mysql tools (e.g. mysqladmin, etc.) or rake tasks "db:create:all"(for all 3 databases) or "db:create"(only for development db). Only after it your rails application will be able to use database described in "config/database.yml" and other tools will show your database in mysql.

0
Comment actions Permalink

>>You should create database manually using mysql tools (e.g. mysqladmin, etc.) or rake tasks "db:create:all"(for all 3 databases) or "db:create"(only for development db).<<

Yep, I did that weeks ago, and the Ruby code has been running fine.  I've been able to add records to the table, view them afterwards.

Hmmm.  Not sure why the databases aren't showing up on the Ruby command line.


Ok, thanks Roman, I'll figure it out.  It's probably something simple and obvious.



Regards,

0
Comment actions Permalink

Also may be you have several mysql servers installed on your computer. E.g. Instant Rails with bundled mysql and stand alone mysql server. Do you use the same username in database.yml ("root" by default) and your Mysql db viewer?

0
Comment actions Permalink

>>Also may be you have several mysql servers installed on your computer. E.g. Instant Rails with bundled mysql and stand alone mysql server. Do you use the same username in database.yml ("root" by default) and your Mysql db viewer?<<

"root" is the missing piece.  I was able to view all of the RubyMine-defined tables, from an external browser, using the root user.  Problem solved, thank you sir.



Regards,

0

Please sign in to leave a comment.