Clojurians Log v2
Clojure programming
Channels
Apps
honeysql
Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
Sasha Lysenko 2020-07-31T18:56:43.313800Z
Hello! Is there a way to say "with (nolock)" using honeysql?
seancorfield 2020-07-31T18:58:41.314200Z
@alexandra.lysenko018 Is that ANSI SQL syntax or a vendor-specific extension?
Janne Sauvala 2020-08-01T17:01:13.316900Z
Are there real plans for HoneySQL 2.0 or are you just teasing us @seancorfield? 🙂
seancorfield 2020-08-01T17:38:00.317100Z
@janne.sauvala Real plans. I have a OneNote section with pages of notes about it. So, it's very much in the hammock right now. But it will happen.
seancorfield 2020-08-01T17:40:16.317300Z
There's a milestone as well, with a few high-level tickets https://github.com/seancorfield/honeysql/milestones/2.0.0
Janne Sauvala 2020-08-01T18:00:22.318300Z
That’s awesome! Thanks for all of your work with honey sql and other libs 🙏:skin-tone-2:
Sasha Lysenko 2020-07-31T19:02:37.314300Z
it's an sql server hint. example: "from some-table with (nolock)"
Sasha Lysenko 2020-07-31T19:11:46.314500Z
Oh this turned out to be easy,
(from [:mytable [:m "WITH (NOLOCK)"]])seancorfield 2020-07-31T19:12:09.314800Z
HoneySQL doesn't support vendor-specific extensions in general. You can extend the multimethods yourself to add support for new stuff.
seancorfield 2020-07-31T19:12:32.315100Z
Ah, that probably works more by accident than by design...
seancorfield 2020-07-31T19:13:13.315300Z
I want to make this sort of thing easier/more predictable when I design HoneySQL 2.0 🙂