Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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 (Priest) 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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (2)
As of 2022-01-28 22:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (74 votes). Check out past polls.

    Notices?