ClojureQL - 1.0.0 now in beta

Re:ClojureQL - 1.0.0 now in beta by swannodette on Thursday November 18, 2010 @07:02PM (#1919863)

But your missing the point. You can store parts of queries and reuse them, recombine them however you see fit:

  (def users (cql/table db :users))
  (def photos (cql/table db :photos))

  (def users-and-photos
     (cql/join users photos
               (cql/where (= :users.id :photos.user_id))))
  
  (def photo-titles
     (-> users-and-photos
         (cql/project #{:photos.title})))

Note that my queries just keep getting smaller and smaller ;) By writing the mundane portions of your SQL queries again and again by hand you will have more duplication.

[ Parent | on HN ]

Re:ClojureQL - 1.0.0 now in beta by andreas_bak on Thursday November 18, 2010 @07:16PM (#1919902)

Yes I agree. But, I believe that it is just a perversion. In any project that involves RDBMS writing queries is just a small part of development. Surely you could modify queries with Clojure-QL (with SQL it will be a suicide) but what you gain from it ??? (more free time - I don't think so). Furthermore, having such dynamic "meta-"things in your code, eventually will cost you more time in debugging it.

With SQL it is straight-forward: you prototype your query using some GUI client and then you just embed it in your program. How it can be done with Clojure-QL ?

[ Parent | on HN ]