Firebird Database SAM Broadcaster
SAM Broadcaster comes with four different options of database install.
Of the 4 different database options that come with SAM Broadcaster, Firebird appears to be the most unstable database of the four options.
We often see someone complaining that the Firebird database in SAM Broadcaster has crashed on them.
The Firebird database only allows you to load a maximum of 50,000 songs into SAM Broadcaster. So it’s not great if you have a huge music collection.
The MySQL database in SAM Broadcaster doesn’t fare much better as that’s also prone to crashing or becoming corrupted especially if SAM crashes without warning.
The SQL database in RadioDJ is far more stable and lets you load as many songs as you need.
Plus the MySQL server & database in RadioDJ isn’t that difficult to setup.
The database in RadioDJ seems to be a lot more robust and stable. (It’s over 2 years since we last rebuilt of database from scratch)
You can find a tutorial on how to setup an SQL server here.
The Firebird database that comes with SAM Broadcaster just isn’t fit for purpose. It’s just another reason to stop buying software from Spacial Audio.
**Update July 2017**
Spacial Audio’s code monkeys appear to have done some work to the Firebird Table structure.
v2017.6 (3 July 2017) * Updated database structure for FireBird and MySQL to be more consistent across databases.
We will wait to see what we see from users of the software as to whether this makes SAM Broadcaster more stable (Only time will tell)
Last updated on: July 22nd, 2017
at 12:09 PM Europe/London