MySQL : latest version

[I2BRT]

HI !
I migrated all my programs to a new computer with windows 11.
I reinstalled Log4OM and copied the various configuration files.
No problem, all good. 100% working.

On the previous computer with windows 10 I had chosen to use a MySQL instance.
At the moment on the new computer I have been using Sqlite.
Now I wanted to switch to a database server.
I have a question.

In terms of (1) performance and (2) compatibility, is the MySQL Community Server 9.1.0 Innovation version the best or is it better to use MySQL Community Server 8.4.3 LTS or MySQL Community Server 8.0.40 ?
The 8.0.40 version has a convenient installer with everything in one package but there are no problems at all installing the workbench component or anything else needed.
I tend to always install the latest versions that should be better in terms of performance and problem solving, so I would go with 9.1 if Log4OM is 100% compatible.

For any questions about the reason for migrating to MySQL, the answer is that I am interested in a system that is as reactive and as fast as possible (I have a medium-sized log) and above all I want to be able to access the database concurrently from my other applications while using Log4OM.

In this regard, I have one last question: is there a tool to migrate data directly from Sqlite to MySql or is the procedure always to go from export adif and then import adif?

Thank you very much.
Best 73 de Rick I2BRT

[G4POP]

In this regard, I have one last question: is there a tool to migrate data directly from Sqlite to MySql or is the procedure always to go from export adif and then import adif?

Only via ADIF export/import at this time

[I2BRT]

Thank you Terry.
Ok about import/export.

About compatibility : MySQL Community Server 9.1.0 Innovation is OK for Log4OM ?

Best 73
Rick.

[I2BRT]

For what may be of interest to the community, I report the outcome of my recent tests.

I installed MySql 9 Comunity Edition which worked very well with excellent performance with Log4OM (although at the moment the Oracle workbench is still at the previous version and is not fully compatible).

In the end, however, I had to install MySQL Community Server 8.0.40 because from my tests it turned out to be the only database server version that still has the possibility that allows me to use "Legacy Authetication"

MySQL.jpg (78.33 KiB) Viewed 1619 times

At the moment legay authentication seems to be a requirement by "JT Alert", a utility that I often use and that I don't want to abandon as it is very well made for my preferences.

MySQL version 8.0.40 in any case is working pretty well.

Best 73 de Rick.

[G4POP]

For what may be of interest to the community, I report the outcome of my recent tests.

I installed MySql 9 Comunity Edition which worked very well with excellent performance with Log4OM (although at the moment the Oracle workbench is still at the previous version and is not fully compatible).

In the end, however, I had to install MySQL Community Server 8.0.40 because from my tests it turned out to be the only database server version that still has the possibility that allows me to use "Legacy Authetication"

MySQL.jpg

At the moment legay authentication seems to be a requirement by "JT Alert", a utility that I often use and that I don't want to abandon as it is very well made for my preferences.

MySQL version 8.0.40 in any case is working pretty well.

Best 73 de Rick.

TU