Marcus,
Good to hear! I am have never used Drupal, what do you mean by
pseudo-table?
Also, looking into this I think the one caveat to using Caribou for your
query engine is that it requires that you have a table for both "model" and
"field" that contain the descriptions of the model you are querying. If
you create the model using Caribou in the first place this will exist, but
it probably won't if you are trying to use it on a non-caribou db.
This could be mitigated by providing the model descriptions in some kind of
configuration step... that wouldn't be too hard. I will ponder on how best
to support that.
On Mon, Nov 18, 2013 at 12:40 PM, Marcus Blankenship
<mar...@creoagency.com>wrote:
> Ryan,
>
> Awesome! We’re playing with Caribou now, and are loving it. At first we
> thought “Oh, this is going to be like Drupal, with all it’s pseudo-tables
> and crap. But it’s not, and we’re having fun with it!
>
> I’ll try the query engine now. Thanks!
>
> On Nov 18, 2013, at 12:31 PM, Ryan Spangler <ryan.spang...@gmail.com>
> wrote:
>
> I just ran this in the Caribou repl:
>
> (caribou.model/gather :field {:where {:created-at {:<=
> (java.util.Date.)} :model-id 1}})
>
> And got a bunch of results. No string coercion necessary! (also, dashes
> not underscores!)
>
> We looked at Korma and found it lacking (similar problem as Compojure:
> macros). For that reason we built an entire query engine that works on
> data directly, so that you can build up queries programmatically just like
> you would any other data structure (!)
>
> Check out the section on retrieving content here:
> http://caribou.github.io/caribou/docs/content.html
>
> You can do a bunch of cool stuff (logic operations, "in" queries,
> conditions that span associations, selecting certain fields, seamless
> queries over join tables etc).
>
> Let me know if there is something you expect out of a query engine that
> Caribou doesn't do, we will add it (if it makes sense!)
>
> All this stuff is in caribou-core (which you can use independently of the
> rest of Caribou): https://github.com/caribou/caribou-core
>
> Maybe I should call it something else to emphasize it is a standalone
> library... (and replacement for korma)
>
>
> On Mon, Nov 18, 2013 at 11:07 AM, Marcus Blankenship <
> mar...@creoagency.com> wrote:
>
>> Brian,
>>
>> Yeah, and I realize I’m going to take darts for this, but coming from
>> Django’s ORM / Rails ActiveRecord makes Korma and these other tools feel
>> like stone-age tools. I’d rather do it all in SQL than fight something to
>> get out of my way, or reveal it’s magic.
>>
>> I know I’m probably not thinking about the problem right, but here’s an
>> example of something that I still can’t get to work in Korma. Grrrr….
>>
>> *lein-repl commands*
>> (use [`advent2.models.db] :reload-all)
>> (get-unlocked-videos-for-campaign 1)
>>
>>
>>
>> *models/db.clj function*
>> (defn format-todays-date []
>> (let [date (java.util.Date.)]
>> (prn date)
>> (str \' (.format (java.text.SimpleDateFormat. "yyyy-MM-dd") date) \'
>> )))
>>
>>
>> (defn get-unlocked-videos-for-campaign [campaign]
>> (let [c_id (:id campaign)]
>> (select videos (where {:unlock_date [<= (format-todays-date)]
>> :campaign_id c_id}))))
>>
>>
>>
>> *output*
>> user=> (get-unlocked-videos-for-campaign 1)
>> #inst "2013-11-18T19:06:09.595-00:00"
>> Failure to execute query with SQL:
>> SELECT "videos".* FROM "videos" WHERE ("videos"."unlock_date" <= ? AND
>> "videos"."campaign_id" IS NULL) :: ['2013-11-18']
>> PSQLException:
>> Message: ERROR: operator does not exist: date <= character varying
>> Hint: No operator matches the given name and argument type(s). You
>> might need to add explicit type casts.
>> Position: 63
>> SQLState: 42883
>> Error Code: 0
>>
>> PSQLException ERROR: operator does not exist: date <= character varying
>> Hint: No operator matches the given name and argument type(s). You
>> might need to add explicit type casts.
>> Position: 63
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
>> (QueryExecutorImpl.java:2102)
>>
>>
>>
>>
>>
>>
>> On Nov 18, 2013, at 10:23 AM, Brian Craft <craft.br...@gmail.com> wrote:
>>
>> Re: korma, and sql dsls, I've been moving between korma, honeysql, and
>> raw sql, without being satisfied with any of them. Desirable traits of the
>> db layer in my problem domain are 1) eliminating boilerplate (e.g. setting
>> up default keys, and indexes, and performing standard joins across
>> relations), 2) isolating view layers from data access layers (so the view
>> doesn't need to know if a subselect or a join is required to span some
>> relation, for example), 3) ability to progressively optimize by dropping
>> back to sql when required, 4) ability to safely expose a general purpose
>> query API over the data.
>>
>> korma eliminates a very, very small part of the boilerplate. It's almost
>> not worth the effort. Falling back to raw sql smoothly is difficult in
>> korma, and I've had to drop it entirely in places where I need performance.
>> Honeysql eliminates no boilerplate, but representing queries with data
>> structures does make it easy to expose a sql-like query API with db
>> firewalling (by matching on the incoming structure). Korma appears to also
>> represent queries as data structures, but it's not part of the documented
>> API. You have to reverse-engineer it, and I expect it's subject to change.
>>
>>
>> On Monday, November 18, 2013 8:19:28 AM UTC-8, Marcus Blankenship wrote:
>>>
>>> Brian, I certainly will. I’ll type up something later this week as we
>>> progress. The current pain point is Korma, and generally learning clojure.
>>>
>>>
>>>
>>>
>>> On Nov 16, 2013, at 10:25 AM, Brian Craft <craft...@gmail.com> wrote:
>>>
>>> Marcus -- I hope you will post updates to the list with your
>>> experiences. It would be very interesting.
>>>
>>> This thread has drifted a bit from (roughly) "What can you do with
>>> clojure web tooling?" toward "What can you imagine some day doing with the
>>> clojure web tooling of the future?", which are both interesting questions,
>>> but have somewhat different audiences. And the answers inform each other.
>>>
>>>
>>> On Friday, November 15, 2013 8:20:32 AM UTC-8, Marcus Blankenship wrote:
>>>>
>>>> Me too! Thanks to everyone who’s contributed, it’s been *very* helpful!
>>>>
>>>> On Nov 14, 2013, at 10:43 AM, Waldemar Schwan <
>>>> waldema...@googlemail.com> wrote:
>>>>
>>>> I just want to say that this is one of the most interesting discussions
>>>> I followed on this mailing list.
>>>>
>>>> Thanks to all participants.
>>>>
>>>> Am 14.11.2013 um 19:24 schrieb Brian Craft <craft...@gmail.com>:
>>>>
>>>>
>>>>
>>>> On Thursday, November 14, 2013 9:42:52 AM UTC-8, Jonathan Irving wrote:
>>>>>
>>>>> I agree with much of what you write James - I'm paid to write rails
>>>>> and
>>>>> node.js code, and I'm finding that node is encouraging me to compose
>>>>> small components and basically sidestep a lot of the issues that rails
>>>>> is designed to address.
>>>>>
>>>>
>>>> Can you give a concrete example?
>>>>
>>>> --
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Clojure" group.
>>>> To post to this group, send email to clo...@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+u...@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+u...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>
>>>>
>>>> --
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Clojure" group.
>>>> To post to this group, send email to clo...@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+u...@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+u...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>
>>>> marcus blankenship
>>>> \\\ Partner, Problem Solver, Linear Thinker
>>>> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>>>>
>>>>
>>> --
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Clojure" group.
>>> To post to this group, send email to clo...@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+u...@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+u...@googlegroups.com.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>> marcus blankenship
>>> \\\ Partner, Problem Solver, Linear Thinker
>>> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>>>
>>>
>> --
>> --
>> 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/groups/opt_out.
>>
>>
>> marcus blankenship
>> \\\ Partner, Problem Solver, Linear Thinker
>> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>>
>>
>> --
>> --
>> 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 a topic in the
>> Google Groups "Clojure" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/clojure/ZxUUBlYf1ck/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> clojure+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
> --
> --
> 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/groups/opt_out.
>
>
> marcus blankenship
> \\\ Partner, Problem Solver, Linear Thinker
> \\\ 541.805.2736 \ @justzeros \ skype:marcuscreo
>
> --
> --
> 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 a topic in the
> Google Groups "Clojure" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/clojure/ZxUUBlYf1ck/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> clojure+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
--
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/groups/opt_out.
