SQLite file location

Hi, why is it possible to change the dedicated SQLite file path but not the shared one?
Shouldn't it be the other way around?
 
Last edited:

djsoft

Well-known member
Staff member
Hi, why is it possible to change the dedicated SQLite file path but not the shared one?
Shouldn't it be the other way around?
The shared means usable by multiple RadioBOSS instances (and they all need to "know" this path - so if you change it you need to change it for all instanced), while dedicated is for one instance only so its path can be configured freely.
 
The shared means usable by multiple RadioBOSS instances (and they all need to "know" this path - so if you change it you need to change it for all instanced)
I would like to customize that so we can keep the database in sync across RadioBOSS instances on different servers.
 
Last edited:
I just noticed that it's not even possible to change the dedicated file path, if you apply the change and restart RadioBOSS the path resets.
 

djsoft

Well-known member
Staff member
I would like to customize that so we can keep the database in sync across RadioBOSS instances on different servers.
If you need to use it across multiple computers, you should use MySQL/MariaDB - SQLite is not a good option for your case.

I just noticed that it's not even possible to change the dedicated file path, if you apply the change and restart RadioBOSS the path resets.
It could be that all paths are fixed (I'm reluctant to check it in the tech docs :) ). As stated above, please consider using MySQL instead, it's way better in terms of performance and stability if you need a shared database used from multiple computers.
 

djsoft

Well-known member
Staff member
I already know this problem, therefore all our VM's have access to a hard disk instead of a network drive. So it makes no difference on which drive the database is located.
Not only this, also performance issues. If you need shared access from multiple computers, you should use a more appropriate solution like MariaDB.
 
As said, in our case (and certainly others as well) it really makes no difference if the path starts with C:/ or D:/, because these are two identical hard disks. So it makes no difference if other RadioBOSS instances on the same server access the database or on different ones (https://www.sqlite.org/whentouse.html).

I would just like to select on which drive the database should be stored.
 
Last edited:

djsoft

Well-known member
Staff member
Putting the database on another hard drive, in my case I would like to have it on the SSD instead of the older HDD
Database size in RadioBOSS is very little, so drive performance doesn't matter much in this case. If you need overall performance improvement, you can make SSD drive the system drive, in this case, SQLite database that RadioBOSS uses will also be on that drive.
Another way to change the database location is to use MySQL - you can install it on the same computer or on another one (with network access).
 
Top