Creating A New SQL User

In case you haven’t already noticed, SQL tends to allow some pretty insecure permissions by default, allowing root access from any computer.

This is a big problem, especially if you have port forwarding configured on your router to your SQL instance.

However, you can easily create new users using any management interface, so we’ll do it with HeidiSQL

Read the full article

Last updated on: May 17th, 2017
at 13:21 PM Europe/London

What Database Issues?

I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.

Turns out we’ve had MariaDB installed since June 2014.

In the last 36 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.

Read the full article

Last updated on: October 9th, 2017
at 13:20 PM Europe/London

RadioDJ Free Radio DJ Automation Software

What is RadioDJ?

RadioDJ is a free radio studio automation program for use by any DJ or radio station.

RadioDJ V2

You can even run multiple Shoutcast/Icecast radio stations if you want using third party virtual audio cables (VACS).

It can also be used as a home entertainment system for music. (Which is what we currently use it for)

Is RadioDJ really free?

Yes! It’s 100% Free with no nasty hidden fees or catches despite what certain software/hosting companies try claim in their blog posts. No keys, activation or patches needed to work the full program.

Eventually there will be a paid for version of RadioDJ but the free version will still be available for those who require it

Will RadioDJ work on Windows 10?

Yes RadioDJ should work on Windows 10 with very few issues. Unlike other radio automation programs that have “compatibility” issues.

Read the full article

Last updated on: December 29th, 2017
at 11:52 AM Europe/London

MariaDB & RadioDJ

We came across MariaDB after a user posted on the RadioDJ forums that they were using it with RadioDJ.

I have to admit I was surprised by how easy it was to install. It’s a lot more straight forward than the normal MySQL installer.

If you have previously had MySQL installed you will need to see this article about removing it as a service

1) Download the Maria DB MSI installer for your version of Windows Here

2) Open the file & Install and run when Windows prompts.

3) On the licence agreement screen check the accept box. Click next.

Read the full article

Last updated on: August 15th, 2017
at 14:20 PM Europe/London

Firebird Database Sam Broadcaster

Firebird Database SAM Broadcaster

SAM Broadcaster comes with four different options of database install.

Firebird – MySQL – PostgreSQL – MSSQL

 
Sam Broadcaster Database options

Of the 4 different database options that come with SAM Broadcaster, Firebird appears to be the most unstable database of the four options.

Read the full article

Last updated on: July 22nd, 2017
at 12:09 PM Europe/London

RadioDJ Tracks From SQL Query

Recently the developer of RadioDJ introduced a feature into the program called “Track(s) from SQL Query” which can be used along side track rotations.

SQLQueryrotation

It makes programming songs from the “Top 40” “Most played” or “Two songs by the same artist” a piece of pie.

Read the full article

Last updated on: January 12th, 2018
at 16:09 PM Europe/London

Translate ยป