The Song Fight Bulletin Board

ujnhunter wrote: ↑

Thu Mar 17, 2022 11:22 am

Yeah, Discord links seem to expire within 7 days. https://discord.gg/VfzGPUpY <---good for 7 days...

It's pretty easy to make one that doesn't ever expire and the one on the songfight.org front page was set up that way.

fluffy wrote: ↑

Wed Mar 30, 2022 2:20 pm

ujnhunter wrote: ↑

Thu Mar 17, 2022 11:22 am

Yeah, Discord links seem to expire within 7 days. https://discord.gg/VfzGPUpY <---good for 7 days...

It's pretty easy to make one that doesn't ever expire and the one on the songfight.org front page was set up that way.

Nice. Here's the one from the homepage then: https://discord.gg/3eQHCUG as my link was probably already expired.

fluffy wrote: ↑

Wed Mar 30, 2022 2:18 pm

These days, bandwidth is cheap, it's being able to host apps that's expensive. The Jukebox is written in Java, right? I don't know of any free/cheap Java service hosting, unfortunately, aside from plopping it onto a Linode or DigitalOcean VPS that you happen to use for other things as well.

On that note I have a Linode that I use for hosting a bunch of stuff and I could set up an account for the SF Jukebox on it, as long as it's still using songfight.org itself as the hosting provider. I'd recommend migrating the database over to SQLite though, like there's no way the jukebox needs anything heavier than that and I don't want to deal with administering a "real" database.

It's written in Java, yes. Thanks for the offer and suggestions. I'm looking into the approach of using a db like SQLite (I had been using MySQL because it was running on my brother's servers anyway) and a minimal Linode.

If you've abstracted your stuff using JDBC it should just be a matter of changing your database config and reimporting. There's also mysql -> sqlite converters out there if you don't have a schema bootstrapper or if there's data that's just in your mysql database that you don't want to lose.

But yeah setting up a linode is well worth it. $20/month for an incredibly beefy server with a lot of storage and bandwidth. I run like a dozen sites on mine and beesbuzz.biz is the only one which scratches the surface on my server's capacity, and it's not much of a scratch.

I'm planning to just start from scratch, data wise. I don't think I'll be able to get access to any of the data from the MySQL database I was using, unfortunately. I've probably lost all the data that wasn't ingested from the songfight.org files, like the vote data which I'd been saving to my own table, folks' playlists, and user contributed artist relationships.

I'm trying out H2 first instead of SQLite as I'm using the Spring Boot framework and it claimed to have really straightforward integration with H2 (and other Java based embedded databases like HSQLDB and Derby). I've mostly gotten that part working, like all the important basic stuff is working, ingesting the official archive data, browsing/searching the fights/artists/songs, and playing music. I'm having some issues with less important stuff like logging in, playlists, and admin tools that help me with updating songfighgt.org. I'll probably try to get a partially working version back up first though and worry about fixing other stuff later.

I appreciate the info about Linode, I had been mostly wasting time being unable to decide which hosting route to try, so, having a solid reference and vote of confidence in a specific host is very helpful. Thanks!

I think I've maybe gotten the Jukebox working again. It's working for me but I haven't done extensive testing from different devices/browsers/networks/etc. Please try it and let me know if it's working for you.

https://sfjukebox.org/

Works for me on Firefox on macOS. Yay!

Also thanks to fluffy for some of the technical suggestions. I did wind up getting it working using an embedded database, which simplifies the hosting setup. And it's running on a Linode virtual server.

Working on Chrome on PC. Thanks!!

I did have one weird sorting issue which is not a big deal at all. I sorted the cover art by name and it sorts the lower case and the upper case separately one right after the other.

Ah, good find. I will see what I can do about that.

Easy way would be to case-fold into a sorting field, which would also be a good opportunity to remove "the" from the beginning to get proper title sorting.

Yep, I have that already for sorting artists by name. I never bothered to add it for sorting fights by cover artist names for some reason. I was just doing a "to lower" in the "order by" clause of the SQL. (And same for sorting fights by title.) It looks like in all the changes I made to update to the latest versions of the frameworks and libraries I use in the Jukebox code I missed making those two sorts case insensitive. Anyway, easy stuff to fix.