2 ms·

After using Oracle 15 years ago, then mostly using mysql, I had to use Oracle again last year and you know what? It's crap! OCI is a ridiculous, error-prone API

by dwj 14y ago

After using Oracle 15 years ago, then mostly using mysql, I had to use Oracle again last year and you know what? It's crap! OCI is a ridiculous, error-prone API that takes a bunch of code to do anything at all.

hnriot 14y ago
"takes a bunch of code to do anything at all." I presume you mean the boilerplate code to bind variables and such. If you're not a fan of OCI why not use JDBC, ODBC, cx_Oracle etc, you don't need to use OCI, there are many other interfaces that make life easier. OCI is the low level interface for programmers not scared of a few lines of code. You'll find that you quickly abstract away the boilerplate in your application, and it's really not that hard. OCI has been around for a long time...
- dwj 14y ago
  Oh, if you knew me you'd know that I'm not afraid of a few lines of code, and I'm not afraid of low-level stuff :) My point is that when you compare OCI to the C API for mysql, it takes a lot less code to use the mysql C API, and it is much less error prone. And it doesn't make sense to either use a wrapper or figure out some framework when it's a one-time project that I'm charging at an hour or two of my time.