UFFI is abandoned. I use cffi-uffi-compat with CLSQL and it works well. Just make certain CFFI is loaded before you load CLSQL. You can do that with (asdf:load-system :cffi). Use (ql:quickload :cffi) if you don't already have it downloaded.