I'll also mention that when I used to do C# and SQL I often found myself often resorting to stored procs for high performance queries. Depending on your SQL DB, you can often put quite a bit of conditional logic into the queries, as long as that logic isn't executed row-by-row. Depending on how advanced the query optimizer is you could often work with it to get good performance with minimal hassle. But that was on MSSQL, so your milage may vary.
Timothy On Wed, Jul 23, 2014 at 11:54 AM, Sean Corfield <s...@corfield.org> wrote: > Yes, we're using HoneySQL extensively at World Singles for our more > complex reporting queries - which was why I asked what Yesql users were > doing to handle conditionally built queries. > > I really like the look of Yesql - and I can see the benefits for some of > our more straightforward queries so I might give it a go at some point. > > Sean > > On Jul 23, 2014, at 4:56 AM, Colin Yates <colin.ya...@gmail.com> wrote: > > Another very satisfied honeysql user here. It matches this use case > perfectly. > > On Wednesday, 23 July 2014 10:15:09 UTC+1, David Powell wrote: >> >> I'm using honeysql for constructing dynamic queries (eg conditionally >> adding complex clauses). It feels a bit more composable to me, and seemed >> much easier to add the OR of several clauses to a query etc. >> > > > -- “One of the main causes of the fall of the Roman Empire was that–lacking zero–they had no way to indicate successful termination of their C programs.” (Robert Firth) -- 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 --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
