Is there a schedule to support MySQL?

Question

Is there a schedule to support MySQL?

theplacefordev opened this issue 3 years ago · 13 comments

Thank you for the great library! Do you consider to support MySQL? It does support locking features https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html to implement distributed locking on top of it.

Thanks in advance.
Rustam

theplacefordev commented 3 years ago

#24

Answer 1 · 2021-06-25T18:25:41.000Z

@theplacefordev I'd be open to adding this; seems straightforward. Would you be willing to test out a prerelease package and confirm that it is functioning as expected?

Answer 2 · 2021-07-08T15:19:56.000Z

@madelson yes, of course. Thanks in advance!

Answer 3 · 2021-07-23T11:14:37.000Z

@theplacefordev as I've started working on this I noticed that there seem to be 2 popular drivers: https://www.nuget.org/packages/MySql.Data/ and https://www.nuget.org/packages/MySqlConnector/.

I'm curious which of these you have experience with and whether you think one or the other seems like a better default?

Answer 4 · 2021-07-28T01:26:56.000Z

Actually, seems like we'll have to use MySqlConnector as the default because it has better license terms.

Answer 5 · 2021-08-24T21:15:23.000Z

@madelson I use it with EF Core and Pomelo.EntityFrameworkCore.MySql provider which is using MySqlConnector, so it works for me

Answer 6 · 2021-08-24T23:53:29.000Z

Thanks @theplacefordev ! I am close to having an alpha package out.

Answer 7 · 2021-08-25T00:58:20.000Z

@theplacefordev I've published a release candidate version: https://www.nuget.org/packages/DistributedLock.MySql/1.0.0-rc01

Would you mind giving it a try and confirming that it works for you?

Answer 8 · 2021-08-29T21:03:10.000Z

@madelson sure I will try it tomorrow. Thanks a lot!

Answer 9 · 2021-09-04T00:23:22.000Z

FYI, MySqlConnector is the only MySQL ADO.NET library that supports asynchronous operations; all "Async" methods in MySql.Data operate synchronously: https://bugs.mysql.com/bug.php?id=70111.

Answer 10 · 2021-09-09T10:44:56.000Z

@theplacefordev not rush but did you get a chance to try this library?

Answer 11 · 2021-09-23T14:43:40.000Z

@madelson Sorry for the delay. I've tested it on my laptop with MySql 5.7, .NET Core 3.1, EF 5, and MySqlConnector 1.3.11 - it seems to works for my test cases. Thank you!

Answer 12 · 2021-09-26T21:37:02.000Z

Thanks! I'll get a stable version merged soon! Re-opening for now to remind me.