HN user

r1b

107 karma

(hack planet)

Posts8
Comments42
View on HN
Composable SQL 1 year ago

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.

Pipe Syntax in SQL 2 years ago

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.

Pipe Syntax in SQL 2 years ago

It’s strange to me that the interop story here only considers compatibility with GoogleSQL.

These days, we have tooling that can generate an IR for SQL and transpile it to any dialect (see: sqlglot).

Doesn’t coupling SQL syntax to dialect-specific SQL semantics throw a wrench in this?

WFMU is indeed the one I’m referring to here :)

To get the freeform format with newer, “shinier”, and often more electronic sounding music, I also like NTS.

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.

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.

Recommend checking out https://github.com/tobymao/sqlglot if you are interested in this capability for other SQL dialects

Tools like this are helpful for:

- Rendering SQL in a consistent way, eg for snapshot testing

- Testing SQL business logic in CI against a dialect with less heavyweight dependencies

- Applying AST transformations to take advantage of dialect-specific optimizations

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?

Thanks for sharing this. We are going through a similar organizational shift at $JOB where a large team has been split into several sub-teams that own services. It was valuable to see how you adapted the on-call rotation to this new structure.

On using a public channel for coordinating incident response, we have struggled in the past with stakeholders joining the meeting and offering well intended but ultimately distracting input during the incident. We’ve found it best to have one responder play the role of “incident commander” and manage external communication / rope in more stakeholders as needed. This helps avoid conditions that make the incident even more stressful, like say a member of upper management demanding frequent updates or spreading FUD.

Urbit is a cool idea and I resonate with its motivation but I fundamentally disagree with its execution.

The fact that we have bad platforms does not imply that we have bad systems or bad protocols. I think the rotten core of the bad-ness of the internet is commercial infrastructure. It's prohibitively expensive for users to truly own the most basic commodities of internet infrastructure, i.e names (DNS), numbers (IP) and peers (BGP). These commodities would enable users to make the most of the protocols that we already have.

There are already many projects that try to combat the commercialization of the internet by adding new systems and protocols (Solid, IPFS and ActivityPub come to mind). Users shouldn't only be free within the confines of these systems - they should be first class nodes on THE network.

The spirit of Urbit is spot on but it's at the wrong layer of the OSI model. I have much more faith in people who are trying to operate public networks (i.e NYCMesh) and would like to see more projects that aim to de-centralize the basic commodities of the internet.

On my `about:addons` page under `Extensions` I see an entry for `Looking Glass`. It has no icon. If you click it, it expands to read:

Looking Glass

By PUG Experience Group (list of names) <a contact email>

MY REALITY IS JUST DIFFERENT THAN YOURS.

Looking Glass is a collaboration between Mozilla and the makers of Mr. Robot to provide a shared world experience. Are you a fan of Mr. Robot? If so, join the hunt for answers!

Participating in this shared world experience requires explicit user opt in. If you are not actively participating in the ARG (Augmented Reality Game) no modifications will be made to Firefox.

https://support.mozilla.org/kb/lookingglass

---

I do think they should have added an icon and NOT used the extensions as a delivery channel but I also don't think it screams malware. There is a contact email and a link to a page explaining the extension.

I still don't understand why this is such a big deal - here's what it reads on my `about:studies` page:

looking-glass-2 Active • MY REALITY IS JUST DIFFERENT THAN YOURS.

Looking Glass is a collaboration between Mozilla and the makers of Mr. Robot to provide a shared world experience. Are you a fan of Mr. Robot? If so, join the hunt for answers!

Participating in this shared world experience requires explicit user opt in. If you are not actively participating in the ARG no modifications will be made to firefox.

https://support.mozilla.org/kb/lookingglass

---

Here's more about shield studies: https://support.mozilla.org/en-US/kb/shield

It also lists some previous studies that ran on my browser. I have never noticed any of these.

Current parameter store user - one feature not mentioned in the comparison is the fact that accessing / updating a secret in parameter store will show up in Cloudtrail. Is there a similar audit trail in strongbox?