RoR: Using Yaml_db to copy Prod data/schema to Non-prod Environments

This morning, I took a snapshot of a production, Ruby on Rails database (via rake db:dump), and then applied the production / schema data to other environments.

    System information:

  • Database is Oracle 11
  • Application server runs Redhat Enterprise Linux
    Assumptions and challenges:

  • The Development and QA (Quality Assurance) instances are probably not at the same software revisions or migration version numbers. So… keep that in mind.
    Read more

Calling Ruby on Rails rake tasks through Appworx

I have a rake task “db:update_last_status”, which I need to have run on remote servers, nightly, to update cached status fields – which are used for fast search capabilities in an RoR application. The RoR application runs on Red Hat Enterprise Linux, an an Oracle database. It would be simple to script that with Cron, but that doesn’t lend itself to monitoring or work within the enterprise standards. Capistrano works great, but also isn’t within the Enterprise standards.

Read more