Ruby on Rails and Databases

Hi, all. I'm the architect for the database tooling in NetBeans, and I'd really like to learn more about what RoR developers need in terms of database tooling.

I know that a lot of database details are taken care of by the RoR framework, but perhaps there are some things you still need from an IDE.

Possible areas of improvement include database schema visualization and management, a good SQL editor for ad-hoc queries, better support for PostgreSQL and MySQL, etc. But I'm just guessing and need your help and guidance.

If you are interested and would like to help (or just tell me what for), please contact me, and we can set up a 1 hour conversation where you can educate me. This input is very valuable and you, yes you, could have a Direct Impact on what we do with databases in NetBeans! :slight_smile:

Many thanks!

David

Hi David

Hi, all. I'm the architect for the database tooling in NetBeans, and I'd really like to learn more about what RoR developers need in terms of database tooling.

I know that a lot of database details are taken care of by the RoR framework, but perhaps there are some things you still need from an IDE.

cch I agree...

Possible areas of improvement include database schema visualization and management, a good SQL editor for ad-hoc queries, better support for PostgreSQL and MySQL, etc. But I'm just guessing and need your help and guidance.

cch: I absolutely agree... I do not want to keep having to run for example MySQl Query Browser whilst I am in my IDE

I like Aptana Radrails Database Perspective approach. Simple, no configuration needed. It just works. Like 3rdRail, I still have difficulty in getting the Database stuff to work in nbrubyide hudson to work

That said, perhaps you should also post to ActiveScaffold where it is more database-focussed.

CCH

I know that a lot of database details are taken care of by the RoR framework, but perhaps there are some things you still need from an IDE.

Hi David.

As a developer i work in two ways with a database, the first and most used by me is ./script/console, i mean irb + active record + wirble, but this aproach requires a lot of tail -f log/development.log ... so a big improvement for this will be a link between commands executed in the console and the development log. Im thinking in some kind of diff like window with commands in the left panel and log entries in the right panel.

The other aproach i use is the well known database console, mostly mysql, so for me a nice SQL editor with sintax highlight and code completion will be enough.

Regards. Pablo Castellazzi.