Eases interoperability between clojure/java datatypes and postgres datatypes. No more boilerplate!
Handles the following:
DATE
<->java.time.LocalDate
TIMESTAMP/TIMESTAMPTZ
<->java.time.ZonedDateTime
JSON/JSONB
<-> clojure map/vectorARRAY
(e.g.int[]
)<-> clojure vectorHSTORE
<-> clojure map (limited support - jdbc stringifies all contents)
Note: this library was once called jdbc-pg-sanity, mpg
is the new version.
Add mpg
as a leiningen dependency:
[mpg "1.1.0"]
Just require the mpg.core
namespace and call patch
(ns whatever.db
(require [clojure.java.jdbc :as j]
[mpg.core :as mpg]]))
(mpg/patch) ;; take the default settings
(mpg/patch {:default-map :hstore}) ;; custom settings are merged with the defaults
;; valid settings:
:data - boolean, default true. auto-map maps and vectors?
:datetime - boolean, default true. auto-map java.time.{LocalDate, ZonedDateTime} ?
:default-map - keyword. one of :json, :hstore. Default :json
The current clojure.java.jdbc interface imposes some limitations on us.
- You only get the autoconversion when using clojure.java.jdbc or something built on it
- When using unbound statements, we cannot save a vector as an array type (we therefore use json)
- When using unbound statements, you must choose between storing maps as json or hstore (default: json)
- All applications that have written to the database are assumed to have correctly saved timestamps in UTC. If you only use this library, you won't have to worry about that. Most applications can be configured with the TZ environment variable
Contributions and improvements welcome, just open an issue! :)
If this library should do something, and it doesn't currently do it, please fork and open a pull request. All reasonable contributions will be accepted.
This library was originally extracted from luminus boilerplate which hails from code floating around the internet generally. James Laver then contributed a new API and java.time support.
Copyright © 2016 Shane Kilkelly
Distributed under the MIT license.