From: John W Higgins Date: 2010-06-05T16:17:09+09:00 Subject: Re: Looking for ORM for 'legacy' database. --000feaed64301e93110488433a70 Content-Type: text/plain; charset=ISO-8859-1 Evening Dave, On Fri, Jun 4, 2010 at 2:29 AM, Dave Howell wrote: > So far, I've found DataMapper, Friendly, M4DBI, Ohm, and Sequel as possible > alternative ORMs, but all the documentation for them is heavy with > terminology and jargon from Rails, and usually brags about how I can make > tables appear in my database magically from my Ruby objects I'm surprised you mentioned Sequel in that list because Sequel is very much non-rails based and I've not seen much mention of rails in the docs at all ( http://sequel.rubyforge.org/). I admit that the quick sample on the home page does create a table but that is much more in the sense of having a sample that is self-contained rather then forcing you to do anything at all in terms of creating the schema within Sequel. You will note that the create table call is totally non-related to later accessing the table and has nothing to do with ruby objects - it's simple a method that you can use to create a table - nothing more nothing less. I think you'll find Sequel very much to your liking with respect to the fact that it's heavily based on "datasets" ( http://sequel.rubyforge.org/rdoc/files/doc/dataset_basics_rdoc.html) which sounds like a concept that you would be rather happy with.... I would very much steer you towards website docs to see if Sequel might just meet your needs. If you had specific questions once you had a look - the Sequel mailing list/google group (http://groups.google.com/group/sequel-talk) is an excellent way to get help. Jeremy is exceptionally responsive to issues and questions and very much goes the extra mile to help folks out. Specifically with respect to UUIDs or your custom datatypes - I'm sure you would find an answer either from the docs or from Jeremy via the mailing list that will satisfy you. I'm also thinking that it would be very easy to setup a small test to see how Sequel handled your "interesting" fields. John --000feaed64301e93110488433a70--