Support for oracle database?

mevdschee / php-crud-api

Single file PHP script that adds a REST API to a SQL database

MIT License

3.61k stars 1k forks source link

Support for oracle database? #460

Open 309525902 opened 6 years ago

309525902 commented 6 years ago

I am very happy to see such a good product, I want to know when your code can support the oracle database.

mevdschee commented 6 years ago

Thank you for your compliments. Oracle database is an expensive paid product. Are you willing to contribute to the effort of building support for it? If you do, then please send me an email.

simevo commented 4 years ago

Hi, can you outline the effort that would be required to write an oracle driver ? Thanks

mevdschee commented 3 years ago

I looked into installing Oracle 18c XE in the CentOS 8 docker instance. It requires binaries from:

https://www.oracle.com/database/technologies/xe-downloads.html

Install files are several gigabytes. They seem to be designed for Oracle Linux 7.

mevdschee commented 3 years ago

I tried installing Oracle 18c on CentOS 7 in a docker container. It installs fine, but now I need to configure it. Does anyone have any experience in (automatic) installation and configuration of Oracle?

mevdschee commented 3 years ago

@simevo We need to:

have automatic installation of oracle in a docker container
port the fixtures to the oracle sql variant
adjust the driver to the oracle sql variant

I'm stuck at the first step. Help with any of these steps is appreciated.

muzzol commented 2 years ago

I know this is a low priority issue, but here you can find a docker xe install for testing: https://hub.docker.com/r/gvenzl/oracle-xe

mevdschee commented 2 years ago

I know this is a low priority issue, but here you can find a docker xe install for testing:

That is a great docker instance, used by jOOQ, which tells me a lot. I will have to adjust the test script to be able to use it, but that can be done.