Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-06-17 Thread Toby Thain
On 17-Jun-09, at 10:03 AM, Markus Hoenicka wrote: Hi, Quoting Michael Friedrich michael.friedr...@univie.ac.at: I will need to step further into the driver but I wanted to ask * is the driver still in development or left alone? I'd say the driver is pretty much dormant. The latest

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-04 Thread Markus Hoenicka
vincent rogier writes: For example, instead of using cached values (that need extra memory from dbbdi core module while the driver sometimes already hold cached values), the public dbdbi functions like dbi_result_get_int() could use callback to specific drivers functions that delivers the

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-03 Thread Toby Thain
On 2-May-09, at 7:15 PM, vincent rogier wrote: No, the sqllite trick cannot be used with Oracle... And even if it was possible, it is not a serious option because it would kill the driver performance People are still coding DB apps in C If it doesn't need to be database independent

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-03 Thread vincent rogier
Hi toby, If it doesn't need to be database independent then there must be many efficient ways to code a C application against Oracle/{your db}. True... that's why OCILIB exists :) But implementing an underlying DB layer in a database independent framework can be in tricky (for example : Oracle,

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-03 Thread vincent rogier
Hi Christian, Few hints about the actual Oracle driver : - it cannot compile with a C90 compiler (one line of code to fix to make it compile). - LONG type is handled as an integer instead of a character based type - only few types are handled and all types mapped as strings - numeric types are

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-03 Thread Christian Stamgren
Hi Vincent, You do what is easiest for you, personally iI would like if the current driver using oracle OCI would be fixed but it is not up to me, as I am not going to write it, but it feels kosher for libdbi to use the database own library. There is a list of things I wanted to do in the

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-02 Thread vincent rogier
Hi markus, I'm coming back about an ocilib based Oracle driver for libdbi. About FreeBSD, There's no official support or package from Oracle Corp. A port has been done and seems to work. The last few weeks, i was in contact with an italian that tried to port OCILIB to FreeBSD. OCILIB compiles

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-02 Thread Markus Hoenicka
vincent rogier writes: So, i'm still suck in the ocilib based libdbo driver to set the integer type bit... For example, a column created as INT (4 bytes integer range) or NUMBER (38 digits for scale and precision that can holds integer, numeric, real, etc..) will be reported by Oracle

Re: [Libdbi-drivers-devel] libdbi oracle driver based on ocilib

2009-05-02 Thread vincent rogier
No, the sqllite trick cannot be used with Oracle... And even if it was possible, it is not a serious option because it would kill the driver performance People are still coding DB apps in C because it's faster... If a C driver has to use exotics and slow behaviors to work, what's the point ?