seancorfield/honeysql on Hacker News

https://github.com/seancorfield/honeysql#vanilla-sql-clause-... (-> (select :a :b :c) (from :foo) (where [:= :foo.a "baz"])) => {:select [:a :b :c] :from [:foo] :where [:= :foo.a "baz"]} Effort: zero (0). That's what "simple made easy" is…

comment by Xmd5a · 2025-02-13 · in SQL pipe syntax available in public preview in BigQuery

…embedding of SQL in Slick in Scala it is astonishing how useful something so simple can be. [1]: https://github.com/seancorfield/honeysql

comment by funcDropShadow · 2024-07-11 · in What goes around comes around and around [pdf]

…HoneySQL is a common alternative to writing SQL that makes it a lot less painful (and composable!): https://github.com/seancorfield/honeysql

comment by rads · 2024-05-22 · in Try Clojure

…any aggregation you'd need to handle in code or use something like Postgres JSON aggregation. [1] https://github.com/seancorfield/honeysql

comment by snorremd · 2024-02-01 · in ORMs are nice but they are the wrong abstraction

I recall using korma way back I and I don’t recall it being terrible but I would say https://github.com/seancorfield/honeysql has very much superseded it by this point… (but I can see how that might not be obviously clear if one is to look…

comment by raspasov · 2023-12-06 · in Why is Jepsen written in Clojure?

…in strings, not having a native way to represent SQL as data is a mistake in my opinion. 0: https://github.com/seancorfield/honeysql#big-complicated-exa... 1: https://blog.jooq.org/a-beginners-guide-to-the-true-order-of...

comment by joe-user · 2023-09-28 · in That's a Lot of YAML

https://github.com/seancorfield/honeysql

comment by JoelSanchez · 2023-06-29 · in Is ORM still an anti-pattern?

…more complicated, but we are doing great complicated things with just maps, no API necessary. [1] https://github.com/seancorfield/honeysql

comment by orestis · 2023-04-28 · in XTDB 2.x Early Access

…database or need an esoteric syntax, extending the compiler to your clause is easy to do[1]. [0] https://github.com/seancorfield/honeysql [1] https://github.com/seancorfield/honeysql#extensibility

comment by emidln · 2022-09-12 · in Ask HN: Does anyone else think SQL needs help?

…Of course it's a bit painful and error prone, given SQL is a textual language, but as HoneySQL ( https://github.com/seancorfield/honeysql ) shows, you can represent SQL statements as data and generate them programmatically in a safe…

comment by onetom · 2022-09-11 · in Ask HN: Does anyone else think SQL needs help?

…paginating through long result sets, without burdening the consumer of the data with such details. https://github.com/seancorfield/honeysql

comment by onetom · 2022-05-11 · in I'm all-in on server-side SQLite

…used it from Clojure, via HoneySQL, so no ORM, no danger of SQL injection. It was really wonderful! https://github.com/seancorfield/honeysql I used it to quickly iterate on the development of migration SQL scripts for a MySQL DB, which was…

comment by onetom · 2022-05-11 · in I'm all-in on server-side SQLite

…to use the full power of your db. [1] https://theartofpostgresql.com/blog/2019-09-the-r-in-orm/ [2] https://github.com/seancorfield/honeysql

comment by snorremd · 2021-07-15 · in SQLBolt – Interactive lessons and exercises to learn SQL

I believe Honey SQL might be just what you are looking for: https://github.com/seancorfield/honeysql

comment by adamkl · 2021-03-10 · in I don't want to learn your query language (2018)

…as well, which gives us a nosql feel while still using a traditional relational database. [0] https://github.com/seancorfield/honeysql

comment by jetti · 2020-08-03 · in Ask HN: Backend developers of HN, where and how often do you still use SQL?

…Data driven DSLs: - https://github.com/noprompt/garden - https://github.com/weavejester/hiccup - https://github.com/seancorfield/honeysql Hyper normalised relational databases: - https://www.datomic.com/ - https://opencrux.com/ -…

comment by slifin · 2020-06-05 · in A History of Clojure [pdf]

…separation using nippy serialization (in place of pr-str/read-string) at the edges of my app. [0] https://github.com/jkk/honeysql [1] http://www.onyxplatform.org/ [2] https://github.com/ptaoussanis/nippy

comment by emidln · 2020-04-08 · in A Little Clojure

…a lot of bugs/lack of features compared to honeySQL which is about 5 files of data orientated code: https://github.com/jkk/honeysql I should mention Zend DB is not an outlier here for bulky code have a look at other PHP query builders…

comment by slifin · 2020-04-01 · in Writing HTML with Racket and X-Expressions (2019)

I personally prefer tools like https://github.com/jkk/honeysql It helps build queries programmatically but doesn't abstract / get too much in your way. On the "mapping" side, the resultset is just a map. This is where languages that expose…

comment by dvliman · 2019-05-07 · in To ORM or Not to ORM

I meant honeysql, but iPhone corrected it. :) https://github.com/jkk/honeysql/blob/master/README.md

comment by ludwigvan · 2019-01-05 · in Ask HN: Go-to web stack today?

…https://www.hugsql.org/ http://cosette.cs.washington.edu/ https://www.datomic.com/ https://github.com/jkk/honeysql https://docs.sqlalchemy.org/en/latest/core/tutorial.html

comment by default-kramer · 2018-11-23 · in Show HN: Plisqin, an SQL generator written in Racket

Clojure has several libraries (such as https://github.com/jkk/honeysql ) which basically let you build a representation of an SQL query as a Clojure data structure, and then programatically transform it. It is great when you need to do…

comment by djpowell · 2018-04-11 · in Ask HN: Raw SQL vs. ORM?

▲ 118

Honey SQL – SQL as Clojure data structures

story by tosh · 2017-08-29 · 30 comments

I would recommend taking a look at https://github.com/jkk/honeysql that uses Clojure data structures to represent SQL statements. It's similar idea to Hiccup for HTML.

comment by yogthos · 2017-07-10 · in The Re-Frame Guide: Front-End Architecture in Clojure

…evolve helper functions around https://github.com/clojure/java.jdbc and then use something like https://github.com/jkk/honeysql or http://sqlkorma.com/ for generating actual select query SQL.

comment by danneu · 2014-04-22 · in Goji: a web microframework for Go