Re:Jepsen: MongoDB 4.2.6
by StavrosK on Sunday May 24, 2020 @08:59AM
(#23291184)
I find that using JSON for things you don't need to query/validate (like big blobs you just want to store) and breaking the rest out to columns works well enough. Plus, you can always migrate the data out to a field anyway.
[ Parent
| on HN ]
Postgres 12 has generated columns, so you can throw your data in a jsonb column and have Postgres pull data out of it into separate columns for indexing for example.
Re:Jepsen: MongoDB 4.2.6
by magnushiie on Sunday May 24, 2020 @10:06AM
(#23291601)
Generated columns are not necessary for indexing in Postgres, you can create an index on any expression based on the record (supported by many versions now).