Oracle Database Connection - Include in your road-map.

[sanket3999]

I am oracle pl/sql developer having 8 years of experience. From last 8 years, I always curious to have nice developer tool for oracle pl/sql development. Atom is nice platform over you had already put some efforts to include opensource database connections and it's usage.

I also have good hand on MEAN.JS stack from last 2 years. I thought, it's nice to have oracle development capabilities within the atom editor. If you may include this in your road-map then it will be great. In terms of any help you need for contribution part for the development of this project then also contact me.

mail : [email protected]

--Sanket Patel

[lukemurray]

Hi, If you're willing to tackle Oracle support, that would be great. But you'll likely be supporting it too as I don't have Oracle DBs anywhere nor the time to support another one.

You could start by looking how the PostgreSQL is implemented. Look at postgres-manager.js and create an oracle-manager hook it into db-factory.js.

I'm also looking at how to provide a better API to implement and potentially split these into separate packages.

PRs are most welcome :)

[sanket3999]

Hi,

I will be open to support for the oracle related changes. I might need some initial help to include the changes related to oracle.

If possible please share IM/skype address to connect with you.

Thanks,

Sanket

---

From: Luke Murray [email protected] Sent: Tuesday, May 3, 2016 6:07:52 AM To: lukemurray/data-atom Cc: Sanket Patel; Author Subject: Re: [lukemurray/data-atom] Oracle Database Connection - Include in your road-map. (#68)

Hi, If you're willing to tackle Oracle support, that would be great. But you'll likely be supporting it too as I don't have Oracle DBs anywhere nor the time to support another one.

You could start by looking how the PostgreSQL is implemented. Look at postgres-manager.js and create an oracle-manager hook it into db-factory.js.

I'm also looking at how to provide a better API to implement and potentially split these into separate packages.

PRs are most welcome :)

You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/lukemurray/data-atom/issues/68#issuecomment-216404945

[lukemurray]

Hey, that sounds great. Sorry I'm travelling for a little while and will be hard to get on skype. I'll reach out in a few weeks. Until then, have a look at postgres-manager.js and how that is used in the system. You'll need to find a nice Oracle node library as well.

I'll touch base again when I'm done travelling.

Thanks

[lukemurray]

Hey Sanket, how did you go? Do you have any questions? I'd be looking at this package for actually working with the DB https://github.com/oracle/node-oracledb

[sanket3999]

Luke,

I was struggling to setup existing code in local, then got some of the projects on which have to work so move ahead with that.

If you share me some knowledge to setup existing code then it will be helpful to me - to move ahead.

Thanks,

Sanket

---

From: Luke Murray [email protected] Sent: Friday, May 13, 2016 5:29:18 PM To: lukemurray/data-atom Cc: Sanket Patel; Author Subject: Re: [lukemurray/data-atom] Oracle Database Connection - Include in your road-map. (#68)

Hey Sanket, how did you go? Do you have any questions? I'd be looking at this package for actually working with the DB https://github.com/oracle/node-oracledb

You are receiving this because you authored the thread. Reply to this email directly or view it on GitHubhttps://github.com/lukemurray/data-atom/issues/68#issuecomment-219023997

[lukemurray]

• Check out this repo somewhere locally.
• Navigate to the repo directory with the command line
• Run apm link to link the code to Atom packages
• Run apm install to install dependencies
• Open atom
• Open the repo folder
• start coding :)
• Run the Reload command in atom to reload you changes

[eugenweissbart]

I may participate in near future

[ghost]

I'm seriously interested in this feature. If I can find some time I may take up work on this.

[sanket3999]

If you can help me to start then will be ready to contribute.

• Sanket

---

From: Dennis Rausch [email protected] Sent: Thursday, September 22, 2016 8:36:15 PM To: lukemurray/data-atom Cc: Sanket Patel; Author Subject: Re: [lukemurray/data-atom] Oracle Database Connection - Include in your road-map. (#68)

I'm seriously interested in this feature. If I can find some time I may take up work on this.

You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/lukemurray/data-atom/issues/68#issuecomment-248931289, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALwE-Yzzu4Mk_a5qlpkZT-ySJ3E2CdIjks5qsplngaJpZM4IR1Pk.

[lukemurray]

I would look at https://github.com/oracle/node-oracledb and see the postgres-manager.js and db-factory.js in this package as examples of how to implement a new DB.

[sanket3999]

Can you share me your Skype address so that we may be in touch ?

Get Outlook for Androidhttps://aka.ms/ghei36

On Fri, Sep 23, 2016 at 5:17 AM +0530, "Luke Murray" <[email protected]mailto:[email protected]> wrote:

I would look at https://github.com/oracle/node-oracledb and see the postgres-manager.js and db-factory.js in this package as examples of how to implement a new DB.

You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/lukemurray/data-atom/issues/68#issuecomment-249060417, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ALwE-UoNwNEhtGfo68YdxYBCwC4wdUyXks5qsxOmgaJpZM4IR1Pk.

[ghost]

Looks like node-oracledb currently has problems with babel. Should be a fix out relatively soon though.

[ghost]

So I began working on Oracle db support. There is one snag though. The NPM package oracledb has several prerequisites and requires a C compiler, Python, and installing an Oracle Instant Client. I'm trying to identify a way to make it easier. Oracle support is basically stubbed on my fork, but I didn't get to testing. https://github.com/hermitmaster/data-atom Due to the nature of Oracle, it seems like this is going to be more daunting than most other DBMS support.

[tschf]

There is one snag though. The NPM package oracledb has several prerequisites and requires a C compiler, Python, and installing an Oracle Instant Client.

I flagged this comment on Twitter and the devs chimed in - if you wanted to offer any feedback :)

https://twitter.com/ghrd/status/851988412966031360

..

On a general note, this extension looks neat! Looking forward to see what solution you come up with to get this seamlessly integrated.

[SergioSuarezGil]

Interested in this feature too! :=)

[walkabout21]

Really interested in this feature. I can use Atom for just about everything, including sqlplus development with builds, but generally jump out to SQL Developer for navigating the db and retrieving DDL or other metadata. There was a really interesting VIM project called voraX that did this well within VIM, but it just recently became unmaintained.

[elaiken3]

Any update on compatibility with Oracle DBMS? This would be a great tool to use for my business purpose.

[schmate]

Interested too. Atom and oracle-compatibility of data-atom would make a great development tool for my everyday work.

As I have seen, the starter step would still be looking how the PostgreSQL is implemented. Look at postgres-manager.js and creating an oracle-manager hook it into db-factory.js.

Looks like https://github.com/oracle/node-oracledb is maintained quite steadily, so former issues might have been solved.

[schmate]

@tschf @sanket3999 @eugenweissbart , would you mind summarizing here how each of us could contribute to this issue? I do not work in Js (I use python, R and Oracle PL/SQL as a Data Scientist), but we might have enough resources to come up with an MVP that gravitates more folks here.

Either way: I am happy to work on the small portion of the project that is in Oracle SQL.