Case-blinding db table and column names


#1

I’m looking for the cleanest way to force the Rails framework to use a
lower-case version of the table and column names in a database when
creating records.

I need this for a Rails application that displays the status of an
existing backup system. The backup system (Bacula; Nice backup
system, BTW) can use either Postgres or Mysql as its database engine.
Unfortunately, the table and column names are created in all lower
case when using Postgres, and in StudlyCaps when using Mysql. I’d
like my application to be able to work against either database type
without having to modify the capitalization of all the table and
column names in the application code.

– John Kodis.