InstabilSpielt
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?
Shouldn't it be the other way around?
Last edited:
SQLite file location
- Thread starter InstabilSpielt
- Start date
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.
InstabilSpielt
Member
I would like to customize that so we can keep the database in sync across RadioBOSS instances on different servers.
Last edited:
InstabilSpielt
Member
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.
If you need to use it across multiple computers, you should use MySQL/MariaDB - SQLite is not a good option for your case.
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.
InstabilSpielt
Member
You probably mean that: https://www.sqlite.org/howtocorrupt.html#_filesystems_with_broken_or_missing_lock_implementations
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.
InstabilSpielt
Member
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.
I would just like to select on which drive the database should be stored.
Last edited:
Currently SQLite database location in RadioBOSS can't be changed, I'm sorry.
InstabilSpielt
Member
Are there any plans to implement this in the future?
I'm sorry but no. No one ever asked before about changing database location - so there's very little demand for it.
lucawieczorek
New member
Was searching for a solution for this problem...
Would also welcome the function, is it such a big effort to integrate?
Would also welcome the function, is it such a big effort to integrate?
What problem do you need to be solved?
lucawieczorek
New 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).