Week 9

Types of Databases

PostgreSQL JSONB Columns

Object Storage

Practice

Assignment

Back end Track

Under construction

<aside> 🚧

This page is currently under construction. Please check back later.

</aside>

Implementation plan:

  1. What is jsonb — binary JSON stored in a relational column
  2. When to use jsonb vs normalized tables
  3. Creating a table with a jsonb column
  4. Inserting JSON data
  5. Updating JSON data (jsonb_set)
  6. Querying nested fields: > (get as JSON), >> (get as text)
  7. Querying arrays within JSON
  8. Containment operator: @>
  9. Indexing JSONB: GIN indexes for fast lookups
  10. Advantages: flexibility, schema evolution
  11. Limitations: harder to enforce constraints, query complexity
  12. Exercise: add a jsonb column to an existing project and query it

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

CC BY-NC-SA 4.0 Icons

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.