{"repo":"tamizhvendan/honeyeql","free":true,"listed":false,"github":"https://github.com/tamizhvendan/honeyeql","clone":"git clone https://github.com/tamizhvendan/honeyeql.git","description":"HoneyEQL is a Clojure library enables you to query database using the EDN Query Language.","language":"Clojure","stars":227,"topics":["clojure","honeysql","postgresql","mysql","eql","edn"],"license":"EPL-2.0","category":"databases-storage","readme_excerpt":"HoneyEQL HoneyEQL is a Clojure library that enables you to query the database declaratively using the EDN Query Language(EQL). It aims to simplify the effort required to work with relational databases in Clojure. It also provides database modification operations support using Clojure maps with namespace qualified keys. Supports Postgres (9.4 & above) and MySQL (8.0 & above) Rationale When a query involves more than one table, the declarative nature of SQL depreciates. Depending on the type of relationship, we have to put appropriate join conditions. Let's assume that we have the following schema. To get all the films of an actor with the id 148 along with his/her first name & last name, we have to query it as The query result would look like Then we need to do the group by operation on the first name & last name attributes at the application layer to get the exact result that we want! How about making these steps truly declarative? With HoneyEQL, we can do it as The above query yields the results in the exact-shape that we wanted and without any explicit data transformations. As the query syntax is made up of Clojure's data structures, we can construct it dynamically at runtime. HoneyEQL transforms the EQL into single efficient SQL and queries the database using next.jdbc. Documentation Running Tests Acknowledgements Walkable is the inspiration behind HoneyEQL. HoneyEQL is not possible without the following excellent Clojure libraries. - HoneySQL - next-jdbc - inflections - d","default_branch":null,"files":null,"tree":[],"storefront":"/r/tamizhvendan","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tamizhvendan/honeyeql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}