Talk in English - US at OpenWest Conference 2017
Track Name:
200A - Data
Short URL: https://joind.in/talk/defaa
(QR-Code (opens in new window))
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]
Comments
Comments are closed.