Posts

Showing posts with the label database software

Updating Older Versions Of RadioDJ (2042+)

Image
Recently there were some major changes to the Database connector in RadioDJ which meant newer versions wouldn't run on versions of MariaDB 10.7 and Older. Which means in order to use versions of RadioDJ 2042 and newer you will need to UPGRADE MariaDB to a newer version. I'm currently using MariaDB 11.2 and I have zero issues running RDJ 2045 If updating from an OLDER version of RadioDJ 2.x.x Apply the SQL Database Update File to your Database via Database Setup or you will get errors The Updates will be in the SQL folder of the RadioDJ Setup folder. In order to update MariaDB do the Following. Take a backup of your current database Uninstall MariaDB as per these Instructions Install a newer version of MariaDB Install the newer version of RadioDJ (2043+) and connect your database Reinstall the RadioDJ database and Restore the Backup you just took Then apply the SQL update files as pe

The Most Perfect Piece Of Music Playout Software

Image
Q: Have you ever found the most perfect piece of music playout software? I've tried LOTS of music playback software over my 20 or so years on the Internet. Winamp, Foobar, Real Player, Windows Media Player, Musicmatch Jukebox, SAM Broadcaster, SAM Party DJ Some pieces of software were OK for playing music and some of them would crash if I added a large folder of music into them. Other Radio Automation Software doesn't Crossfade very well and you end up with a CAR CRASH transition betweeen songs. RadioDJ excels at crossfading, It has a better Cue Point editor than some paid for software. It was 2010 when I first used RadioDJ and I haven't looked back since. RadioDJ has been the bedrock of my music automation since I discovered it via a search in November 2010. I THINK RadioDJ is the most PERFECT piece of music playout software ever as

Forget Oracle MySQL Server (Its Buggy)

Image
Seen more and more users who've recently had issues working RadioDJ alongside Oracle MySQL (8) server. I personally think Oracle MySQL lost their way a LONG time ago. I Wrote A While Back about this very issue it seems MySQL8 still doesn't work properly. A soon as people switched to MariaDB their issues went away (Strange That) Marius carried out out some tests a while back and its quite clear that MySQL 8 takes longer to process queries compared to MariaDB. Query Duration MySQL8: 1.7712764 seconds Query Duration MariaDB: 0.0081946 seconds As you can see the difference is Huge on MySQL8 it takes 2 seconds to run a Query I've been a MariaDB user since 2014 and its RARE I have to do any maintence on my SQL databases. IF You have been having issues with MySQL download and install MariaDB Instead! How to Install MariaDB Please Note: Some versions of MariaDB have issues with RadioDJ due to a Database update

Important: When You Make A Change In RadioDJ Backup The Database

Image
Its pretty much self explanatory... BUT IT IS IMPORTANT RadioDJ saves most of the settings in the database these days although there are some settings still taken care of by XML files. Whenever you EDIT a track be it Cue Points or Artist/Title/Album etc... You must Backup your RadioDJ using the Database Setup tool this will preserve your changes to the database. YOU CAN NEVER HAVE TOO MANY DATABASE BACKUPS! Its probably best IF YOU Backup your database onto an external Cloud server such as Google Drive. I have Google Drive monitoring my SQL backup folder as soon as I take a backup it goes up to the fluffy cloud. Its so much easier when you have settings taken care of in the database because you can set and forget. Its also dead easy for you to transfer Radio DJ to a new machine Other well known radio automation software offerings have NO way of backing up the database which is quite some FLAW. Its just ano

HeidiSQL A Simple Database Editor (MySQL/MariaDB)

Image
I love HeidiSQL as a database editing tool, It also allows me to do maintenance on my databases should the worst happen. MariaDB should automatically install Heidi SQL alongside the database engine Its taken me a few years to feel confident around editing MySQL databases but now I find it really easy to do. I have two instances of SQL servers on this PC I have Oracle MySQL 5.5.9 on Port 3306 and MariaDB 10.5.8 on Port 3007. MariaDB databases shouldn't require much housework once installed I rarely touch my databases but on the odd occasion I have to give them a quick repair. I can easily log onto to sort it with HeidiSQL and its easy to keep on top of your MySQL Server. I knew next to nothing about how to maintain an SQL server 12 years ago but I learned by reading tutorials on the Internet. HeidiSQL makes my life so much simpler I'm not having to rebuild my databases regularly like I was back

The Most Perfect Database Software?

Image
2024 will mark 10 years of me being a MariaDB user. I've used it alongside a lot of versions of RadioDJ. I'd seen someone mention in 2014 that they had found MariaDB so I went and installed it. Maria DB hasn't let me down. I can't even remember the last time I had to fire up HeidiSQL to do maintenance to my databases. MariaDB is being used by some large corporations across the world! I had MariaDB powering my old website before I had to cancel the VPS due to technical issues beyond my control. On my VPS servers MariaDB performed amazingly well compared to MySQL Community Server from Oracle. The author of RadioDJ did a few tests and it appears that MariaDB processes SQL queries fast than Oracle MySQL. I had nothing but headaches with Oracle MySQL community server I only ever do a bit of basic housework with MariaDB. I optimise my RadioDJ database every day by an event. Its been a LONG time