Not sure whether that's the correct way but it seems to work. AFAICT, there is no "now_playing" field in the sqlite db - but tracks that start playing are added to the `PlaylistTracks` table. That means that if you started two tracks and then pause one or the other and restart it, no row will be added. Only adding a track from the library and then playing it will add to the PlaylistTracks list.

(Is there a simpler solution I missed?)

  import sqlite3
  import time
  from pathlib import Path
  home = Path.home()
  
  con = sqlite3.connect(f"{home}/.mixxx/mixxxdb.sqlite")
  cur = con.cursor()
  
  def get_track_name():
      global cur
      trackid = cur.execute("SELECT * FROM PlaylistTracks WHERE id=(SELECT max(id) FROM PlaylistTracks);").fetchall()[0][2]
      trackname = cur.execute(f"SELECT * FROM library WHERE id={trackid};").fetchall()[0][2]
      return trackname
  
  now_playing = get_track_name()
  print(now_playing)
  
  while True:
      if (np := get_track_name()) != now_playing:
          now_playing = np
          print(np)
      time.sleep(1)

Edit: FWIW, unbox [1] uses the same approach. Edit 2: yes, I should have cleaned up my SQL statements.

[1] https://github.com/erikrichardlarson/unbox/blob/2182f227a0fc...

I will see... Not being evasive but I'm experiencing terminal illness at the moment so I'm all over the place. It wasn't a complex bit of code though, but I'll see what I can find.

* https://github.com/erikrichardlarson/unbox

* https://github.com/ViktorNova/mixxx-now-playing

I have not used Mixxx nor do I have it installed, but might download to check it out.

But..... If its always in a SQLite DB you should be able to use DB Browser for SQLite to inspect the DB Schema and then write a bash/python (whatever) script to pull the info out.

RESULTS=$(sqlite-utils "data.db" " SELECT song, artist, duration, FROM my_table WHERE song = 'CURRENT';")

RESULTS=$(sqlite3 data.db <<EOF SELECT song, artist, duration, FROM my_table WHERE song = 'CURRENT'; EOF )

I have no idea what the schema looks like but those are just some examples of how straightforward it might be. Run it on CRON (whatever) update as needed. https://cronitor.io/guides/python-cron-jobs

Once you have the Schema an LLM could most likely do the rest if you are not a programmer, but still need someone to get it added to the site.

I made something custom. I can't share the code for it (see my other reply for why), but here's the general deal:

Wedding website was a django site, with accounts for everyone I invited. I had a separate part of it where the guests could choose an RGB colour, and then choose tracks by searching. I used a spotify API for this, so when they chose a track, if someone chose a similar one (say a specific mix) then they could see this and vote for that. Each guest could choose 10 tracks. I used some HTMX for this as well (first time) and it generally worked pretty well. Database stored the spotify ID/UUID/whatever for each track

Once everyone had voted, I then bought all the tracks which we were going to play - reason being that I couldn't rely on WiFi on the day, and wanted to be 100% sure it would work, plus I couldn't "DJ" from spotify tracks.

All of the tracks were then renamed including their spotify ID/UUID/whatever, so the system knew who had voted for a specific track.

I then made the playlist up in Mixxx, and trimmed tracks to fit better, and made it work musically (my wife is excellent at this, she made it really work, mix wise). Made sure it all played OK.

The other part of the system was a custom light setup, with sound-reactive LED bars I made up (using ESP8266 and WLED firmware with 150 LEDs per 'stick') with them all being controlled by a custom controller. This system read the track from the Mixxx system (via HTTP request to a flask app I wrote that read the sqlite dB from mixxx to know what track was playing), and then coloured the lights with the colours of the people who had voted for the tracks. Also if you went onto the dancefloor you could 'swipe in' via an RFID label which was in the wristbands, which also reacted to lights and were colour-controlled over DMX.

The light patterns were sometimes random, or if one was good for a specific track then I programmed that into the system.

It was all spaghetti code, and the first time I used FastAPI. The code is terrible, and I'm only making it public as I thought it might be useful to someone.

https://github.com/djaychela/wedding_controller

I've just had a terminal cancer diagnosis and am no longer doing anything other than trying to stay alive. So please, no grief about the code! I'm sharing this to try to help someone else if they ever want to do something like this...

In Rekordbox's case Pioneer have restricted the jogwheel mapping to Pioneer hardware only. So, you pretty much need Pioneer hardware to use Rekordbox. And seeing as Pioneer decks are almost industry standard in clubs and you need Rekordbox to organise your playlists, they have the DJ hardware market sewn up. Which is very frustrating because Rekordbox has to be the most resource intensive (& therefore inefficient) DJ software available.

Is it latency? Or granularity? MIDI has upper limits on both…or is it a more subtle quality like ballistics?

Does the mixer speak midi? In that case probably.

Is there already a mapping for you device? Check the manual https://manual.mixxx.org/2.5/en/

Mixxx can stream to an icecast output or similar, you'll need to setup the stream server separately though.

How does the auto DJ compare to something like Pacemaker?

I considered renting out some Pioneer equipment to add RekordBox playlist writing support, mainly because I'm in a similar situation. Mixxx does have support for reading USBs & SD cards, but not writing ;_;

Unfortunately it's far down my priority list given the cost, my unfamiliarity with Mixxx development and that I rarely do anything without Mixx.

But this is absolutely what ecosystem grants/bounties should be for.

Somehow Rekordbox seems to run much better on my Ryzen 5 8gb ram windows laptop from 2019 than on my i7, 64gb ram macbook. It seems to only like windows?

I do have a similar story with the 2.4.1 or 2.4.2 version unfortunately. Didn't take the time to debug it or fill an issue yet but when the library (between 100 and 200G) is on a USB stick it regularly hangs for 10-15s when browsing. It always came back to normal but made me sweat every time.

>I guess a smart phone could do that duty today

Not since they bravely killed off the headphone plug.