Re: SQL to logic rule mapping

2013-10-30 Thread Brian Craft
On Wednesday, October 30, 2013 8:37:51 PM UTC-7, ArturoH wrote: > > One other thing I did not know is that there are Datalog to SQL bridges > that is good to know. > > That python script is the only one I've found. I'd be curious to hear of any others. -- -- You received this message becau

Re: SQL to logic rule mapping

2013-10-30 Thread Brian Craft
On Wednesday, October 30, 2013 8:04:25 PM UTC-7, ArturoH wrote: > > On Wednesday, October 30, 2013 12:01:02 PM UTC-5, Brian Craft wrote > >> On Wednesday, October 30, 2013 7:56:46 AM UTC-7, ArturoH wrote: >>> >>> I think the shortcoming of ORM tools is that they bring a higher level >>> technol

Re: SQL to logic rule mapping

2013-10-30 Thread ArturoH
Christopher, thanks for the info. My hesitation with Datalog comes from the separation from database and general purpose code. In a way it has the same problem as SQL. Once you get your result set then you are on your own. Clojure is a fantastic language, but I'd like to extend that same logic

Re: SQL to logic rule mapping

2013-10-30 Thread ArturoH
On Wednesday, October 30, 2013 12:01:02 PM UTC-5, Brian Craft wrote > On Wednesday, October 30, 2013 7:56:46 AM UTC-7, ArturoH wrote: >> >> I think the shortcoming of ORM tools is that they bring a higher level >> technology like SQL and lower it down to the low level of imperative >> languages

Re: SQL to logic rule mapping

2013-10-30 Thread Brian Craft
I did that recently, as well. Found this: https://github.com/ghxiao/nrdatalog2sql Haven't done more than glance at the code. On Wednesday, October 30, 2013 4:29:33 PM UTC-7, Mark wrote: > > > > On Wednesday, October 30, 2013 4:27:31 PM UTC-7, Christopher Allen wrote: >> >> If you just want to bu

Re: SQL to logic rule mapping

2013-10-30 Thread Mark
On Wednesday, October 30, 2013 4:27:31 PM UTC-7, Christopher Allen wrote: > > If you just want to build up and apply constraints, Korma can do that. > > If you want something closer to Datalog with unification, then a Datalog > to SQL bridge is the most practical of largely impractical choices.

Re: SQL to logic rule mapping

2013-10-30 Thread Christopher Allen
If you just want to build up and apply constraints, Korma can do that. If you want something closer to Datalog with unification, then a Datalog to SQL bridge is the most practical of largely impractical choices. On Tuesday, October 29, 2013 9:35:45 AM UTC-7, ArturoH wrote: > > I am interested in

Re: SQL to logic rule mapping

2013-10-30 Thread Brian Craft
On Wednesday, October 30, 2013 7:56:46 AM UTC-7, ArturoH wrote: > > I think the shortcoming of ORM tools is that they bring a higher level > technology like SQL and lower it down to the low level of imperative > languages. > Can you give an example? -- -- You received this message because

Re: SQL to logic rule mapping

2013-10-30 Thread ArturoH
Say you have a simple rule that if people pay within a timeframe they get a X% discount select . price*(1-X/100)from where ... paydate between startdiscount and enddiscount It is likely that there will be multiple SQL statements that will contain some form of this rule. A good

Re: SQL to logic rule mapping

2013-10-30 Thread Ray Miller
On 30 October 2013 11:47, Kris Jenkins wrote: > FWIW, I too am interested in a better SQL tool for Clojure, but my take on > it is that we don't need a new language on top of SQL, but a better way to > use SQL directly. > > My thinking, plus an *alpha-grade* library, can be found here: > https://

Re: SQL to logic rule mapping

2013-10-30 Thread Kris Jenkins
FWIW, I too am interested in a better SQL tool for Clojure, but my take on it is that we don't need a new language on top of SQL, but a better way to use SQL directly. My thinking, plus an *alpha-grade* library, can be found here: https://github.com/krisajenkins/yesql#rationale Cheers, Kris O