Simplicity, and implications on usage of SQL

2011-10-25 Thread Brent Millare
In the thread about Rich Hickey's talk on simplicity, people bring up the point that Rich suggests to *finally*, learn SQL. The idea is to use declarations to describe your solution, decoupling implementation details. However, its arguable that SQL itself is hard. For example, programmers can o

Re: Simplicity, and implications on usage of SQL

2011-10-25 Thread Leonardo Borges
I'm new to clojure but I find the approach [1]Arel takes to SQL very useful. It uses relational algebra to make complex SQL statements composed by smaller structures that represent simple SQL statements. On my current project, we use it as a way to provide the staff will a flexible query builder.

Re: Simplicity, and implications on usage of SQL

2011-10-25 Thread Si
You should definitely take a look at ClojureQL: http://www.clojureql.org/ Regarding simplicity, I'd simply suggest being wary of how you handle associations. If you can deal with your data and relationships at top level, you can probably keep things simple, but if you start pushing relationship ha