Log4OM

Is there any benefit to changing from a sqlite db to a mysql db? I only have about 3200 qso's in my sqlite db I'm using now but was just curious to know if there was any advantage in upgrading to mysql.

The SQLite library is quite small compared to a MySQL server installation (about 250 kB vs 600 MB). In SQLite everything is stored in one file, making it very easy to copy and backup. No configurations are required for SQLite, therefore it‘s very easy to use.

SQLite does not have any specific User Management functionality and hence is not suitable for multiple user access. MySQL has a well-constructed User Management system which can handle multiple users and grant various levels of permissions.

SQLite is suitable for smaller databases. As the database grows the memory requirement also gets larger while using SQLite. On my computer I have not seen much performance differences with about 32.000 QSOs, and none with 15k. Nevertheless, MySQL is easily scalable and can handle a bigger database with less effort.

If you‘re not a database administrator or know what you‘re doing using MySQL does not make any sense, definitely not with 3200 QSOs.

73,
Claus

I run a test database with over 100000 QSO's and on a reasonable PC the speed is fine

w5cib wrote: 30 Aug 2022, 05:27 Is there any benefit to changing from a sqlite db to a mysql db? I only have about 3200 qso's in my sqlite db I'm using now but was just curious to know if there was any advantage in upgrading to mysql.

I used for a while, the MariaDB.
Works 100% and is very simple to setup and BKP.

Now I am using defaulT SQLlite, coming to 5000 QSOs (4980)..... waiting for see. In log, shows only 5000. I changed to 10000, but back to 5000.

PY2AD wrote: 31 Aug 2022, 14:17

w5cib wrote: 30 Aug 2022, 05:27 Is there any benefit to changing from a sqlite db to a mysql db? I only have about 3200 qso's in my sqlite db I'm using now but was just curious to know if there was any advantage in upgrading to mysql.

I used for a while, the MariaDB.
Works 100% and is very simple to setup and BKP.

Now I am using defaulT SQLlite, coming to 5000 QSOs (4980)..... waiting for see. In log, shows only 5000. I changed to 10000, but back to 5000.

User guide describes how to set the default number of QSO's displayed, this is not the max number of QSO's in the database that is unlimited