milkbones_4_bigelow's recent activity

  1. Comment on What are your favorite community radio stations? in ~music

    milkbones_4_bigelow
    (edited )
    Link Parent
    KFAI looks great, thanks for sharing :) I've come across "crap from the past" before but hadn't until now realized it was a KFAI show. If you're looking for other radio shows available as podcasts...

    KFAI looks great, thanks for sharing :) I've come across "crap from the past" before but hadn't until now realized it was a KFAI show.

    If you're looking for other radio shows available as podcasts I can recommend Wake with Clay Pidgeon over at WFMU. He plays a good chunk of older records as well as some newer releases. He's also a really entertaining guy. Who knows, perhaps you'll find something in it that piques your interest.

    Commercial radio is bad, agreed. It's unfortunate that not every city has a decent community radio presence. As you alluded to, a lot can be lost in its absence.

    2 votes
  2. What are your favorite community radio stations?

    I'm a big fan of community radio, freeform if I'm being picky. I'm curious... Which stations are my fellow Tilderinos listening to? (I'm particularly interested in non-English speaking stations)...

    I'm a big fan of community radio, freeform if I'm being picky. I'm curious...

    1. Which stations are my fellow Tilderinos listening to? (I'm particularly interested in non-English speaking stations)
    2. How are you listening?
    3. More generally, are people even listening to much radio any more? If not, why is that?

    To get things started, my own answers are.

    1. WFMU, dublab, Resonance FM, rrr.
    2. Generally I set up an alias per station with fish shell and stream each link via cvlc
    3. As I'm posting I guess it's obvious but yes, I listen to the radio almost daily. It's a nice break to have one less thing to make a decision about (what to listen to) while avoiding having to listen to top 40 and discovering all sorts of new music I'd otherwise likely miss out on.
    8 votes
  3. Comment on In 100 years' time, what do you think society will look back on and view with distaste? in ~humanities

    milkbones_4_bigelow
    Link Parent
    Very interesting. Care to elaborate? Do you mean in terms of pharma, therapeutic techniques, both? Are there any treatments in particular you think will be first out the door? If so... a) What...

    Mental health treatments, in 100 years will see the stuff that we do today similar to how we see thinks like lobotomies now.

    Very interesting. Care to elaborate? Do you mean in terms of pharma, therapeutic techniques, both? Are there any treatments in particular you think will be first out the door? If so...

    a) What currently leads you to believe that?
    b) What would you expect to be the alternative?

    1 vote
  4. Comment on How to design a database? in ~comp

    milkbones_4_bigelow
    Link Parent
    Ah ok, yeah, this is not what I want as the same track could potential belong to multiple different playlists. Thanks for you help :)

    I'm trying to express that each playlist for a given show should have a unique uuid that is not null. Is this incorrect?

    Ah ok, yeah, this is not what I want as the same track could potential belong to multiple different playlists. Thanks for you help :)

    1 vote
  5. Comment on How to design a database? in ~comp

    milkbones_4_bigelow
    (edited )
    Link Parent
    Ok great, I don't want to bug people. You're right it should be user_uuid, corrected, good catch :) I'm trying to express that each playlist for a given show should have a unique uuid that is not...

    I think this is a perfectly fine space to ask questions like this.

    Ok great, I don't want to bug people.

    You're right it should be user_uuid, corrected, good catch :)

    playlist_uuid TEXT NOT NULL UNIQUE

    I'm trying to express that each playlist for a given show should have a unique uuid that is not null. Is this incorrect?

  6. Comment on Dom La Nena - Anjo Gabriel (2012) in ~music

    milkbones_4_bigelow
    Link
    Really enjoying this. Lazy comparison but it took me back to Arthur Russell :) Hope somebody else out there enjoys it too.

    Really enjoying this. Lazy comparison but it took me back to Arthur Russell :) Hope somebody else out there enjoys it too.

    1 vote
  7. Comment on Mozilla’s uncertain future in ~tech

    milkbones_4_bigelow
    Link Parent
    It's good to make corrections, now I have more information so thanks for that. That said, tone is important. There are and I am a person somewhere else in the world who feels that and whose...

    It's good to make corrections, now I have more information so thanks for that. That said, tone is important. There are and I am a person somewhere else in the world who feels that and whose stomach dips when they read something they perceive as needlessly cutting in tone. It pays for us all to be extra mindful there I think.

    4 votes
  8. Comment on Mozilla’s uncertain future in ~tech

    milkbones_4_bigelow
    Link Parent
    Feels kinda snarky but ok. Thanks for the context.

    And evidently most people that know of that page, don't know how Mozilla corporate structure works.

    Feels kinda snarky but ok. Thanks for the context.

    2 votes
  9. Comment on Mozilla’s uncertain future in ~tech

    milkbones_4_bigelow
    Link
    Does anyone know what is the extent of their fund raising efforts? Is there an internal team for that? I think a good chunk of people don't even know this page exists.

    Does anyone know what is the extent of their fund raising efforts? Is there an internal team for that? I think a good chunk of people don't even know this page exists.

    3 votes
  10. Comment on In your opinion, what is the most powerful speech in history? in ~talk

    milkbones_4_bigelow
    Link
    The most powerful speech for me at least was Philip Wollen's "a pig is a dog is a bear is a boy" at the St James Ethics and the Wheeler Centre debate. It's deeply moving and thought provoking....

    The most powerful speech for me at least was Philip Wollen's "a pig is a dog is a bear is a boy" at the St James Ethics and the Wheeler Centre debate. It's deeply moving and thought provoking. Honourable mention to "This is Water" by David Foster Wallace. It's important to keep one's narcissism in check.

    1 vote
  11. Comment on How to design a database? in ~comp

    milkbones_4_bigelow
    (edited )
    Link
    Thanks everyone for the insightful feedback. It's nice to have a community of more experienced devs to talk to. I very much appreciate that the Tildes community fosters this kind of respectful...

    Thanks everyone for the insightful feedback. It's nice to have a community of more experienced devs to talk to. I very much appreciate that the Tildes community fosters this kind of respectful discourse.

    Edit: If this sort of post is better off elsewhere, I'm also happy to shift the discussion there. Perhaps something like exercism.io is a better fit? Is this a space devs would rather not be asked questions in?

    Thanks again for the support and offering areas for me to go off and explore on my own and thanks in particular to @stu2b50 and @Flashynuff for the schema suggestions.

    1 vote
  12. How to design a database?

    I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show,...

    I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show, Playlist and Track.

    • Each show has multiple playlists (one-to-many)
    • Each playlist has multiple tracks (one-to-many)

    To be able to reference a playlist belonging to a particular show. I gave those playlists the same uuid as the show they belong to. A few questions though.

    1. Is this the right/best way to associate data?
    2. As a track could potentially belong to multiple playlists, I can't take the same approach as I do for (show/playlist) How would be best to handle this? Ideally I would like to have a single "Track" table containing all tracks for all playlists.

    For any experienced database designers out there, how would you structure this data? What would you consider in designing the schema and why? If I did go with 4 tables only, presumably there would be performance implications given the potential amount of data in any one of those tables, particularly tracks. If that is the case, how best to structure this kind of thing with performance in mind? Thanks in advance for any help :)

    For reference, in case it's of importance, I'm using sqlite3.

    5 votes
  13. Comment on Remembering Soviet pop: The USSR's vocal-instrumental ensembles in ~music

    milkbones_4_bigelow
    Link
    I heard this on WFMU today. After seeing the song title "Вокально инструментальный Ансамбль Телевидения И Радио Грузии Качели" (deepl: "Vocal instrumental Ensemble of Georgian Television and Radio...

    I heard this on WFMU today. After seeing the song title "Вокально инструментальный Ансамбль Телевидения И Радио Грузии Качели" (deepl: "Vocal instrumental Ensemble of Georgian Television and Radio Swing Swing") I just had to do some digging. This is what led me to the article above. Hope it's of some interest to somebody else out there too.

    3 votes
  14. Comment on Architecture for untrained software engineers (Python) in ~comp

    milkbones_4_bigelow
    Link Parent
    Thanks so much for this. It's encouraging there's not so much divergence across projects. I wouldn't want my learning to only apply to the problems I'm currently working on. This is great advice...

    Thanks so much for this. It's encouraging there's not so much divergence across projects. I wouldn't want my learning to only apply to the problems I'm currently working on.

    as long as you can say "thingymadoodle" and everyone agrees what that means, that's more important than it being "correct".

    This is great advice and reminds me of Phil Karlton: "There are only two hard things in Computer Science: cache invalidation and naming things." :)

  15. Comment on Architecture for untrained software engineers (Python) in ~comp

    milkbones_4_bigelow
    Link Parent
    Sitting hearing thinking about this I thought, "that's great advice, easily implemented". I then very quickly back pedalled :) I find both of these things very very difficult to do. That said,...

    keep things as simple as possible, with the sidenote that one should also consider the future for what you are building

    Sitting hearing thinking about this I thought, "that's great advice, easily implemented". I then very quickly back pedalled :) I find both of these things very very difficult to do. That said, with the encouragement offered up in this thread I can only hope it'll get easier over time.

    I appreciate the UML recommendation. I worked with a much older sys admin years back and he would UML everything. It's funny though, many of the younger programmers I've met don't seem to do this. Is it some old school concept? I don't have a formal CS background so don't know. Is that kind of thing taught at the college/university level?

  16. Comment on Architecture for untrained software engineers (Python) in ~comp

    milkbones_4_bigelow
    Link Parent
    I think making me think through it, whether a lot was extraneous or not was actually helpful. Even if I disregard what I learnt, it's good to know where you don't want to go. I have a better...

    I think making me think through it, whether a lot was extraneous or not was actually helpful. Even if I disregard what I learnt, it's good to know where you don't want to go. I have a better picture of that now thanks to this thread. Appreciate your reply.

  17. Comment on Architecture for untrained software engineers (Python) in ~comp

    milkbones_4_bigelow
    Link Parent
    Thanks so much for this. I think I may have just been waiting for someone to give me the go ahead to make mistakes. I'll be sure to post the repo on code review once it's done. I'm already...

    Thanks so much for this. I think I may have just been waiting for someone to give me the go ahead to make mistakes. I'll be sure to post the repo on code review once it's done. I'm already starting to see patterns I was just concerned I might be picking up bad habits or something, hence all the GoF/Uncle Bob research. Hopefully it'll get easier over time. Thanks again.

    1 vote
  18. Comment on Architecture for untrained software engineers (Python) in ~comp

    milkbones_4_bigelow
    Link Parent
    Hey, thanks for this. Yeah, I'm using bs4 (regex as a last resort). I'm storing as a dict and using json.dumps. I will try to focus on drawing it out though, good advice. Can I ask why you think...

    Hey, thanks for this. Yeah, I'm using bs4 (regex as a last resort). I'm storing as a dict and using json.dumps. I will try to focus on drawing it out though, good advice. Can I ask why you think architectural models are useless? Most of the experienced devs I've spoken to have said I should focus on getting a good understanding there.