There's some great stuff in this release. I'm still using 10 on Tildes for now, but I'm hoping to upgrade to 12 pretty soon. I'm especially interested in the generated columns, since I think that...
There's some great stuff in this release. I'm still using 10 on Tildes for now, but I'm hoping to upgrade to 12 pretty soon. I'm especially interested in the generated columns, since I think that helps with some cases that have always been a little awkward. The SQL/JSON path language might also be nice for some uses, since I use JSONB columns for a few purposes, mostly related to storing "content metadata" (things like word counts, video durations, and so on).
Release page in the docs: https://www.postgresql.org/docs/12/release-12.html.
HackerNews discussion: https://news.ycombinator.com/item?id=21146356.
Reddit discussion: https://redd.it/dcquj4.
There's some great stuff in this release. I'm still using 10 on Tildes for now, but I'm hoping to upgrade to 12 pretty soon. I'm especially interested in the generated columns, since I think that helps with some cases that have always been a little awkward. The SQL/JSON path language might also be nice for some uses, since I use JSONB columns for a few purposes, mostly related to storing "content metadata" (things like word counts, video durations, and so on).