News for hackers. Stuff that matters.

A comment on JSONB Has Landed in SQLite. Parent comment

Re:JSONB Has Landed in SQLite by ric2b on Thursday December 07, 2023 @05:50PM (#38562895)
You're not storing a string, you're storing a JSON object. If you want to store a string use TEXT or VARCHAR.
[ Parent | on HN ]
Re:JSONB Has Landed in SQLite by pie_flavor on Friday December 08, 2023 @05:09PM (#38575252)
That is what this post chain is about. The nuance between choosing to store your JSON as a string in a TEXT column or as JSONB in a BLOB column.
[ Parent | on HN ]