Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

IvorySQL: Open-source Oracle-compatible PostgreSQL

github.com

Post reply on HN
Print view View original

41–50 of 73 posts

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#41

Post by tomrod »

Alupis wrote: post #12
pfix wrote: post #4

I don't get what this is. Is this a postgres fork? An extension? The documentation says it's Version 2 but the docs are rather lacking. Having something providing an "Oracle API" on Postgres would be awesome but not sure if this works like that?

Can someone elaborate on what specifically something like this would be used for? I would imagine if you're going through the pain of migrating off Oracle, picking something like IvorySQL is just a half-measure. Why not just make the switch to PostgreSQL (or other) and be done with worrying about compatibility? How long will this project last, and how great will the compatibility actually be - is it a drop-in replace…

'' is NULL in Oracle. The switch is non-trivial.

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#44

Post by Justsignedup »

So correct me if I am mis-understanding...

it has to be in oracle or pg compatibility mode, so effectively its just an oracle api replacement, but should more or less behave like oracle

so the only primary benefit is you stop paying oracle because you just want to leave oracle?

It doesn't exactly let you move away from oracle APIs though.

It is a big win financially. So good on them, I hope it gets all the traction!

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#47

Post by koolba »

kiratp wrote: post #35
supportlocal4h wrote: post #32

I want compatability in a whole different direction. Let's get really crazy and rip the db out from under vendor solutions. Let their app with its compiled in Oracle driver communicate with a Pg server. We'll completely void any support contract we have, but at least we'll be Oracle free! Can you imagine just swapping in Postgres under a Peoplesoft deployment? As long as you don't make me actually attempt it, it make…

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

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#48

Post by nielsole »

up2isomorphism wrote: post #45

What’s the point of doing some just for the sake of destroying other people’s business?

Did not find any obvious references as to who is backing this project, but it seems to be a Chinese software consultancy. https://www.highgo.ca/

> What’s the point of doing some just for the sake of destroying other people’s business?

Apart from any potential ideological reasons related to open source, they are likely planning to support their own business by providing a compelling product.

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#49

Post by ako »

Justsignedup wrote: post #43
unixhero wrote: post #37

So will this support materialized views? That's a very nice Oracle SQL feature

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.

Re: IvorySQL: Open-source Oracle-compatible PostgreSQL

#50

Post by jinseokim »

rnd0 wrote: post #13

Wiped out by Oracle's legal team (patents, whatever) in 4...3...2...

A Korean company Tmax sells Tibero, the Oracle-compatible DBMS (proprietary). AFAIK, it's quite so much "compatible" (it even has same typos with Oracle DB), and they're not sued by Oracle.
Post reply on HN