51–60 of 73 posts
What’s the point of doing some just for the sake of destroying other people’s business?
Postgresql, on the other hand, is dead simple to manage.
It's my dream to move all my Oracle databases to Postgresql.
It will be a success when it fully supports, Object Types, Packages, Autonomous transactions, PL/SQL, and BULK Collect Operations among other features.
It's undeniably a good platform for developing applications and firms get hooked on it.
Earlier quoted context omitted.
The software license will still stop you from doing that. No business that would need Oracle will run Oracle software knowingly violating the license.
It’s also likely in violation of arcane copyright law. The oracle wire protocol includes a handshake procedure that sends a poem in one of the initial messages. It’s untested legal theory whether copying that poem in a new work (e.g. a new driver or compatability layer) would violate Oracle’s copyright on the poem. https://dacut.blogspot.com/2008/03/oracle-poetry.html
Earlier quoted context omitted.
Postgres has it https://www.postgresql.org/docs/current/rules-materializedvi...
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
Earlier quoted context omitted.
The postgres 15 manual has a chapter on Oracle compatibility. I don't know where to find it on their website, but the docs RPM that they provide bundles the PDF.
You are probably thinking of ECPG's "Oracle compatibility mode", which makes it behave more like Oracle Pro*C - https://www.postgresql.org/docs/15/ecpg-oracle-compat.html However, few people actually use Pro*C nowadays. I spent almost 10 years working for Oracle, and I never once came across anybody using it. I think almost all use of it is in legacy applications which date back to the 1980s, first half of the 1990s…
It will be a success when it fully supports, Object Types, Packages, Autonomous transactions, PL/SQL, and BULK Collect Operations among other features.
That was my question. Is it compatible with PL/SQL? And how is the performance?
Earlier quoted context omitted.
The software license will still stop you from doing that. No business that would need Oracle will run Oracle software knowingly violating the license.
It’s also likely in violation of arcane copyright law. The oracle wire protocol includes a handshake procedure that sends a poem in one of the initial messages. It’s untested legal theory whether copying that poem in a new work (e.g. a new driver or compatability layer) would violate Oracle’s copyright on the poem. https://dacut.blogspot.com/2008/03/oracle-poetry.html
Earlier quoted context omitted.
The software license will still stop you from doing that. No business that would need Oracle will run Oracle software knowingly violating the license.
It’s also likely in violation of arcane copyright law. The oracle wire protocol includes a handshake procedure that sends a poem in one of the initial messages. It’s untested legal theory whether copying that poem in a new work (e.g. a new driver or compatability layer) would violate Oracle’s copyright on the poem. https://dacut.blogspot.com/2008/03/oracle-poetry.html
http://www.rcfp.org/sites/default/files/docs/20120105_202426... is when Apple tried to get the haiku protected as a trade secret
Bonus fun fact: Once the “don’t steal Mac OS” kext is loaded, a longer poem is loaded into memory (at least, it was around Tiger):
Your karma check for today:
There once was was a user that whined
his existing OS was so blind,
he’d do better to pirate an OS that ran great
but found his hardware declined.
Please don’t steal Mac OS! Really, that’s way uncool.
(C) Apple Computer, Inc.
(https://www.zdnet.com/article/apple-warns-off-os-pirates-wit...)
Earlier quoted context omitted.
Postgres has it https://www.postgresql.org/docs/current/rules-materializedvi...
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.