porsas

Nopea kuin sika pakkasella

Spike to see how fast we can go with Clojure + JDBC. Highly Experimental.

Related dicsussion: https://clojureverse.org/t/next-jdbc-early-access/4091

Latest version

Usage

porsas provides tools for precompiing the functions for converting ResultSet into EDN values. This enables basically Java-fast JDBC queries while using idiomatic Clojure.

Query functions take either a plain SQL String or a vector of SQL String and parameters.

A Java JDBC query

;; 630ns
(title "java")
(bench! (java-query connection "SELECT * FROM fruit"))

Compiled query functions

create-query return query function, which compiles and memoizes fast Clojure code for each unique SQL query string. It takes the following options:

key	description
:row	Optional function of rs->value or a [[RowCompiler]] to convert rows into values
:key	Optional function of rs-meta i->key to create key for map-results"

Note: some RowCompiler implementations (like p/rs->map) generate the code at runtime, which might not supported in all platforms like GraalVM.

(def query (p/create-query {:row (p/rs->map)}))

;; 630ns
(title "porsas: compiled & cached query")
(bench! (query connection "SELECT * FROM fruit")))

Cached query functions

With defaults, a bit slower (non-compiled) mapper is used. Works on all platforms.

(def query (p/create-query))

;; 1400ns
(title "porsas: cached query")
(bench! (query connection "SELECT * FROM fruit")))

Fully Dynamic queries

p/query works just like query, but doesn't use any cache.

;; 2100ns
(title "porsas: dynamic query")
(bench! (p/query connection "SELECT * FROM fruit"))

Performance

At least an order of magnitude faster than clojure.java.jdbc, see the tests for more details.

TODO

• more tests
• bounded cache for statement memoization
• batch-api
• async-api for postgresql?

License

Copyright © 2019 Metosin Oy

Distributed under the Eclipse Public License, the same as Clojure.