aisrael / cql Goto Github PK

Currently, CQL only supports PosgreSQL. It'd be good to support MySQL as well (since Crystal already has a database driver for it).

Link: https://github.com/drum445/objectify

He appears to have the low-level supports you need, while you have a unique style for the upper layers. Together you might actually produce a Sequel for Crystal. I use Sequel in Ruby extensively and the lack of something just like it is sort of making me pause. Most of the ORM guys for Crystal use a single-db driver/binding approach --> as if the world only uses ActiveRecord's approach. However, my use cases ALWAYS require multiple databases and multiple drivers at the same time. I need to sync dbs across drivers and across technologies. If I use models at all they will need to track what db they are associated with. This is no big deal really, but it needs to be factored into the ORMs architecture to support such things.

I am still new to Crystal or I'd offer to help as I would dearly love to see Sequel on Crystal. Sequel is by far THE best ORM I've ever used, and it really needs a home in Crystal. I approached the author who claimed it was 'impossible' to port it to Crystal, but I don't believe that in the slightest. I am pretty comfy with MySQL and if you establish an IRC channel or Gitter channel for this project I could certainly share what I know as I've used it for years.

Cheers, and keep going!

G.

Hello!

I see CQL::Command (with CreateTable) and I think that will be nice to have a migrations DSL, like Sequel does. Maybe in a separated shard.