Attempt to Use SQLite3 from ClojureScript

sqlite.cljs

;; Attempting to access an SQLite DB from Loom.

;; SQLite3 is installed and npm installed.

(def sqlite (js/require "sqlite3"))

(defn on-error [err]
  (when err
    (js/console.error err.message)))

;; Existing DB with 8 test records.
(def db
  (new sqlite.Database "./resources/public/db/database.db" sqlite.OPEN_READONLY on-error))

(def id "901680220")

(defn query-handler [err, row]
  (if err
    (js/console.error err.message)
    (js/console.error row)))

(.get db "SELECT last_name, first_name FROM voters WHERE id = ?" [id] query-handler)
;; => SQLITE_RANGE: bind or column index out of range

;; SOLUTION:
(.get db "SELECT last_name, first_name FROM voters WHERE id = ?" #js[id] query-handler)
=> { last_name: 'Heaton', first_name: 'Carl' }

Another useful post related to this (tip from Mike Fikes): Checked Array Access

This is important for getting data out of the results, using ((goog.object/get result "last_name")