Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^9: Perl Contempt in My Workplace

by erix (Prior)
on May 28, 2021 at 11:03 UTC ( #11133212=note: print w/replies, xml ) Need Help??

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.

Replies are listed 'Best First'.
Re^10: Perl Contempt in My Workplace
by cavac (Vicar) 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";'

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11133212]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2023-06-01 09:16 GMT
Find Nodes?
    Voting Booth?

    No recent polls found