crate / crate-dbal

Doctrine Database Access Layer for Crate.IO
Apache License 2.0
16 stars 10 forks source link

Symfony and Laravel not supported any longer #132

Open JulianMar opened 7 months ago

JulianMar commented 7 months ago

Hello,

the package is still dependant on dbal v2. The newest Release ist v4 and soon there will be v5. Symfony 7 and Laravel 10 dropped support for this dbal version.

Here is the conflict in the package.json of the Symfony package. https://github.com/symfony/symfony/blob/7.1/composer.json#L167

Do you have an idea how to upgrade?

amotl commented 6 months ago

Dear Julian,

thank you for writing in. Can you evaluate if using CrateDB's PostgreSQL interface would be a viable option, similar to what is suggested over at the proprietary CrateDB DBAL adapter?

[...] to check if it will be feasible to use the PostgreSQL protocol directly by using the PostgreSQL PDO extension.

We are maintaining two example exercises that demonstrate how to use CrateDB's PostgreSQL interface using PHP:

Please let us know if this may help in any way, so we can improve the guidance on our documentation.

With kind regards, Andreas.

amotl commented 6 months ago

On another note, please also have a look at the Crate.io driver for Laravel maintained by @RatkoR. Maybe we can bring together interested people to improve PHP support for CrateDB in one way or another, or alternatively, his adapter is exactly what you have been looking at? It claims that:

Laravel 5.5, 6, 7, 8, 9 and 10 are supported.

RatkoR commented 6 months ago

@JulianMar knows about Crate.io driver for Laravel, he has contributed much to it.

I'd also be interested in moving dbal to newer version.

amotl commented 6 months ago

Thanks for your quick response, @RatkoR.

Do you think switching over to use CrateDB's PostgreSQL interface would be a viable option to resolve the dilemma, as outlined at https://github.com/crate/crate-dbal/issues/132? Is it important to you to stick to the HTTP protocol, or doesn't it matter much to you in general?

amotl commented 5 months ago

Dear Julian,

because your question is about DBAL and Doctrine, would it be better to be carried over to https://github.com/crate/crate-dbal?

With kind regards, Andreas.

JulianMar commented 5 months ago

Hey @amotl, you are right it's more an issue of the Crate DBAL. Maybe we can try to convert it to be using the ProstgreSQL PDO. I'm not sure if I'm able to add a PR for this, but I could try. I just need some time.

amotl commented 5 months ago

Hi Julian. I've transferred the issue to the right repository. I guess both of those issues we are looking at, right?

I'm not sure if I'm able to add a PR for this, but I could try. I just need some time.

All contributions are greatly appreciated. Please take your time.