Tweet
How can we use Espocrm with oracle or postgreSQL?
-
-
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. -
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.Last edited by yuri; 08-16-2022, 05:52 PM.If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
-
Interface:
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.
If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
-
good advise, Thank Yuri, Can i connect with you in another channel get discuss more?Interface:
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.Comment
-
As of v7.4 Espo supports PostgreSQL experimentally.
If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
Comment