TIL
<ul>
<li><code>jsonb</code>
<ul>
<li>mostly use this
</li>
<li>has an actual data structure
<ul>
<li>concatenation
</li>
<li>get nested properties
</li>
<li>and more!
</li>
</ul>
</li>
</ul>
</li>
<li><code>json</code>
<ul>
<li>stores it as plain text with whitespace
</li>
<li>if you're processing logs and use it more like an audit trail
</li>
<li>can't do those operations ⬆️
</li>
<li>converts to dictionaries and actual JSON more nicely
<ul>
<li>instead of a binary string</li>
</ul>
</li>
</ul>
</li>
</ul>
<a target="_blank" href="https://stackoverflow.com/a/39637548/8479344">SO: Difference between jsonb and json</a>

TIL

* `jsonb`
    
    * mostly use this
        
    * has an actual data structure
        
        * concatenation
            
        * get nested properties
            
        * and more!
            
* `json`
    
    * stores it as plain text with whitespace
        
    * if you're processing logs and use it more like an audit trail
        
    * can't do those operations ⬆️
        
    * converts to dictionaries and actual JSON more nicely
        
        * instead of a binary string
            

[SO: Difference between jsonb and json](https://stackoverflow.com/a/39637548/8479344)

When to use each

JSON vs JSONB in Postgres

I post a ton of #TIL posts at work.
I figured I'd post it here too so that I can reference it later
