Neat, curious how “multitenancy” impacts these calculations - thinking about big DWH players like BigQuery, Redshift etc - or even stuff like motherduck.
Nodding along furiously. One area where this comes up is when you want to export some piece of logic that effectively “returns a table”.
For example, I work with a source of data that requires a particularly hairy JOIN strategy. The logic is the same for any table with the same “shape”, but no one can reuse it without copy / paste.
> Discoverability is especially hard because 99% of the music people create sucks
This - as a listener, quality is the hard problem. It is encouraging that the proposal affirms the value of curative functions (like labels).
As an artist, I actually don’t really care about music’s commercial problems - I’m more annoyed by the constraints on musical art objects inherent in all music platforms.
Like, experiencing art objects in a gallery hits different vs scrolling through bandcamp. The internet is, already, the gallery but it’s like we replaced all of the paintings with tiny prints, eclipsed by the placards.
The thing I would really love is a music platform that feels like a hosting platform, not a marketplace. Where a user can simultaneously act as a listener, an artist, a curator or a critic.
I think I have seen folks use rateyourmusic.com to get partway there already...
> The thing I would really love is a music platform that feels like a hosting platform, not a marketplace. Where a user can simultaneously act as a listener, an artist, a curator or a critic.
This was my first thought as well. I like the language, but I’m hesitant to adopt it without tooling that can extract an AST, ideally interoperable with the hard-won tooling we already have for SQL.
Improved UX at query development time is nice, but data teams need so much more than this. Stuff like lineage, linting, cross-dialect interop - these are no longer niche concerns, they are table stakes, and they come from having a shared syntax for data transformation.
You could implement a family of poorly defined dialects using SQLGlot, sure, in the same way you could define a meta-language targeted at Algol-family languages. That's not a substitute for adding language features.
Outlier here (musician, spend hours per week trying to find new music) - some thoughts:
- The search space for music is really large and noisy. Most of the stuff out there isn’t very good, and the stuff that is good isn’t always discoverable with a single strategy
- The best strategies almost always exploit human connections
Some strategies I use:
- Spatial locality, who is performing with or near artists that I like?
- Publishing locality, who is on the same label as an artist that I like?
- Artist locality, what other projects has an artist I like contributed to?
- Fan locality, what other artists does a fan of an artist that I like enjoy?
——
Note that none of these strategies are as effective as “relinquish control”. For example, there is a freeform radio station near me that I listen to all day at work. I have a rule that I won’t turn the radio off in the middle of a DJs set, even if I don’t like a song. This has helped me “break through” to interesting artists I wouldn’t have discovered otherwise.
To the article’s question, I think the main factor here doesn’t have much to do with music. Cultural production has exploded, and it’s really hard to navigate any cultural space in a non-obsessive way.
I thought it was interesting that the effect of “generational preference for music released when teenaged” seemed to wane around Gen Z. I wonder if this is just exhaustion, perhaps with tendencies towards pastiche as a consequence.
How deep are you digging that you can say most that is out there isn't good? I find this surprising. Or do you mean good as in to your liking? The amount of talent out there is kind of mind blowing to me.
This mostly an assessment at scale. By volume, irrespective of genre, and even accounting for subjectivity, most of the material that gets published isn’t very good.
That being said, I generally don’t agree with conclusions like “culture is frozen”. You are correct that there is _more_ high quality material available than ever before. The challenge is just that it’s harder than ever to find it.
You can try some college radio e.g. some smaller colleges in WA, or U. Mich radio station. But for freeform, I think in the US at least WFMU is considered the best. https://wfmu.org/
Davide of MIMIC Radio is good for classical music, as it's pretty much the only one I know that usually plays a whole classical music piece, and not a single movement, etc. and it's high bitrate as well.
If you enjoy this kind of thinking I'd recommend [1].
> Electric speed mingles the cultures of prehistory with the dregs of industrial marketeers, the nonliterate with semiliterate and the postliterate. Mental break-down of varying degrees is the very common result of uprooting and inundation with new information and endless new patterns of information.
> a single HIFI Enterprise account can easily have half a gigabyte of associated royalty data representing over 25 million rows of streaming and other transaction data
Curious about why they were struggling with this workload on BigQuery. It just doesn’t seem like very much data. Maybe they were cost-constrained and using a tiny slot reservation?
