How can we use Espocrm with oracle or postgreSQL?

[tapnm]

How can we use Espocrm with oracle or postgreSQL?

[shalmaxb]

Over the years there have been several threads with this subject. In 2016/2017 it was (perhaps) planned to integrate it and there is one thread, where yuri told, that it maybe possible, besides being a bit tricky.
To sum up: for now not possible.

[yuri]

No support. But it won't be so hard to write an implementation. It's only needed to implement one PHP interface. Anyone can try. We can't afford implementing it officially as it will be a huge burden for us to maintain at the moment.

[tapnm]

Over the years there have been several threads with this subject. In 2016/2017 it was (perhaps) planned to integrate it and there is one thread, where yuri told, that it maybe possible, besides being a bit tricky.
To sum up: for now not possible.

Hi shalmaxb,
so now, i can implement that? if can, you can give me some guidlime to do?

[tapnm]

No support. But it won't be so hard to write an implementation. It's only needed to implement one PHP interface. Anyone can try. We can't afford implementing it officially as it will be a huge burden for us to maintain at the moment.

Good hear that, so can you advise me and we can do together?

[yuri]

Interface:

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/QueryComposer/QueryComposer.php

A MySQL implementation is in the same folder.

Extend the new PostgresQueryComposer class from the BaseQueryComposer. Make same amendments specific to Postgres (pagination, identifier quoting). The last step would be fixing functions that do not work in Postgres.

[tapnm]

Interface:

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/QueryComposer/QueryComposer.php

A MySQL implementation is in the same folder.

Extend the new PostgresQueryComposer class from the BaseQueryComposer. Make same amendments specific to Postgres (pagination, identifier quoting). The last step would be fixing functions that do not work in Postgres.

good advise, Thank Yuri, Can i connect with you in another channel get discuss more?

[yuri]

Unfortunately, I don't have such. Please write questions here on the forum.

[yuri]

As of v7.4 Espo supports PostgreSQL experimentally.

https://github.com/espocrm/espocrm/issues/2605