avi_vallarapu

9 ms·

91.
by avi_vallarapu 5y ago
Yes, good that Oracle added backward compatibility to DBMS_JOB thought there is DBMS_SCHEDULER in recent versions.
92.
by avi_vallarapu 5y ago
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 :)
93.
by avi_vallarapu 5y ago
It is the extensibility of PostgreSQL that makes this possible.
94.
by avi_vallarapu 5y ago
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
95.
by avi_vallarapu 5y ago
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://git
96.
by avi_vallarapu 5y ago
As it is a full compatibility to Oracle's DBMS_JOB, it must help a lot while migrating from Oracle to PostgreSQL.
97.
PG_DBMS_JOB – PostgreSQL extension for Oracle DBMS_JOB compatibility(migops.com)
42 points by avi_vallarapu 5y ago|14 comments
98.
CentOS vs. Rocky Linux Benchmarking with PostgreSQL(migops.com)
2 points by avi_vallarapu 5y ago|0 comments
99.
Enforcing Username and Password checks in PostgreSQL with credcheck(migops.com)
1 points by avi_vallarapu 5y ago|0 comments
100.
Ora2pg Now Supports Oracle_FDW for Faster Data Migration from Oracle to Postgres(migops.com)
2 points by avi_vallarapu 5y ago|0 comments
101.
Powerful House panel – sweeping set of proposals aimed at weakening Big Tech(cnn.com)
2 points by avi_vallarapu 5y ago|0 comments
102.
by avi_vallarapu 5y ago
And this is mainly around array_dims being used and the arrays are not Associative Arrays indeed.
103.
by avi_vallarapu 5y ago
Definitely something everybody assumes and makes a mistake around.
104.
CHAR(1) to Boolean datatype transformations while migrating to PostgreSQL(migops.com)
1 points by avi_vallarapu 5y ago|0 comments
105.
by avi_vallarapu 6y ago
So, it is just a Kudos to the PostgreSQL Community.
106.
by avi_vallarapu 6y ago
This is more of a sarcastic post that nothing can replace PostgreSQL :)
107.
Sarcastic - How hard is it to create a database like PostgreSQL(migops.com)
4 points by avi_vallarapu 6y ago|3 comments
108.
How hard is to create a database software like PostgreSQL?(migops.com)
1 points by avi_vallarapu 6y ago|0 comments
109.
by avi_vallarapu 6y ago
This backup tool even supports backups to Cloud with multiple repositories in parallel.
110.
Oracle RMAN Equivalent for PostgreSQL(migops.com)
2 points by avi_vallarapu 6y ago|1 comments
111.
Advantages of Using PgBackRest for PostgreSQL(migops.com)
1 points by avi_vallarapu 6y ago|0 comments
112.
by avi_vallarapu 6y ago
pgBackRest can also be considered as an Oracle RMAN equivalent and may be much more advanced features than Oracle RMAN.
113.
The worlds Best Backup Tool for PostgreSQL(migops.com)
5 points by avi_vallarapu 6y ago|1 comments
114.
by avi_vallarapu 6y ago
While PLTCL is more lighter
115.
by avi_vallarapu 6y ago
PLTCL and PLPerl are 2 better approaches indeed.
116.
Postgres does handle associative arrays – one just need to know the alternatives(migops.com)
3 points by avi_vallarapu 6y ago|2 comments
117.
by avi_vallarapu 6y ago
:)
118.
by avi_vallarapu 6y ago
Any good stories on tds_fdw(s) for sybase or SQL Server ?
119.
by avi_vallarapu 6y ago
Right, we do have mysql_fdw(s) as well
120.
by avi_vallarapu 6y ago
Nice, FDW(s) are underestimated always.

More ›