sqlite or mysql
sqlite or mysql
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.
Re: sqlite or 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
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
Claus, OE6CLD/DJ0DX/EI7JZ
-
G4POP
- Log4OM Alpha Team
- Posts: 11592
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: sqlite or mysql
I run a test database with over 100000 QSO's and on a reasonable PC the speed is fine
73 Terry G4POP
Re: sqlite or mysql
I used for a while, the MariaDB.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.
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.
-
G4POP
- Log4OM Alpha Team
- Posts: 11592
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: sqlite or mysql
PY2AD wrote: 31 Aug 2022, 14:17I used for a while, the MariaDB.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.
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
- Untitled.jpg (102.08 KiB) Viewed 1662 times
73 Terry G4POP
