Re: [julia-users] Oracle ODBC

[John Kim]

Yes, that's correct.  To use the RORACLE package in R, you need to have the 
Oracle client installed also.  But it seems that's also the case with ODBC 
according to the first reply to this post.

I totally understand this is low on the priority of the things that could 
be implemented since there is already a path for database access.  But 
since Julia is targeted at high performance analysis, the Oracle benchmarks 
show that the built in OCI drives are much faster than the ODBC 
implementations (depending on the use case) so something to consider for 
the future. 


On Monday, June 27, 2016 at 7:49:49 PM UTC-7, cdm wrote:
>
>
> extending the wrapper theme ...
>
> do survey:   
> http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
>
>
>
> On Monday, June 27, 2016 at 10:30:14 AM UTC-7, Jacob Quinn wrote:
>>
>> It's probably the case that Oracle has built the drivers themselves, so a 
>> programming language would just need a wrapper library around the direct 
>> driver (similar things exist for MySQL, Postgres, etc.).
>>
>> But what Stefan said still applies, someone would have to take the 
>> initiative to build the wrapper library around the Oracle driver and 
>> provide a Julia package. Probably not a terribly hard project (basically 
>> lots of ccalls and some julia-level interface design), but where ODBC 
>> provides a connection more-or-less out of the box, it cuts down a little on 
>> the pressing need.
>>
>> -Jacob
>>
>

Re: [julia-users] Oracle ODBC

[cdm]

extending the wrapper theme ...

do survey: 
  
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html



On Monday, June 27, 2016 at 10:30:14 AM UTC-7, Jacob Quinn wrote:
>
> It's probably the case that Oracle has built the drivers themselves, so a 
> programming language would just need a wrapper library around the direct 
> driver (similar things exist for MySQL, Postgres, etc.).
>
> But what Stefan said still applies, someone would have to take the 
> initiative to build the wrapper library around the Oracle driver and 
> provide a Julia package. Probably not a terribly hard project (basically 
> lots of ccalls and some julia-level interface design), but where ODBC 
> provides a connection more-or-less out of the box, it cuts down a little on 
> the pressing need.
>
> -Jacob
>

Re: [julia-users] Oracle ODBC

[Jacob Quinn]

It's probably the case that Oracle has built the drivers themselves, so a
programming language would just need a wrapper library around the direct
driver (similar things exist for MySQL, Postgres, etc.).

But what Stefan said still applies, someone would have to take the
initiative to build the wrapper library around the Oracle driver and
provide a Julia package. Probably not a terribly hard project (basically
lots of ccalls and some julia-level interface design), but where ODBC
provides a connection more-or-less out of the box, it cuts down a little on
the pressing need.

-Jacob

On Mon, Jun 27, 2016 at 10:23 AM, Stefan Karpinski 
wrote:

> Given how expensive Oracle databases are, creating a direct driver isn't
> really a plausible open source endeavor, so this is unlikely to happen
> unless someone who actually has an Oracle database builds it themselves or
> pays for it to be built (e.g. through Julia Computing
> ).
>
> On Sun, Jun 26, 2016 at 8:51 PM, John Kim  wrote:
>
>> In R, there are direct Oracle OCI drivers.  According to the oracle
>> benchmarks, they are 3x faster than the ODBC versions.  Any idea if direct
>> OCI will be supported for Julia?
>>
>>
>> On Monday, May 9, 2016 at 1:03:25 AM UTC-7, Stefan Karpinski wrote:
>>>
>>> You have to install ODBC drivers yourself – the Julia package just
>>> provides an interface to them.
>>>
>>> On Mon, May 9, 2016 at 5:27 AM, John Kim  wrote:
>>>
 Hello

 I'm new to Julia and would like to start using it for various
 projects.  One such project requires me to access an Oracle database.  when
 using the ODBC package, the listdrivers() command only shows PostgreSQL and
 MySQL drivers installed by default.  Are Oracle drivers available for
 Julia?

>>>
>>>
>

Re: [julia-users] Oracle ODBC

[Stefan Karpinski]

Given how expensive Oracle databases are, creating a direct driver isn't
really a plausible open source endeavor, so this is unlikely to happen
unless someone who actually has an Oracle database builds it themselves or
pays for it to be built (e.g. through Julia Computing
).

On Sun, Jun 26, 2016 at 8:51 PM, John Kim  wrote:

> In R, there are direct Oracle OCI drivers.  According to the oracle
> benchmarks, they are 3x faster than the ODBC versions.  Any idea if direct
> OCI will be supported for Julia?
>
>
> On Monday, May 9, 2016 at 1:03:25 AM UTC-7, Stefan Karpinski wrote:
>>
>> You have to install ODBC drivers yourself – the Julia package just
>> provides an interface to them.
>>
>> On Mon, May 9, 2016 at 5:27 AM, John Kim  wrote:
>>
>>> Hello
>>>
>>> I'm new to Julia and would like to start using it for various projects.
>>> One such project requires me to access an Oracle database.  when using the
>>> ODBC package, the listdrivers() command only shows PostgreSQL and MySQL
>>> drivers installed by default.  Are Oracle drivers available for Julia?
>>>
>>
>>

Re: [julia-users] Oracle ODBC

[John Kim]

In R, there are direct Oracle OCI drivers.  According to the oracle 
benchmarks, they are 3x faster than the ODBC versions.  Any idea if direct 
OCI will be supported for Julia?


On Monday, May 9, 2016 at 1:03:25 AM UTC-7, Stefan Karpinski wrote:
>
> You have to install ODBC drivers yourself – the Julia package just 
> provides an interface to them.
>
> On Mon, May 9, 2016 at 5:27 AM, John Kim  
> wrote:
>
>> Hello
>>
>> I'm new to Julia and would like to start using it for various projects.  
>> One such project requires me to access an Oracle database.  when using the 
>> ODBC package, the listdrivers() command only shows PostgreSQL and MySQL 
>> drivers installed by default.  Are Oracle drivers available for Julia?  
>>
>
>

Re: [julia-users] Oracle ODBC

[Stefan Karpinski]

You have to install ODBC drivers yourself – the Julia package just provides
an interface to them.

On Mon, May 9, 2016 at 5:27 AM, John Kim  wrote:

> Hello
>
> I'm new to Julia and would like to start using it for various projects.
> One such project requires me to access an Oracle database.  when using the
> ODBC package, the listdrivers() command only shows PostgreSQL and MySQL
> drivers installed by default.  Are Oracle drivers available for Julia?
>

[julia-users] Oracle ODBC

[John Kim]

Hello

I'm new to Julia and would like to start using it for various projects. 
 One such project requires me to access an Oracle database.  when using the 
ODBC package, the listdrivers() command only shows PostgreSQL and MySQL 
drivers installed by default.  Are Oracle drivers available for Julia?