OpenResty and Oracle RDBMS

sdmrnv · 2019-06-13T23:35:24+00:00

Hi,I'm building OR from source, and all "restydoc-index" take up to 90% of the build time. How I can I skip any and all docs steps in the build...

OpenResty and Oracle RDBMS

sdmrnv

Hello!

There are many excellent modules in OpenResty such Resty-Redis, Resty-MySQL and so on. But there is no module for working with most popular DB in enterprise - Oracle RDBMS. As I know Oracle has closed net protocol (Oracle Net) for communications between Oracle Server and Oracle Clients (principal schema is: Client Program<->(O)racle(C)all(I)interface<->Oracle Net<->Oracle Server). Does it mean that there are no possibilities to write "OpenRestyOracle" module that uses cosocket API and works on the same principles as RestyRedis or RestyMySQL?

Regards,

sdmrnv

jim.robinson

Speaking off the cuff what I'd probably do if I needed to integrate OpenResty with any DBMS is to reach for an http interface. There are lots of apis, such as Java JDBC, that could be used to build an http service point that accepts SQL and returns responses from the DBMS. OpenResty could be used to talk to such an http based service point cleanly using cosocket APIs (e.g., using lua-resty-http).

sdmrnv

Hello!

Thank you for answer! Similar idea visited me. Build middle-layer receiver (that uses http or another protocol) for the end clients and this receiver communicates with Oracle DB via OCI. But my concern in this case is that I will lose advantage of using cosocket API. As variant I can build C-library that will work with Oracle DB via OCI and build LUA wrapper for this library. But this is not cosocket API approach such realized in Resty-Redis, RestyMySQL.

Regards, sdmrnv

пятница, 14 июня 2019 г., 15:32:28 UTC+3 пользователь Jim Robinson написал:

Speaking off the cuff what I'd probably do if I needed to integrate OpenResty with any DBMS is to reach for an http interface. There are lots of apis, such as Java JDBC, that could be used to build an http service point that accepts SQL and returns responses from the DBMS. OpenResty could be used to talk to such an http based service point cleanly using cosocket APIs (e.g., using lua-resty-http).

jim.robinson

As far as I was aware lua-resty-http uses the co-socket API. Am I misunderstanding something here?

On Friday, June 14, 2019 at 6:42:18 AM UTC-7, sdmrnv wrote:

Hello!

Thank you for answer! Similar idea visited me. Build middle-layer receiver (that uses http or another protocol) for the end clients and this receiver communicates with Oracle DB via OCI. But my concern in this case is that I will lose advantage of using cosocket API. As variant I can build C-library that will work with Oracle DB via OCI and build LUA wrapper for this library. But this is not cosocket API approach such realized in Resty-Redis, RestyMySQL.

Regards, sdmrnv

пятница, 14 июня 2019 г., 15:32:28 UTC+3 пользователь Jim Robinson написал:
Speaking off the cuff what I'd probably do if I needed to integrate OpenResty with any DBMS is to reach for an http interface. There are lots of apis, such as Java JDBC, that could be used to build an http service point that accepts SQL and returns responses from the DBMS. OpenResty could be used to talk to such an http based service point cleanly using cosocket APIs (e.g., using lua-resty-http).

sdmrnv

It's another approach: Web Browser<--->OpenResty<---->lua-resty-http<---->Oracle HTTP Server/Oracle RESTfull API<------>Oracle RDBMS

My question was about excluding HTTP component from the chain above and using something like: Web Browser<---->lua-resty-oracle<--->Oracle RDBMS

пятница, 14 июня 2019 г., 16:57:01 UTC+3 пользователь Jim Robinson написал:

As far as I was aware lua-resty-http uses the co-socket API. Am I misunderstanding something here?

On Friday, June 14, 2019 at 6:42:18 AM UTC-7, sdmrnv wrote:
Hello!

Thank you for answer! Similar idea visited me. Build middle-layer receiver (that uses http or another protocol) for the end clients and this receiver communicates with Oracle DB via OCI. But my concern in this case is that I will lose advantage of using cosocket API. As variant I can build C-library that will work with Oracle DB via OCI and build LUA wrapper for this library. But this is not cosocket API approach such realized in Resty-Redis, RestyMySQL.

Regards, sdmrnv

пятница, 14 июня 2019 г., 15:32:28 UTC+3 пользователь Jim Robinson написал:
Speaking off the cuff what I'd probably do if I needed to integrate OpenResty with any DBMS is to reach for an http interface. There are lots of apis, such as Java JDBC, that could be used to build an http service point that accepts SQL and returns responses from the DBMS. OpenResty could be used to talk to such an http based service point cleanly using cosocket APIs (e.g., using lua-resty-http).