# Ruby on Rails and Databases **URL:** \ **Category:** Rails\ **Created:** [October 4, 2007, 1:32am UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-databases/116276 "2007-10-04T01:32:19Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![crucoba](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@crucoba](https://www.ruby-forum.com/u/crucoba)\ **Post date:** [October 4, 2007, 1:32am UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-databases/116276/1 "2007-10-04T01:32:19Z")
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! 🙂 Many thanks! David > **[Van Couvering Is Not a Verb](http://davidvancouvering.blogspot.com)** > > Ongoing musings, tips, and observations from a Van Couvering, not someone who is going to Vancouver. ---
**Author:** ![crucoba](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@crucoba](https://www.ruby-forum.com/u/crucoba)\ **Post date:** [October 4, 2007, 4:52am UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-databases/116276/2 "2007-10-04T04:52:13Z")
Hi David On Oct 4, 7:31 am, David Van C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > 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. ---
**Author:** ![crucoba](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@crucoba](https://www.ruby-forum.com/u/crucoba)\ **Post date:** [October 4, 2007, 4:54am UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-databases/116276/3 "2007-10-04T04:54:33Z")
Hi David On Oct 4, 7:31 am, David Van C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > 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 > **[Rails... Rails... Rails](http://cch4rails.blogspot.com)** > > Chee Chong Hwa aka CCH, a Malaysian Chief Software Architect blogs on his experiences with Ruby on Rail running on Win2003 Server+Apache 2.26 environment since 2007. Flirted briefly with Ubuntu 9.04 in 2009. Since January 2017, now using RubyMine... ---
**Author:** ![crucoba](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/e8c25b/32.png) [@crucoba](https://www.ruby-forum.com/u/crucoba)\ **Post date:** [October 4, 2007, 10:08am UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-databases/116276/4 "2007-10-04T10:08:30Z")
> 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 C…