CS6320:  SW Engineering of Web Based Systems

 

How to Add the built in Ruby on Rail SQLite Data Base to view tables inside RubyMine

 

Step 1: Bring up your Project in Ruby Mine

Step 2: Bring up Database Viewing tool (

Step 3: Setup a DataSource --which you can import to associate with the SQLite (using database.yml file in configuration directory of project) or set it up manually

You will get (you must have drivers for the database you are using to connect to it ---RubyMine will usually prompt you or have a link to install them if you don't have them on there)

To manually add the default SQLite3 database table so you can view

NOW open it up and see your database tables

OPTION You can select a Table and then enter in values by hand if you wish

 

Option: You can add new columns to your table also

right click on the table you want to edit and select Table Editor and you will see a window to enter in a new column name and type and options. Then you will run it and it will update the table as shown below

 

© Lynne Grewe