Comments URL: https://news.ycombinator.com/item?id=46716735

Points: 7

# Comments: 11

Comments URL: https://news.ycombinator.com/item?id=46301338

Points: 2

# Comments: 0

> This is the kind of "lore" that's impossible to catch from raw data.

Agreed this project definitely banged up against those sorts of walls a few times. Still think it's worth trying, hopefully the information offered one can find outweighs any distortions it introduces. Maybe something that should have been explicitly acknowledged in the piece.

> I like the Essential Mix visualisation even more! It's such a shame most of the other ones appear dead due to API changes.

Thanks, happy to hear that. I keep meaning to go back to the essential mix one, get new data and apply some of the stuff I've learned since!

Demographic analysis would have been interesting I agree, but I didn't know of a good data source for that and it's hard to parse from line up data (especially in places one isn't familiar with)

Comments URL: https://news.ycombinator.com/item?id=45835083

Points: 166

# Comments: 87

Instead of scattered .sql files or copy-pasting into clients, write annotated queries once and pipe them to any sql database client. Variables get substituted, destructive queries can prompt for confirmation, and your schema stays documented alongside actual queries.

For example, if you have a `queries.sql` file like this:

  ---
  -- @name QueryWithVariables
  SELECT * 
  FROM orders o, users u
  WHERE u.id=@user_id 
  AND u.active=@active
  AND o.status=@status
  AND o.user_id=u.id
  LIMIT @lim;  

  -- some variables
  SET @user_id=2;
  SET @lim=10;
  SET @active=true;
  SET @status="completed";

  ---

Written in go, `go install github.com/kalli/sqlyac@latest` for a small-ish binary: https://github.com/kalli/sqlyac

Blogpost with more info: https://dev.karltryggvason.com/sqlyac-structure-and-tooling-...

Comments URL: https://news.ycombinator.com/item?id=45592482

Points: 5

# Comments: 1

I don't know what the mechanism/incentive for getting a standard would be either. Probably most likely would be if there was one clear "winner" that everyone else felt the need mirror.

In any case, appreciate the reply and the tool. Good luck with it.

One annoying thing I've found in testing these tools is that a standard hasn't emerged for using the results of one request as input for another in the syntax of `.http` files. These three tools for instance have three different ways of doing it:

* hurl uses `[Captures]`

* Vscode-restclient does it by referencing request names in a variable declaration (like: `@token = {{loginAPI.response.body.token}}`).

* While httpyac uses `@ref` syntax.

From a quick round of testing it seems like using the syntax for one might break the other tools.

[1]: https://hurl.dev/docs/capturing-response.html

[2]: https://github.com/Huachao/vscode-restclient

[3]: https://httpyac.github.io/guide/metaData.html#ref-and-forcer...

These parameters are then (sometimes) used to surface a banner in the app when the receiver of the link opens it. Something like "user so and so shared this with you, want to follow them?". I'm presuming they are also used for ad/data mining/network building purposes under the hood.

For example Instagram adds an igsh parameter to share links while Youtube and Spotify add a si parameter.

I guess these are a continuation of the utm type parameters used for marketing. But they feel way more creepy and invasive when operating on a personal level than at a marketing campaign level.

Also the user isn't made aware of this parameter at all. A user link could get sent onwards and would identify the user as a source long after they are out of the loop.

Any thoughts on these practices? Is there an opt out somewhere?

edit: formatting and typo

Comments URL: https://news.ycombinator.com/item?id=44134198

Points: 1

# Comments: 1

Gives you similarly obscure videos, but without any context or links which makes it feel more ephemeral and random in my view. Have spent many hours down that rabbit hole, makes me feel like I'm watching the interdimensional cable from Rick and Morty

If:

1. You love the Simpsons (well seasons 2-10 anyway).

2. The day-to-day trenches of adult life sometimes get you down.

3. You have a special little one.

Then this de-motivational plaque creator might be for you! I use it as a reminder that sacrificing for other people, in a myriad of petty, unsexy ways every day can be deeply meaningful.

For context here is a clip from the original Simpsons episode: https://www.youtube.com/watch?v=3njZSDjW7Q4

Comments URL: https://news.ycombinator.com/item?id=41847308

Points: 5

# Comments: 1

I think this "trend" is likely to be fake or at least wildly overblown. But I built a digital version that you can use for free. Take the gpx of a real run of yours and create a faster version that you can then upload to Strava. I'd encourage you not to use it!