Music

Music My DIY Projects

Project – Record Shelf

Ramen Junkie No Comments

Since I’ve actually taken an interest in vinyl records, One thing I really wanted to do was build a simple little record shelf. This would serve two purposes basically. One, it looks cool. Two, it gives me another way to decorate the basement a bit. The concrete block walls are a pain to work with, especially the outside wall where all my music stuff is. The temperature changes mean nothing sticks to it long term. In other areas I’ve hung frames from the rafters using small chains. For this space, I’ve got a nice shelf I can use and swap out what’s on display as I get more records.

It wasn’t an overly complicated project, but it took longer than planned since my wife had the garage full of garage sale stuff and I couldn’t really reach any tools. Also it’s been blazing hot out, and I don’t care to work outside in that much heat. On the problem of the heat, probably sometime int he fall, I’ll drag the shelf and the lower shelving out and stain and seal it. Neither plays very well with the heat either.

The shelf itself is a handful of 1×4 pine boards. It’s a bit more complicated than it might seem at first. For starters, I like the look of inset joints over just using metal L braces, so I went and inset and glued the shelves inside the sides. This was a bit tricky because I don’t actually own any bar clamps. I also added the little back catch pieces under each shelf, so the albums wouldn’t be resting on the wall itself. This was slightly complicated because there is a power conduit running down this wall i had to work around. The shelves themselves are notched around the power conduit as well. I also only have so many clamps large enough to glue these, so it took like a week of “clue one piece then come back.”

Each shelf also has an angled groove cut along the length so the albums sit slightly down in the shelf and are more secure. The whole thing is screwed to the rafter above for support. In fact the whole thing is much sturdier than I thought it would be. My main worry is that the albums would tumble off, damaging the records, but now that it’s up, I actually am not worried about that at all. Everything is very stable.

Also, my original plan was to stick the CD holder I had been using back on the lower shelf, in front of the new shelf. I immediately hated this look. But I also realized that there was a small gap near the bottom, so I added one more smaller shelf to put (most of) the CDs on. I really liked this end result. Plus the board I used here was a different type of wood that was just around, and it’s a much sturdier type of wood than the pine, so I didn’t end up needing to add a center leg like I had worried I might need to do.

I suppose it’s also worth noting the equipment itself. The entire set up is pretty minimal. Everything is centered around this small mixer and amp combination.

I originally bought the mixer for use at my PC, I wanted to be able to play games on one machine, and watch a video on another machine, and merge the audio out one headset. That didn’t really work out to be as useful as I had hoped, but instead I get to use the mixer for my music instead. The amp I bought to go with some nice JBL speakers I had, that needed 2 wire connections to work, also connected to the PC originally. Except I never ever use anything but a headset on my PC, so it was a waste.

Connected to the Mixer are the input options. They can be played all at once, since it’s a mixer not a switch, but I’m not sure why you would want to. There is a Raspberry Pi hidden under the little shelf that connect to my music library and can be controlled remotely via a webpage. I have this kind of mediocre CD player that I’ll probably replace one day with something better, but still compact. Even a portable CD player would probably work better. There is also an Amazon Echo connected, but since Amazon jacked up their music service, I don’t use it as much. I also have an aux cord hanging off for connecting to a phone.

Lastly is my record player, which I bought at a garage sale. It works pretty well for my needs though. It’s an Audiotechnica AT-LP60, nothing fancy.

Lastly I have this recently acquired audio switcher. Right now I just have the one set of speakers, but at the very least, it will be easy to add a second set outside so I can listen to music while out on the deck or porch under the deck out back. The output selector will make this much easier to accomplish and it’s something I’d thought about getting at some point before, then I came across one at an estate sale.

Music Opinion/Editorial/Life

Record Store Day 2023

Ramen Junkie No Comments

Today was Record Store Day.  It’s moistly just, a “promotional” sort of deal for local record shops, and not really like, a “real holiday”.  I decided I would go ahead and give it a go.  There were a couple of pretty inexpensive albums that I was interested in and I’ve recently (finally) picked up a record player after many years of “I should get a record player”.

Man, now I’m just getting layers and layers of things to bring up here.  Maybe it’s best to just start at, “Why vinyl?”

I guess it’s almost, “Why not?”  Ok, there are plenty of reasons why not.  It takes up a lot of space, it’s not portable, it’s not particularly cheap, it’s not skip-able, etc etc.  Some of these are advantages though.  I listen to mostly albums anyway, why not buy a format that lends itself to album listening?  Space and cost are less of an issue as well, I don’t intend to go nuts on buying records.  There is nothing that I just HAVE to have.  If I could get an ok deal, on some things, I might buy it, but there is nothing I am desperate for on vinyl.  I’ve already had a few records for a while, Pink Floyd’s The Wall, and Dark Side of the Moon, A promo single from Mortal Kombat Annihilation, and slightly more recently, the soundtrack to 2001: A Space Odyssey.

I also recently bought a player for these albums.  I found one that fit what I was looking for at a garage sale and got it pretty cheap, it’s a nice little entry level Audio-Technica AT-LP60.  The main thing I wanted was a stand alone unit like this.  It takes up less space, and I already have speakers that are much nicer than most of the self contained units I come across.  It operates perfectly for my basic needs.

I had looked over the list online, and the price list I had found, and basically only wanted 2 albums.  Dodie’s Hot Mess EP, and the Arooj Aftab – Live in London EP.  I am going to skip the boring details behind these choices for now because I may do some album write ups in the future but these two were both affordable at under $20 each and both were artists I enjoy.  I had a few others lined up as alternative options or maybe if I felt spendy, but I ended up either not finding them or passing on them.  I also decided that I would go ahead and get the Taylor Swift Folklore album, if it was there, despite it being a bit more than I wanted to spend.  The price didn’t matter, it was sold out.  People camped out overnight for that thing.  CRAAAZY People…..

I was a bit worried during the lead up.  The store had been posting photos online as they unboxed everything and I had seen neither of these albums shown.  This was especially annoying because Dodie’s album was listed as “Regional Focus” and she was doing a live show off in London FOR Record Store Day.  Which sort of suggested, “Hot Mess” may be “Regionally focused to England.”  Friday night though, both albums showed up as being available.  So I was set to go.

The store opened at 8AM.  But it was also a 45 minute drive away in the next city over, and I didn’t have anything on my list that I needed to be there super early for anyway.  I arrived around 8:30, and there was still a line down the block, which was a little discouraging.  I had driven all this way though, how long could it take?  It didn’t help that it was also very cold, and I had not brought a jacked, though I was wearing a flannel shirt, in classic “I’m a 90s teen” fashion.  

The line took, a very looooong time.  It was something like 2 hours before I got in the store.  Thankfully, I got to chat up some nice strangers while waiting.  We made jokes, and talked music and concerts and records and talked other things.  Funny enough,, I never got any of their names.  There was one lady who had been at the hospital nearby and her husband had asked her to come down here and see if she could get a KISS related album.  I get the impression she did not manage to, I never saw her in the store and she had been trying to recruit me or the other dude to buy her a second copy since it was limit one.  Then there was “The other dude”, whom I really enjoyed talking with.  Talking with him was like looking at a mental and verbal mirror, though we looked nothing alike.  He was disappointed that people would leave the store and not look happy and not show off their hauls.  He ended up checking behind me and as I was leaving, I reminded him to do his fist pump as he left for the crowd outside.  There was also a younger girl who reminded me a bit of my daughter, with her slightly eccentric dress and mannerisms.  The notable store for her, she was wearing these flowered pants.  As we got closer to the store entrance, she mentioned being friends with the worker managing the store entrance.  The employee finally noticed her in line and they exchanged some pleasantries, and the employee mentioned “I like your pants”.  The young girl said thanks, then opened the front of her jacked and exclaimed, “They aren’t just pants, they are overalls!”  And everyone got a kick out of that, and the reaction of the employee.

It’s really kind of funny that we never got anyone’s names, because the other dude said something that really stuck with me.  He talked about writing some books as a hobby, and not really wanting to be a famous writer because he liked the anonymity of just, not being known.  He mentioned enjoying just sort of the basic human interaction, he had a better phrasing that I’ve forgotten.  And here we are, a small group of strangers, bonding over a shared event, passing ships on the ocean, with no real clue who we all really are.

Anyway, my turn finally came up, I went in.  The RSD Exclusives were in bins sorted alphabetically, and the front of the alphabet was open.  I quickly thumbed through the A-B bin and found my Arooj Aftab record.  The only one in there, I have no idea if there had been more earlier.  I picked it up and slid down to C-D looking for Dodie, and like the Arooj Aftab album, there was one copy of Hot Mess.  This meant mission accomplished for the day, anything else was a bonus.  The end of the alphabet was open so I slid on down there and started working my way back towards “A-B”.  No Taylor Swifts.  There was a NENA – 99 Luftbaloons I seriously considered but decided to skip.  I almost got the Garbage EP, I do like Garbage.  In the end, I decided on no more exclusives, and went over the the main part of the store.  I checked for any CHVRCHES or Aurora albums they might have and came up empty there.I checked through the “recent arrivals” and there were a few interesting ones but I decided I would wait for now.  There was a line outside, only 20 people allowed in at a time due to the store size, and I didn’t really need to linger.  I headed to the checkout table.

The Other Dude ended up behind me in line, he had a couple of albums picked out.  The real oddity here was the person in front of me.  So the store WAS having 10% off everything not RSD related.  So if you’re a collector, that would be a good time to pick up some other stuff.  The guy in front of me was buying, cassettes.  ONLY cassettes.  They seemed to be like, $1 each, and he spent a whole $8 and some change.  Like dude…..   dude…..  dude…. I am sure your cassette choices are great….  but did you just stand in line for possibly 2 hours, to spend $8 on used cassette tapes?  That 10% didn’t even save a dollar and there are a LOT of people here waiting to spend hundreds of dollars.

It seemed, very odd.

After finishing up, I went back to my car and drove around the block to…. The OTHER record store in town, Recycled Records.  This store was not participating in Record Store Day, because it’s closing in like a week.  It’s been around in town for a very long time.  I thought I had read they were doing 50% off, there was no indication that this was the case at all, anywhere.  I didn’t end up buying anything.  Not for trying, but I just didn’t find anything that jumped out at me.  There was a Radio Head vinyl I would have bought at half price, but it seemed new Vinyl was only 10% off.  They didn’t have any of the other artists I looked for unfortunately.

Afterwards I headed out to spend a few hours at my parent’s house just hanging out before heading home in the late afternoon.

Just one last bit, I’ll talk about the albums themselves later, but they are both very cool disks, and I can understand why people buy these special versions like this.

Programming Projects

Code Project: VLC Portable Playlist to Text Dump

Ramen Junkie No Comments

It’s kind of funny how one post can lead to another sometimes.  This one is pretty basic but it also just shows a bit how useful I find knowing my way around computer systems to be.  Yesterday I posted about my little annual music playlists.  And as part of that, I wanted to actually post the playlist. I am pretty sure there is a fairly universal “playlist file type” out there and being open source, I had assumed that VLC on my phone stored the playlists somewhere in playlist files.

That assumption was wrong, it uses a .db file.  A little portable database.  There is an option to dump this file to the root of the phone, presumably for backup purposes, but it’s also useful to just browse it like I am doing here.  The file itself can be opened and browsed with SQL Lite’s DB manager.  It’s standard databases inside for tracks and artists and playlists.

Fortunately, I have had some experience dealing with database queries, so I set about building what was needed tog et the data I wanted.  Pull the Playlist I want, in this case “2023 Best” but I could change that to do any available Playlist.  This gives the tracks by id, but the tracks themselves are stored in a separate table for media.  So that needs joined in.  The media table stores track names, but not artist names, so an additional join is needed to get the artist names.  This complicated things a bit because both the playlist table and artist table have a column “name” so more clarity needed to be added.

The result was this little query that dumps out a basic table of Artist and Song title.

SELECT Artist.name, Media.title 
FROM Playlist
Inner Join playlistmediarelation ON playlist_id=id_playlist
Inner Join Media ON id_media=media_id
Inner Join Artist ON media.artist_id=Artist.id_artist
WHERE Playlist.name = '2023 Best'
ORDER BY Artist.name

Now, I could have done some cute clever trick now to merge the two into a new column and add in a ” – ” between but it was easier to drop it all into a notepad file and do a fine/replace on the weird space character that it stick in between the Artist and track title.

The added bonus here is I can easily use this query again anytime I want to dump a Playlist to text.

Programming Projects

Code Project: Automated List From Reddit Comments

Ramen Junkie No Comments

This is one of those quick and kind of dirty projects I’ve been meaning to do for a while. Basically, I wanted a script that would scrape all of the top level comments from a Reddit post and push them out to a list. Most commonly, to use on /r/AskReddit style threads like, well, for this example, “What is a song from the 90s that young people should listen to.”

Basically, threads that ask for useful opinions on list. Sometimes it’s lists of websites or something. Often it’s music. The script here is made for music but could be adjusted for any thread. Here is the script, I’ll touch on it a bit in more detail after.

## Create an APP for Secrets here:
## https://www.reddit.com/prefs/apps

import praw

## Thread to scrape goes here, replace the one below
url = "https://www.reddit.com/r/Music/comments/10c4ki0/name_one_90s_song_kids_born_after_2000_should_add/"

## Fill in API Information here
reddit = praw.Reddit(
    client_id="",
    client_secret= "",
    user_agent= "script by u/", # Your Username, not really required though
    redirect_uri= "http://localhost:8080",
)


submission = reddit.submission(url=url)
submission.comments.replace_more(limit=0)
submission.comment_limit = 1

for x in submission.comments:
    with open("output.txt", mode="a", encoding="UTF-8") as file:
        if "-" in x.body:
            file.write(str(x.body)+"\n")
            # print(x.body)

The script uses praw, Python Reddit API Wrapper. A Library made for use in Python and the Reddit API. It requires free keys which can be gotten here: https://www.reddit.com/prefs/apps. Just create an app, the Client ID is a jumble of letters under the name, the secret is labeled. User Agent can be whatever really, but it’s meant to be informative.

The thread URL also needs filled in.

The script then pulls the thread data and pulls the top level comments.

I’m interested in text file lists mostly, though for the sake of music based lists, if I used Spotify, I might combine it with the Spotify Playlist maker from my 100 Days of Python course. Like I said before though, this script is made for pulling music suggestions, with this but of code:

        if "-" in x.body:
            file.write(str(x.body)+"\n")
            # print(x.body)

It’s simple, but if the comment contains a dash, as in “Taylor Swift – Shake it Off” or “ACDC – Back in Black”, it writes it to the file. Otherwise it discards it. There is a chance it means discarding some submissions, but this isn’t precision work so I’m OK with that to filter out the chaff. If I were looking for URLs or something, I might look for “http” in the comment. I could also eliminate the “if” statement and just have it write all the comments to a file.

« Previous Page — Next Page »