3 ms·
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 Browse
by Sn0wCoder 2y ago
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 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.