Re:Easy Steps to a Complete Understanding of SQL
by lysium on Tuesday September 03, 2013 @08:17AM
(#6320431)
Great article! I wish all SQL libraries would adhere to this structure instead of forcing devs to write glorified (string) SQL. Ie., let me
and only in that order.
[ Parent
| on HN ]
Re:Easy Steps to a Complete Understanding of SQL
by batbomb on Tuesday September 03, 2013 @09:46PM
(#6325076)
I wrote my own library in Java recently for something similar. It was inspired by LINQ and SQL grammar.
Select statement = table1.select()
.join(table2,[join condition])
.where(table1.col1.gt(10))
.groupBy(table1.col1)
.selection(col1, Fn.avg(table1.col2))
Select s = new Select()
.from(table1)
.join(table2, table2.t1_col1.eq(table1.col1))
.where(table1.col1.gt(10))
.groupBy(table1.col1)
.selection(col1, Fn.avg(table1.col2));
Re:Easy Steps to a Complete Understanding of SQL
by andrewcooke on Tuesday September 17, 2013 @04:00PM
(#6401557)
have you seen empire db? http://empire-db.apache.org/
no-one much seems to use it, but it's actually quite neat.
Re:Easy Steps to a Complete Understanding of SQL
by lukaseder on Tuesday September 03, 2013 @10:17AM
(#6321091)
Check out http://www.jooq.org, by the same author as the article (me)