Symfony 7 and Laravel 10 no longer supported

[JulianMar]

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]

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?

• Check if CrateDB DBAL can be used with PostgreSQL PDO instead of CrateDB PDO #107

[...] 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:

• Connect to CrateDB and CrateDB Cloud using PHP PDO (PDO_PGSQL)
• Connect to CrateDB and CrateDB Cloud using AMPHP/PostgreSQL

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]

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]

@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]

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 #132? Is it important to you to stick to the HTTP protocol, or doesn't it matter much to you in general?

[amotl]

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]

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]

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

• Add compatibility with Doctrine DBAL 3.x and 4.x #106
• Check if CrateDB DBAL can be used with PostgreSQL PDO instead of CrateDB PDO #107

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.

[amotl]

Support for Symfony 7.x and 8.x

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

We can see Symfony 7.0 started depending on doctrine/persistence and doctrine/event-manager, instead of doctrine/orm like before.

Because the version constraint up to most recent Symfony 8.1 is "doctrine/persistence": "^3.1|^4", our patch to update to DBAL 3 with GH-122 could really make a difference here, right? ¹

/cc @JulianMar, @ricohumme, @andythedandy

Footnotes

1. We had the fear we would need to work on DBAL 4 support right away with Support for Doctrine DBAL 4 (COLLAB) #148, based on ingredients of @JulianMar's Support for Doctrine DBAL 4 (DRAFT) #136, in the spirit that we thought DBAL 3 will not make much of a difference for users of contemporary framework versions today. We are happy to learn different, so we can defer the update to DBAL 4 for a few more weeks. 🍀 ↩

[amotl]

Support for Laravel 10.x

Laravel 10 depends on "doctrine/dbal": "^3.5.1". Laravel 11 stopped depending on DBAL at all, and is now only using ext-pdo as a fundamental dependency?

In this spirit, updating to DBAL 3 with GH-122 will also make a positive difference for people using Laravel 10. Other than this, @michabbb shared a recipe how to use modern Laravel with vanilla PDO_PgSQL and Illuminate/Database, thanks!

• Document use with Laravel crate-pdo#194 (comment)
• https://github.com/illuminate/database