This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2020-04-04
Channels
- # announcements (2)
- # babashka (7)
- # beginners (168)
- # boot (8)
- # cider (10)
- # clara (1)
- # clj-kondo (19)
- # cljdoc (8)
- # cljs-dev (16)
- # clojars (1)
- # clojure (208)
- # clojure-europe (10)
- # clojure-germany (1)
- # clojure-losangeles (1)
- # clojure-uk (56)
- # clojurescript (63)
- # conjure (23)
- # core-typed (2)
- # cursive (5)
- # data-science (1)
- # datomic (35)
- # emacs (1)
- # exercism (58)
- # graalvm (2)
- # graphql (1)
- # jobs (3)
- # kaocha (1)
- # lambdaisland (2)
- # malli (19)
- # meander (5)
- # off-topic (2)
- # pathom (25)
- # pedestal (3)
- # reagent (53)
- # reitit (4)
- # remote-jobs (2)
- # shadow-cljs (26)
- # spacemacs (3)
- # sql (22)
- # tools-deps (17)
hey friends! is there a standard migration tool to use? i have come across ragtime and migratus. is one preferred to the other?
@tjb use the one that uses timestamp for migration name, not the increasing number
(On my phone -- can't remember which that is)
> You can include both SQL and code-based migrations in the same migrations directory, in which case they will be run intermixed in the order defined by their timestamps
Doesn't migratus have a command/tool to generate new migration files with the appropriate name, including the timestamp?
(sql/query db ["SELECT *
FROM item
WHERE LOWER(name) LIKE '%' || ? ||'%'
OR
LOWER(description) LIKE '%' || ? ||'%'"
query query] {:builder-fn result-set/as-unqualified-maps})
Not sure which other engines support it, Postgres also has ILIKE https://stackoverflow.com/questions/20336665/lower-like-vs-ilike