Toot

Written by Steve Purcell on 2024-10-08 at 13:29

@henrikjernevad Yes, and also worth noting that it's even better to make those columns JSONB instead of TEXT, so that a) the JSON is guaranteed valid and b) operations like ->> are much faster. Plus you can then add specialised indexes to those columns if necessary.

=> More informations about this toot | View the thread | More toots from sanityinc@hachyderm.io

Mentions

=> View henrikjernevad@mastodon.social profile

Tags