[FEATURE]: Support MySQL 5.7

[danielsharvey]

Describe what you want

What are the chances of adding/maintaining support for MySQL 5.7?

Drizzle 0.26 worked but the 0.28 (primarily lateral joins from what I can see) removes support for 5.7.

I've tried the "planetscale" mode but this does not work - it removes lateral joins specifically but appears to maintain the column reference which the lateral join allows (I may have misinterpreted).

Thanks

[Antor666777]

hey, do your dirzzle orm running mysql runs in nextjs middleware? mine doesn't works i don't know why can you please let me know

[danielsharvey]

hey, do your dirzzle orm running mysql runs in nextjs middleware? mine doesn't works i don't know why can you please let me know

I'm not sure I understand your question. However, I have Drizzle 0.26 working with one small change required to handle the lack of json_arrayagg() in MySQL 5.7.

[Antor666777]

Thanks for the update

[steve-taylor]

This is definitely needed. AWS Aurora Serverless v1 doesn't support anything higher than 5.7. I'm using SST to deploy my web app, which doesn't and probably never will support Aurora Serverless v2. So support for MySQL 5.7 is still very much needed.

I think my workaround will be to switch to PostgreSQL 13, which hopefully Drizzle still supports. I don't think it's a great idea in general for ORMs to require the latest and greatest database versions. One of the strengths of a good ORM, such as JPA/Hibernate, is their support for databases of various vintages.

[mifi]

AWS serverless v1 is EOL December 31, 2024, so why is it important?

[danielsharvey]

There are other platforms that support MySQL 5.7. e.g TiDB https://github.com/pingcap/tidb

[conioX]

Hi @danielsharvey did you solve it? I have same problem