Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Also, their docs leave me wondering about the level of Oracle compatibility they're claiming. Their page on the subject, https://www.ivorysql.org/docs/compatibillity_features/hierar... , lists a bunch of immediate sore points -- date types and functions, the CONNECT BY query syntax, etc. But there are other things Oracle supports that are not listed, and still potentially serious stumbling blocks -- "fast" (incremental) automatic refresh of materialized views, IGNORE NULLS in window functions, and so forth.

Oddly, I'd take their compatibility claims more seriously if they were more clearly up-front about the limits.



Am I one of the only developers who actually likes the CONNECT BY queries? Often I think they are a very succinct alternative to recursive CTEs.


I'll just fire this up, create some external tables, and use the v7 join syntax to write out my data with utl_file.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: