Music Archive
- Ross
- Jump
- Posts: 2745
- Joined: Sun Feb 27, 2005 3:27 pm
- Instruments: Guitar, Vox, Bass, Tuned glasses, etc...
- Recording Method: Logic on a Macbook.
- Submitting as: Ross Durand
- Location: Orange CA
- Contact:
Re: Music Archive
For some reason My archive list includes "future on the Road" which I did not submit for, but does not include "After Hours."
Thanks
Ross
Thanks
Ross
"I don't like this song, but at least it's good." - veGetar Ianra Ge
http://www.rossdurandmusic.com
http://www.rossdurandmusic.com
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
Holy cats you have a lot of songs in the archive. I'm surprised you don't have MORE mislabeled songs.
- Niveous
- Beat It
- Posts: 7195
- Joined: Mon Sep 27, 2004 6:45 am
- Instruments: vocals, songwriting, guitar
- Submitting as: Lucky Witch and the Righteous Ghost
- Pronouns: He/him
- Location: Staten Island, NY
- Contact:
Re: Music Archive
I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
- Spud
- Hot for Teacher
- Posts: 4770
- Joined: Fri Sep 24, 2004 10:25 am
- Instruments: Bass, Keyboards, eHorn
- Submitting as: Octothorpe
- Location: Seattle
- Contact:
Re: Music Archive
I am having no such problem.Niveous wrote:I'm having trouble streaming "Influential Film" by Daddy Bop for some reason.
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
Hey, it looks like the same thing happened to my archive, too. I suspect it happened to all the After Hours entries.
- BBABM
- Mean Street
- Posts: 666
- Joined: Sun Aug 15, 2010 11:34 pm
- Instruments: Guitar, Voice, drums
- Recording Method: Session, fruity loops
- Submitting as: Bad Boys at Bat Mitzvahs, Fitzroy
- Location: Charlottesville, Va
Re: Music Archive
hey, just happened to notice that in the archive there are both "Bad Boys at Bat Mitzvahs" and "Bad Boys At Bat Mitzvahs. this is probably my fault in some way for labeling my song, or email wrong. i don't really care about that, however, both links go to "Bad Boys at Bat Mitzvahs" and so only half my songs are on there. again, its not a super big problem for me, because i obviously have all my songs on hard copy, but it may cause problems for later cover fights, etc. i may enter. take your time, as im sure everybody has more pressing and important issues. thanks!
p.s. if you were somehow able to combine them, the "at" is correct... not the "At"
p.s. if you were somehow able to combine them, the "at" is correct... not the "At"
- Niveous
- Beat It
- Posts: 7195
- Joined: Mon Sep 27, 2004 6:45 am
- Instruments: vocals, songwriting, guitar
- Submitting as: Lucky Witch and the Righteous Ghost
- Pronouns: He/him
- Location: Staten Island, NY
- Contact:
Re: Music Archive
There are a couple of bands with that same problem like BLT & Paco; The Booty Chesterfield Trio; and Chonny (there's a whole bunch). Something about merging the two names doesn't merge the two lists of songs.BBABM wrote: however, both links go to "Bad Boys at Bat Mitzvahs" and so only half my songs are on there.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
The problem is that people can't consistently type their artist names, and that there is any case sensitivity in the system. All case variations should be treated the same, I think. I don't think it really adds any value to make it possible for there to be two distinct artists whose names only vary in their case. In my app case is ignored in artist names:
http://sfjukebox.org/sf/artists/Bad%20B ... 20Mitzvahs
http://sfjukebox.org/sf/artists/Bad%20B ... 20Mitzvahs
- Niveous
- Beat It
- Posts: 7195
- Joined: Mon Sep 27, 2004 6:45 am
- Instruments: vocals, songwriting, guitar
- Submitting as: Lucky Witch and the Righteous Ghost
- Pronouns: He/him
- Location: Staten Island, NY
- Contact:
Re: Music Archive
Lunkhead,
I have to say that the SFjukebox is looking great these days. Nice work.
I have to say that the SFjukebox is looking great these days. Nice work.
"I'd like to see 1984 redubbed with this in the soundtrack."- Furrypedro.
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
NUR EIN!
X-Tokyo
Lucky Witch and the Righteous Ghost
- BBABM
- Mean Street
- Posts: 666
- Joined: Sun Aug 15, 2010 11:34 pm
- Instruments: Guitar, Voice, drums
- Recording Method: Session, fruity loops
- Submitting as: Bad Boys at Bat Mitzvahs, Fitzroy
- Location: Charlottesville, Va
Re: Music Archive
well looky here!Lunkhead wrote:
http://sfjukebox.org/sf/artists/Bad%20B ... 20Mitzvahs
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
Thanks Niv! I hope to keep adding to it and improving whenever I have time, though lately that hasn't been as often as I'd like.Niveous wrote:Lunkhead,
I have to say that the SFjukebox is looking great these days. Nice work.
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
Would it be possible to merge "Tobin’s Spirit Guide" (with a special curvy Microsoft-y single-quote) into "Tobin's Spirit Guide" (with a normal single-quote)?
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
Also, what is up with "Poppetshuw", an artist with one fight entry for which there is no URL, just "none"?
http://www.songfight.org/artistpage.php ... rtkey=date
It's breaking my s#@%. I accidentally just hosed my whole database and am trying to re-import but am having a problem because of that one thing. Aargh.
http://www.songfight.org/artistpage.php ... rtkey=date
It's breaking my s#@%. I accidentally just hosed my whole database and am trying to re-import but am having a problem because of that one thing. Aargh.
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
That is one of the mp3s which got lost in the Great Transition from Meanwhile to songfight.org. I'm surprised this didn't cause you a problem before.
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
Good point. It looks like it started being a problem after I kludged in support for parsing late entries. I managed to kludge around it last night and get the data imported again.
As another lesson on the evils of manual updates of data, I wiped out my database because I forgot my "where" clause in a SQL statement. Doh!
As another lesson on the evils of manual updates of data, I wiped out my database because I forgot my "where" clause in a SQL statement. Doh!
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
Two things are your friend:
1. Transactions
2. Database snapshotting
In the case of 2, a daily cron job that just does mysqldump is handy. Here's mine (which I have in addition to Dreamhost's default one, since Dreamhost's can't be automatically backed up by my account mirroring script):
with the ####s replaced by the appropriate values, obviously.
1. Transactions
2. Database snapshotting
In the case of 2, a daily cron job that just does mysqldump is handy. Here's mine (which I have in addition to Dreamhost's default one, since Dreamhost's can't be automatically backed up by my account mirroring script):
Code: Select all
#!/bin/sh
mkdir -p $HOME/db-backup
cd $HOME/db-backup
mysqldump -u #### --password=#### -h #### --all-databases | gzip -c > mysql-backup-`date +%Y%m%d`.sql.gz
find . -name 'mysql-backup-*.sql.gz' -mtime +10 -print0 | xargs -0 rm
- irwin
- Mean Street
- Posts: 620
- Joined: Mon Jan 22, 2007 10:09 pm
- Instruments: insecurity
- Recording Method: scotch
- Submitting as: suckweasel, kasper, nutwalls
- Location: Woodland, CA
Re: Music Archive
Obviously transactions are the better answer, but if you're using MySQL, the command line has an "--i-am-a-dummy" option which will cause it to reject an update statement without a "WHERE" clause.
"Ouch. I wonder if this guy sounds like this when he speaks." -- Puce
- Lunkhead
- You're No Good
- Posts: 8167
- Joined: Sat Sep 25, 2004 12:14 pm
- Instruments: many
- Recording Method: cubase/mac/tascam4x4
- Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
- Pronouns: he/him
- Location: Berkeley, CA
- Contact:
Re: Music Archive
Irwin, I assume you are joking, but I wish you weren't.
fluffy, I don't snapshot because i am lazy and I can just re-import from the real data source. For now I don't have any significant other data in that db, and also I have no need to manually futz with the non-archive data and possibly fubar it. But otherwise, that would be a good solution. Probably I should replace my "mysql" command with one that does a snapshot first every time I invoke it... Really though I should write some code to do the kind of maintenance tasks I do, so that I can't screw them up so easily.
fluffy, I don't snapshot because i am lazy and I can just re-import from the real data source. For now I don't have any significant other data in that db, and also I have no need to manually futz with the non-archive data and possibly fubar it. But otherwise, that would be a good solution. Probably I should replace my "mysql" command with one that does a snapshot first every time I invoke it... Really though I should write some code to do the kind of maintenance tasks I do, so that I can't screw them up so easily.
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
There's always just using phpMyAdmin as a GUI-ish frontend. It's pretty decent as a general-purpose table and schema editor, at least.
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
Actually, it's for real. It's a synonym for --safe-updates which is also shortened -U. You can also set it in a config file.Lunkhead wrote:Irwin, I assume you are joking, but I wish you weren't.
- irwin
- Mean Street
- Posts: 620
- Joined: Mon Jan 22, 2007 10:09 pm
- Instruments: insecurity
- Recording Method: scotch
- Submitting as: suckweasel, kasper, nutwalls
- Location: Woodland, CA
Re: Music Archive
No, really, I wasn't trying to be insulting. Sorry if it came across that way!
I just think "--i-am-a-dummy" is more fun that "--safe-updates".
Probably because I am a dummy and that flag has saved me.
Though really I think it is SQL that is the dummy. Seriously, the default action would be to affect all rows?! If I were king, there would be a "WHERE ALL" clause to explicitly request that.
I just think "--i-am-a-dummy" is more fun that "--safe-updates".
Probably because I am a dummy and that flag has saved me.
Though really I think it is SQL that is the dummy. Seriously, the default action would be to affect all rows?! If I were king, there would be a "WHERE ALL" clause to explicitly request that.
"Ouch. I wonder if this guy sounds like this when he speaks." -- Puce
- fluffy
- Eruption
- Posts: 11093
- Joined: Sat Sep 25, 2004 10:56 am
- Instruments: sometimes
- Recording Method: Logic Pro X
- Submitting as: Sockpuppet
- Pronouns: she/they
- Location: Seattle-ish
- Contact:
Re: Music Archive
Daily snapshots have saved my ass on more than one occasion. Never underestimate the security blanket afforded by cron.