Topic: Building an app - Advice wanted!

Our company has a database (Open Edge) with about 250 tables that are not named in the 'rails' way.  I would like to build a web based reporting system.
How would I go about retrieving data from these tables and displaying in web pages?
Do I need to build a model for each or can I just query the tables from the controller?

I may just use php as it may be easier???

Any advice would be greatly appreciated.

Re: Building an app - Advice wanted!

You can do an SQL query on the tables directly (without a model) like this:

ActiveRecord::Base.connection.execute('SELECT ...')

You lose many benefits of Rails when bypassing models like this, so many that I think PHP may be a better solution (if the site is on the smaller side).

Railscasts - Free Ruby on Rails Screencasts

Re: Building an app - Advice wanted!

Cheers. 
Could I build a model/create associations for each table that I needed to query?

Re: Building an app - Advice wanted!

You can manually create a model for each table, or do you mean automatically?

Railscasts - Free Ruby on Rails Screencasts

Re: Building an app - Advice wanted!

while ActiveRecord does a lot of naming and relation tasks automatically, all of them can be overridden.  That only leaves the question of a database connector.  I've not heard of Open Edge before.  If they have a C API, you could create an ActiveRecord database connector, but it may not be trivial.

BrewControl.com - Brewery and Brewpub management powered by RoR