When building you DB, do you use the JSONB type or do you simply use Text? Why use JSONB? What is the difference with JSON?

Hello @joshcowan25! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/ This is good read

joshcowan25 (2022-04-02)

JSONB allows you to use some useful functions in Postgres for searching data.

Thanks!