[HN Gopher] PG_DBMS_JOB - PostgreSQL extension for Oracle DBMS_J...
       ___________________________________________________________________
        
       PG_DBMS_JOB - PostgreSQL extension for Oracle DBMS_JOB
       compatibility
        
       Author : avi_vallarapu
       Score  : 37 points
       Date   : 2021-08-29 13:02 UTC (9 hours ago)
        
 (HTM) web link (www.migops.com)
 (TXT) w3m dump (www.migops.com)
        
       | sverhagen wrote:
       | Is this the sort of thing that will see Oracle sending a cease
       | and desist for them feeling infringed on their copyright and IP?
       | They must not like their vendor lock in being affected and people
       | discovering this better, more affordable alternative.
        
         | avi_vallarapu wrote:
         | In that case, there even exist Orafce, a project that provides
         | a lot of compatibility to a lot of Oracle Packages. For
         | example, a lot of date functions, UTL_FILE, DBMS_OUTPUT and a
         | lot more are already [art of this :)
         | 
         | https://github.com/orafce/orafce
        
       | robertlagrant wrote:
       | This is a brilliant mission. Postgres is commoditising the
       | database in an amazing way.
        
         | chasil wrote:
         | I'm curious if EnterpriseDB already implements this.
         | 
         | The closed-source PL/SQL emulator that they sell on top of
         | PostgreSQL (and license into IBM DB2) is something that has
         | drawn occasional interest over the years.
        
           | avi_vallarapu wrote:
           | Yes, EnterpriseDB implemented it as part of their Commercial
           | Postgres derived database : PPAS. It is not Open Source,
           | whereas, PG_DBMS_JOB is Open Source and released under
           | PostgreSQL license, which is the most liberal license :)
        
         | avi_vallarapu wrote:
         | It is the extensibility of PostgreSQL that makes this possible.
        
       | samhithag wrote:
       | Have seen a ton of Oracle databases with DBMS_JOB. Great thought
       | and contribution by MigOps.
        
       | koolba wrote:
       | Neat. Every Oracle shop from 2001 onward has tons of these jobs.
       | Some of the funkiest apps were ones that used it as a deferred
       | task queue as, IIRC, submitting a job was done transactionally
       | with the rest of your unit of work.
       | 
       | If you think DBMS_JOB is great, then you'll love UTL_TCP! What
       | better way to build an unsupportable nightmare than arbitrary TCP
       | sockets directly from PL/SQL stored procedures:
       | https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/u_tcp...
        
         | orf wrote:
         | Oh my god
        
         | ThePadawan wrote:
         | It really makes you wonder what happened in the last 40 (?)
         | years that we went from
         | 
         | Customer: "Do you sell software that does <random shit>?"
         | 
         | Software company: "Yeah sure, it's part of <giant software
         | suite>! You only need to upgrade to the newest version for
         | $50k!"
         | 
         | to
         | 
         | Customer: "Do you sell software that does <random shit>?"
         | 
         | Software company: "Yeah sure, it's our new completely separate
         | product! It's only $50k!"
        
           | avi_vallarapu wrote:
           | Ya, especially when there exists PostgreSQL like Open Source
           | databases that includes Native Partitioning, Replication,
           | Full Backups plus Point in time recovery, Read Replicas, too
           | many data types including boolean, uuid like types that are
           | not possible with Oracle.
        
       | avi_vallarapu wrote:
       | As it is a full compatibility to Oracle's DBMS_JOB, it must help
       | a lot while migrating from Oracle to PostgreSQL.
        
       ___________________________________________________________________
       (page generated 2021-08-29 23:02 UTC)