Fellow Kids Query Optimization

SELECT id FROM events WHERE event_time >= ? ORDER BY event_time DESC (defmethod gateway/get-event-ids-since ::type [db start-time] (let [node (:node db) result (xt/q (xt/db node) '{:find [id event-time] :in [start-time] :where [[Event :created-at event-time] [event :event id] [(>= event-time start-time)]]} :order-by [[event-time :desc]] :start-time]) (map first result)))

Steve Buscemi appears in the classic “How do you do, fellow kids?” disguise meme, contrasting a clumsy SQL query with a longer Clojure XTDB query that performs the same event lookup. The joke is about an awkward or overcomplicated database implementation being presented as the more sophisticated solution, so it is used as a reaction to questionable code refactoring or unnecessary technical complexity.

• @gentoomemes / 17122 2025-05-02
• @ithueti / 15879 2025-05-03