News for hackers. Stuff that matters.
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.
Re:Jepsen: MongoDB 4.2.6 by emerongi on Sunday May 24, 2020 @09:17AM (#23291287)
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).