Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment