4 ms·
Postgres is mind boggling, coming from sqlite. In a good way, and both are amazing tools. with ordinal jsonb_* ‘3 minutes’::interval create ind
by gorgoiler 4y ago
Postgres is mind boggling, coming from sqlite. In a good way, and both are amazing tools.
with ordinal
jsonb_*
‘3 minutes’::interval
create index on my_json ->> ‘a key’
It’s amazing how much stuff there is available. All the toys!
- CGamesPlay 4y agoJust a quick point in defense of SQLite: that last one is almost verbatim possible in SQLite, and it is possible to calculate ordinals, although the syntax is with standard SQL rather than a custom syntax. The SQLite docs mention that they never found a use case for jsonb that ended up being faster or more efficient than json, so they left it out, although they do reserve the BLOB data type for jsonb if such a use case is discovered.
- gorgoiler 4y agoWell this is a doozy: so you’re saying they are both equally awesome as opposed to being individually awesome in different ways. What a time to be a developer.