how are you loading the sqlite database adaptor? never mind, just scrolled down and saw

I get a different error

user=> (require '[db.booksdb])
CompilerException java.sql.SQLException: path to 'db/database.db': '/private/tmp/booksdb/db' does not exist, compiling:(db/booksdb.clj:16:1) 

creating a "db" directory fixes the error and the code works - did you restart your repl after defining the new deps?

OMG, i didn't restarted the REPL

took me over 1 hour and i just had to restart cider.... thanks!

I should have a sign over my desk that says "error makes no sense? exit repl, run lein clean, and start the repl again"

hahaha, that's so true, i'll hopefully remember this next time

technically my first question was relevant: > how are you loading the sqlite database adaptor? since you had defined it but not performed the restart that would load it :D