Re^9: Perl Contempt in My Workplace

in reply to Re^8: Perl Contempt in My Workplace
in thread Perl Contempt in My Workplace

You're an oracle man, right? Oracle has JSON_TABLE to alleviate the JSON weirdness, I think.

Postgres has the same functionality, but not yet those JSON_TABLE API/functions (that the SQL Standard prescribes). That JSON_TABLE work (for postgres) is largely done, although not yet committed. Somewhat understandably, there seems to be a lack of interest: most DBAs look down a bit upon the strangeness of JSON data type, and prefer tables of more conventional data types. I take it that in the oracle-world there is the same reluctance towards this encroachment of NoSQL-y types. I feel the same reluctance myself.

Comment on Re^9: Perl Contempt in My Workplace

Replies are listed 'Best First'.
Re^10: Perl Contempt in My Workplace by cavac (Parson) on May 28, 2021 at 14:28 UTC
I used to use Oracle back in the day. Nowadays, it's PostgreSQL all the way. There are a few cases where i use JSON datatypes and similar, but they are very limited. `perl -e 'use Crypt::Digest::SHA256 qw[sha256_hex]; print substr(sha256_hex("the Answer To Life, The Universe And Everything"), 6, 2), "\n";'`	[reply] [d/l]

In Section Meditations