From: Dave Howell <groups.2009a@...>
Date: 2010-06-05T15:39:59+09:00
Subject: Re: Looking for ORM for 'legacy' database.


On Jun 4, 2010, at 20:36 , Jack Christensen wrote:
> 
> Migrations can be very useful even if you are doing PostgreSQL specific DDL (which I am). You can just call execute in the migration with an SQL string. It's nice to keep changes to app code and data schema version controlled together.

I don't understand what you're saying here. I can call 'execute' ? Call it with what? 

I did mention, I believe, that under no circumstances will any external apps, Ruby included, have any write privileges to Postgres's schema.

> I think you are referring to schema.rb. You can change environment.rb to dump to SQL for its schema definitions.

Yup, did that right away. 
> 
>  config.active_record.schema_format = :sql
> 
> I don't think ActiveRecord itself should have a problem with PostgreSQL custom data types. It should just treat them as strings.

It didn't. it failed to generate them. These are UUIDs coming from the OSSP-UUID library. 

>> 
> It sounds like you really want a minimal ORM layer that mostly just stays out of the way. Probably Sequel would be a good place to start looking.

Thanks.