Clojurians Log v2
Clojure programming
Channels
Apps
honeysql 2025-08-11
This weekend I was trying to accomplish full-text search in SQLite using Honey SQL. Explicitly executing the query from jdbc works as I hoped:
(jdbc/execute! ["SELECT * FROM documents WHERE text MATCH ?" "moose"])(sql/format {:select :* :from :documents :where [:match :text "moose"]})
=> ["SELECT * FROM documents WHERE MATCH(text, ?)" "moose"]
borkdude 2025-08-12T14:06:57.384059Z
Is there no non-global option for this in honeysql?
p-himik 2025-08-12T14:54:59.920109Z
No, it's a very simple lookup of a value in a map in an atom.
p-himik 2025-08-11T14:46:29.064529Z
:match is not registered as an infix operator, so by default it's treated as a function.
p-himik 2025-08-11T14:47:17.331019Z
You can use (honey.sql/register-op! :match) to fix it.
But note that if there is a match function, doing that will prevent you from using it.
👆 1
Thanks!