Hello.
I am looking to switch a massive Rails application from MySQL and Postgres to Oracle, and would appreciate some input and ideas about best practices from anyone using Oracle with Rails.
- how well does ActiveRecord play with Oracle? version 4
- any other gems I should look at?
- what is the best way to import structure and data into Oracle? I have some 400M rows in total across all databases and tables.
Last but not least, I know this might not be the right place to discuss this aspect, but is there a way to set up a trigger and get a notification on a row insert/update/delete, pretty much like postgres' NOTIFY ?
Thank you so much and have a lovely week-end!
Andrei