On Oct 6, 8:39 am, nchubrich <nchubr...@gmail.com> wrote: > > So, the question is -- is SQLRat doing more or less the same thing as > > ClojureQL? Partly "yes", but mostly "no". > > Thanks Shantanu! So I suppose one way you could use them both is > simply use the SQL compilation feature of ClojureQL----you could pass > SQLRat a raw SQL query created from ClojureQL?
If you look at the Entity[1] API and the CHANGES[2] file you will notice SQLRat needs to work with the entity/table meta data and relation meta data. SQLRat accepts the WHERE, GROUP-BY and OTHER clauses in the find-xxx functions where you can pass pre-generated SQL clauses. Whether such partial SQL clauses can be generated using ClojureQL is something I am not sure of. ClojureQL provides database-agnostic API for (a) creating tables (also for altering tables?) and (b) reporting queries involving JOIN/UNION etc These are not provided by SQLRat. I think you can readily use them while working in mixed-mode (ClojureQL and SQLRat). [1] http://bitbucket.org/kumarshantanu/sqlrat/src/tip/src/main/clj/org/bituf/sqlrat/entity.clj [2] http://bitbucket.org/kumarshantanu/sqlrat/src/tip/CHANGES > > I've used ClojureQL quite a bit, but I haven't attempted to verify its > database agnoticity. I think having that is a good goal, though. I'd > be curious to hear what the ClojureQL developers think of working with > your project. IMHO database agnosticism is a good goal indeed -- quite useful for those having to switch between databases. Regards, Shantanu -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en
