POSTGRESQL JSONB BEST TUTORIALS

POSTGRESQL JSONB BEST TUTORIALS

MIKE WANT US TO CARE ABOUT:
1) INDEXES
http://blog.2ndquadrant.com/jsonb-type-performance-postgresql-9-4/

2) TRY TO USE VIEW ON SIMPLE SEARCH
http://www.postgresql.org/docs/9.3/static/rules-materializedviews.html

GUIDES

1) http://schinckel.net/2014/05/25/querying-json-in-postgres/

2) http://nandovieira.com/using-postgresql-and-jsonb-with-ruby-on-rails

3) https://antoine.finkelstein.fr/postgresql-jsonb-brings-nosql-into-rails/

4) http://clarkdave.net/2013/06/what-can-you-do-with-postgresql-and-json/

5) https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-with-postgresql/

HOW TO COVER WITH RSPEC:
https://gist.github.com/RuslanHamidullin/40ae572385056738b83a

BENCHMARKING AND INDEXES
https://gist.github.com/RuslanHamidullin/c6c6ffa400e2bfcb8f43
http://blog.2ndquadrant.com/jsonb-type-performance-postgresql-9-4/
https://www.compose.io/articles/is-postgresql-your-next-json-database/

USEFULL OFFICIAL DOCS:
http://www.postgresql.org/docs/9.4/static/functions-json.html
http://www.postgresql.org/docs/9.4/static/datatype-json.html

9.5 JSONB FEATURES
http://www.depesz.com/2015/05/20/waiting-for-9-5-additional-functions-and-operators-for-jsonb/#more-3012

http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-new-jsonb-functions/