search

mithrandyr / SimplySql

PowerShell module for querying various SQL databases
MIT License
197 stars 31 forks source link

MariaDB support? #103

Closed luceat-lux-vestra closed 1 year ago

luceat-lux-vestra commented 1 year ago

I had a problem with SimplySQL. My problem was a minor, acceptable one. (I will open another issue for that problem.)

SimplySql uses the same provider for MySQL/MariaDB. The list of incompatibilities grows longer with each version. - From Wikipedia

Thus, need to separate them to support MariaDB correctly I think.

mithrandyr commented 1 year ago

@luceat-lux-vestra -- thank you for sharing this -- I read through the article and the issues seem to be at the database level and not at the connector level. I.E. that a MySQL provider will work just fine against either MySql or MariaDB. image

SimplySql just wraps a provider and exposes common provider interactions via powershell cmdlets. So I'm not clear why SimplySql would need a different provider for MariaDB, can you help me to see the where the difference exists at the provider level?

luceat-lux-vestra commented 1 year ago

I think you're right.

It's my fault.

Thanks for your kind reply.