Using PostgreSQL as a document store (instead of MongoDB)

Thomas Hansen (13.Jul.2017 at 10:30, 50 min)
Talk at OpenWest Conference 2017 (English - US)

Rating: 0 of 5

A new field type named [JSONB](https://www.postgresql.org/docs/9.4/static/datatype-json.html) was [introduced in PostgreSQL version 9.4](https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.4#JSONB_Binary_JSON_storage) which makes it so you no longer need to choose between a relational and document data store. Like mongo, this field can store arbitrary json data so you're not slowed down by complex schemas, but they also allow joins and indexes so you have those relational databases features when you need them.

In this talk, I'll cover how to use JSONB field type and compare its usage to the basic MongoDB features. I'll explain the advantages and pitfalls that I've seen from using these fields so you can decide what will work best for you. No knowledge of MongoDB will be necessary to understand the talk, but familiarity with SQL will be helpful. [304]

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

Want to comment on this talk? Log in or create a new account or comment anonymously

Write a comment

 
Please note: you are not logged in and will be posting anonymously!
= seven minus two
 
No comments yet.
© Joind.in 2017