mySQL update to v8

[FraglyG]

I love quickdb.js, though it seems I can't use it on hosting services like railway because the underlying mysql isn't up to date and thus doesn't support mysql v8

an update to mysql v8 would be super cool

[Zelak312]

Thank your for this. I will be looking into it. I will probably be changing the library quick.db is using currently

[Zelak312]

I looked into it and you are right. v8 of mysql is not supported by the module we use which is promise-sql. promise-sql uses mysqljs/mysql which doesn't support it yet. you can see here a pull request that was open about it for a while now but doesn't seem to have progressed much mysqljs/mysql#2233

I seen that people are making a mysql2 library which seems as popular as the mysql one. I didn't see any problems on their github mentionning incompatibility with v8. I will be testing if this library works and if it does, I will be changing quick.db to use this one instead (should be done today or this weenkend)

[Zelak312]

This should be fixed now!