Hello everyone!

(-> (sql/query ds ["select * from customers"] {:builder-fn rs/as-unqualified-lower-maps}) lazy-seq)

I believe that is what plan is for

Alternatively, you could use a cursor?

Yup, what @dharrigan said @ramon.rios -- query (which is the same as execute! really) gives you a complete, realized vector of hash maps -- converting that to a lazy-seq is pointless: the data is already all in memory. What you want is plan and then reduce over that.

plan also lets you take advantage of lazy/streaming result sets on the JDBC side (even tho' reducing is eager on the Clojure side), because you can set options to get the JDBC sdriver/database to read results N rows at a time and process them in a reduction, so you can deal with result sets much larger than will fit in memory. See the Tips & Tricks section of Friendly SQL Functions (in the GitHub repo -- it has doc changes that have not yet been published in a release to http://cljdoc.org).

👍

Ok. I got that plan is the one who i need to pick up. I'll try out on what i want to achieve, thanks 🙂