I’m very new to Rails and I’m trying, if only for a proof of concept, to
develop a quick Rails application to display data from a database. The
application will be read only (SELECT statements only) and will simply
list data. However, the table structure and schema I have no control
It basically breaks down into to tables that both contain attribute
data. Values that can be repeated are in a table with an _r at the end
and values that are always single are in a table with a _s at the end.
The tables have a unique identifier row but it is not sequential, and is
not an autonumber. The data will be routinly updated by an external
process that will not be related in any way to the rails application.
Here is an idea I had, please let me know if you think it would work.
Point rails to a temporary table or view in Oracle.
Update this table or view by using a trigger anytime a modification
to the original table takes place.
Also, I could use some pointers to information on how to manage these
types of scenarios because if I can do this once I’m sure I will be
called on to do it again.