Korma, my new SQL DSL hits the shelves

[Chris Granger]

Hey Folks, 

I get asked a lot about what SQL solution people should use with Noir and as I've lately had issues with the ones that are out there myself, I decided it was time I got to it.

Check out the project site here: http://sqlkorma.com

HackerNews thread here: http://news.ycombinator.com/item?id=3188609 

Happy website building :D

Cheers, 
Chris.

[clojure-newbie]

Looks great !

How would you say it compares with Clojure-QL ? Any reason you decided to build your own instead of using that library ?

[faenvie]

the discussion targets some question-marks in my head.

some quotes:

"Korma was actually designed to be used to do exactly that: write SQL.
You don't have to use any of the ORM-y features and you're essentially
just writing SQL in a lisp syntax. The advantage, as others have said,
is simply composability, which leads to reusable SQL parts."

"Just do the analysis to see if this can benefit you, instead of
avoiding SQL by default just because it's SQL."


will it be possible to cover SQL92 syntax with Korma ?

even if that's possible, there should be support to execute raw
sql-statements because of the countless rdbms specialties.

thanks for the making.

[Chris Granger]

I think it'll cover a lot of it, but I'm not sure it will cover all.

You can already drop down to pure sql: http://sqlkorma.com/api/0.2.0/korma.core-api.html#korma.core/exec-raw

Cheers,
Chris.