Add SQL web console

[polymeris]

Just a suggestion, since I have found it rather useful for developing & testing. I'd send a PR, but, as a beginner, am not confident enough in my clojure skills to tell if this is the right way to do it.

(:import org.h2.tools.Server)
;...

(defonce admin (Server/createWebServer (into-array ["-ifExists" "-webPort" "3001"])))

(defn start-admin []
  (let [port (.getPort admin)]
    (if (.isRunning admin false)
      (timbre/error "H2 web console already running on port" port)
      (do (.start admin)
          (timbre/info "H2 web console started on port" port)))))


(defn stop-admin []
  (if (.isRunning admin false)
    (do (.stop admin)
        (timbre/info "H2 web console stopped"))))

Note the H2 console apparently supports other DBs as well.

[yogthos]

oh interesting I didn't know about this, at the very least it might be useful to add in the docs

[polymeris]

In the case of H2, one might want to run a TCP server and then connect both the app and the console to that, since else they lock the db.

[yogthos]

@polymeris I recently factored http and repl servers into standalone plugins, for example the nrepl is now provided by luminus-nrepl. I think it would make sense to make this another plugin that could be added as a dependency and loaded on startup.