Skip to content

Latest commit

 

History

History
61 lines (40 loc) · 1.3 KB

README.md

File metadata and controls

61 lines (40 loc) · 1.3 KB

jsonknife

Build Status

Useful functions for working with jsonb in PostgreSQL like data extraction, validation & transformation

Development

git clone https://github.com/postgres/postgres
./configure --with-bonjour --prefix=/opt/local/pg
make
sudo make install

export PGDATA=/opt/pg
export PGPORT=5777\n
export PG_BIN=/opt/local/pg/bin\n
bin/initdb -D $PGDATA -E utf8
vim /tmp/pg/postgresql.conf # check port configure log /tmp/pg.log
/opt/local/pg/bin/pg_ctl start -D $PGDATA

cd postgres && src/tools/make_etags
cd postgres/src/contrib
git clone https://github.com/niquola/jsonknife
cd jsonknife
..postgres/src/tools/make_etags .

make && sudo make install && make installcheck

Examples

Path for data extraction from jsonb document is encoded as json vector, where

  • string means object key
  • number - array index
  • object - is pattern to match
//extracting by path:

["frends", {"best": true}, "name" ]

//from:

{"frends": [
  {"best": true, "name": "niquola"},
  {"best": true, "name": "ivan"},
  {"best": false, "name": "avraam"}
]}

// produces:

["niquola", "ivan"]

For more examples take a look at tests.