search

LibreCat / Catmandu-DBI

A Catmandu::Store plugin for DBI based interfaces
Other
0 stars 1 forks source link

PostgreSQL handler should support the native JSONB types instead of storing in a BLOB #16

Closed phochste closed 5 years ago

phochste commented 7 years ago

PostgreSQL has native support for JSON : https://www.postgresql.org/docs/9.4/static/datatype-json.html This should be the preferred way to store Catmandu records.

nics commented 7 years ago

Only in recent versions. We need a reliable way to test support for this.

nicolasfranck commented 6 years ago

Something like:

if ( $dbh->{pg_server_version} < 90400 ) {

}

cf. https://huntingbears.nl/2015/01/18/postgresql-9-4s-jsonb-and-perl-dbdpg/

nicolasfranck commented 6 years ago

https://github.com/LibreCat/Catmandu-DBI/pull/24

nics commented 5 years ago

Pg handler now this as the 'json' type