skysight-inc/HackerNews huggingface dataset:
Note that your second example has a misplaced pair of parens:

WITH temperature_delta_past_day AS
(
SELECT device_id, abs(val - lag(val) OVER (PARTITION BY device_id ORDER BY ts)) as abs_delta
FROM measurements
WHERE ts >= now() - '1 day'::interval) calc_delta
)
SELECT device id, sum(abs_delta) as volatility
FROM temperature_delta_past_day
GROUP BY device_id;

should probably be

WITH temperature_delta_past_day AS
(
SELECT device_id, abs(val - lag(val) OVER (PARTITION BY device_id ORDER BY ts)) as abs_delta
FROM measurements
WHERE ts >= now() - '1 day'::interval
)
SELECT device id, sum(abs_delta) as volatility
FROM temperature_delta_past_day
GROUP BY device_id;
Seems to be trying to solve a problem that I would consider an anti pattern (attempting to 1 line everything). Someone else mentioned temporary vars and I think thats appropriate and equal if not better syntactically.

This example:

// Status quo
return filter(obj, negate(cb(predicate)), context);

// With pipes
return cb(predicate) |> _.negate(%) |> _.filter(obj, %, context);

Should in my opinion be written as:

let result = cb(predicate)
result = _.negate(result)
result = _.filter(obj, result, context)

return result

The main benefit of this is its experience and almost language agnostic. You see a variable defined and it's run through a series of functions before being returned. What's the point of removing a few characters?

edits: figure out how to format code, don't omit things
I hate that following assignment in the examples requires knowing precedence for the operator vs. the assignment operator. The = sign visually "points at" the first function call, but it's operating on the return value of the last function call, to which it has no spatial or visual connection.
> I found myself intentionally wasting time at work because any official pleas for help went unacknowledged.

That is of course problematic. My comment assumed a relatively healthy workplace where help is offered as well as more work.

> If I’m receiving high marks and positive feedback across the board, what are you trying to fix?

And only working 20 hours a week? Again, you need to do what works for you, but my understanding of the contract with an employer is that if someone is purposely doing less work than they've committed to, that's not good.

Flip it around a different way. If you signed up to do ~40 hours of work, but the employer structured things such that you regularly needed to work 60 hours a week, would you be okay with that as long as they gave you your salary? Or would you feel cheated?

I would feel cheated, myself.
I feel like there are some flaws in this, we don't usually have a "top-down" look at a mile around us if not given information (ie. fog of war), feels like we tend to point A to point B repeat because we are comfortable to take a route until otherwise told by someone else there is a shorter path. For example if someone had a drone/scout around I am sure you would be able to determine best routes and chokepoints, traffic, etc.
I disagree with a lot you have to say, even though you have valid concerns with are shared with a lot of hiring managers I talk to.

> 1. Significant amounts of people cheated during college, and if asked probably wouldn't even identify their behavior as cheating.

Unless you have some real data backing this up, you can't claim this is true.

> 2. Significant amounts of competent people don't even have a degree.

Don't disagree here, though the question of whether or not leetcode proves competency for day-to-day software engineering (of which changes given the type of job you are interviewing for) is still debatable.

> 3. Many people with degrees are incapable of actually programming even basic algorithms.

I have seen this phenomenon and it is a valid concern. However, you can still test for basic algorithms without resorting to leetcode hard questions on phone screens, which happens often (i am speaking from experience).

> 4. There is an incredibly high demand for this job because of its pay, leading many people to pursue this job in the market that have no actual interest or aptitude for the work.

Agreed, sort of. Its supply and demand - where the supply is artificially kept low at the interview stage be eliminating too many candidates who can't solve leetcode hards. Many of those candidates could be adequate, especially with minimal training.

A lot of your concerns are 1st order, surface level, but the solutions to the problem of tech interviews are a couple layers deeper in the stack. Leetcode is a monkey patch, an adequate one but it has its own set of problems that are ignored. That's why we keep seeing discussions about leetcode on HN.
You can rent from Amazon for $1/hour

It supports remote desktop and everything you would need
This is a self-defeating attitude.

It sucks sometimes, but we have to deal with the world as it actually is, not how we wish it to be.

When it comes down to it, the universe doesn’t give a shit about our opinions :)
Search should be the native feature of the Web itself (even if it's just basic), just like any other discovery protocol.
For some reason, I can't seem to submit the real announcement on HN: https://www.facebook.com/800665194/posts/10166121490710195/?...

(It looks like HN forbids any link coming from Facebook.)

In any case, congrats to the team! This is a big milestone. I'm wondering what this USDP or Paxos is though :)
https://www.grenfellvalueengineering.com/
Could you elaborate?

It seems to me that $20/year could be a good lowest tier price, especially for products targeting individual customers (as opposed to businesses). There are successful solo founder projects in that range (notably pinboard.in, $22/year).
One problem with sirens is that it is difficult for our ears and brains to process and determine which direction the siren is coming from. If you are in a car, even if you can hear the siren you can't easily tell if it is behind you or in front of you. "... only 26 per cent of occupants of a closed car could determine the direction of a siren" [1].

[1] https://www.canberratimes.com.au/story/6898454/why-is-it-har...

This is a known problem and hopefully some of the new proposed siren sounds will mitigate this.
... no. And your mental model of what operations cost is a little out of whack.

On the newest Intel cpus, a vector double precision multiply is 4 cycles. A horizontal add is 6 cycles. There is a single instruction dot product, which is 9 cycles.

Something like a dot product for fp can only ever be 1 cycle in a cpu that has a very low clockspeed. (Or is a barrel processor or something.) There is simply too much to do.
He hasn't been sentenced yet. That's just what the prosecution is asking for. The defense is asking for house arrest. The judge might still let him off with a slap on the wrist.
I see 2 targets that Nim could attack well with a bit of focus - Python and Swift.

Both have their strengths, but you always pick off people at the edges. Performance would do well against Python, and multi-platform against Swift.

This will be an interesting space to watch. If a beautifulsoup equivalent existed, I would put some serious time into it and reduce my Python time (but that’s just my need).
(NB: post author here)

We're planning on providing various outputs, json is definitely one format we'd want to support, want to file a github issue with the layout that you'd want and we can start getting some feedback to implement?
As dueling co-routine proposals neither ASIO nor Sender/Receiver are a suitable foundation for C++ semantics.
> Oh or I see timevector returns a custom datatype, so I suppose the answer is it has to be one of a fixed number of provided types?

Exactly! These aren't general arithmetic operators, they're specifically for mapping arithmetic operations over timevectors.
The question, to me, is whether the people with "lost" orders actually got a pizza in the end. If they didn't, then it is theft—if not by the individual, then by the company whose structure incentivizes the individual's behavior. (Similar to how Wall-street investment-auditing firms were ultimately responsible for incentivizing their auditors to mischaracterize the risk of certain asset classes in 2008.)
Another example of an experiment widely criticized is the Milgram Experiment (where you trick people into thinking they are electrocuting and eventually killing other people).

But the criticism is of the methods used being unethical - nobody is disputing the conclusions of the research (that more than half of the public will knowingly kill someone else when instructed to do so by a scientist they have only known for 15 minutes).
self.http_client = self.http_client or httpx.Client()

should be:

self.http_client = http_client or httpx.Client()

But yeah, once I learned that DI can be summed up into what you put here, I realized that DI is a $1,000 term for a $5 concept that has $100,000 ramifications in terms of what it enables you to do.
Thank you! It's being quite a fun experience for me!

Most of the features are inspired by racket (we've never used a LISP before starting the project, and a friend of mine suggested to use it). Right now we have:
- Numbers (rationals) and arithmetic operations
- Strings and some basic operations like split and concatenation
- Error raising/handling via the raise and call-with-error-handler special forms
- Anonymous (via fn) and named (via defn) functions, both single-arity, variadic, and multi-arity
- Definitions via the def special form (replaces the whole reference in the variable table)
- Local definitions via the let special form
- Mutation via the set! special form (gets the reference, replaces its value)
- Local state mutation via a combination of let + set!
- A simple macro system that only handles basic variable replacing and spreading of lists
- cons/car/cdr as it's a LISP after all
- Boolean operators and a `if` special form
- A simple import system that we're working on right now

There are some examples of functions built with the language inside the `std/` folder, I've created `map`, `filter`, `foldl`, `foldr`, and a mutable list using the functions, and `or`, `and` and `guard` macros using the macro system.
Its not clear how this complaint applies to a configuration language, since there is no mutability or change, configuration is statically evaluated.

I'd consider cue to be a config language that by and large tries to make invalid states unrepresentable.
It’s not a nightmare it’s impossible. Source, a sobbing wife who lost 15+ years of photos. Thankfully I have most of the import ones stored elsewhere.

Apparently for her and her friends Facebook was the “safe” place to store photos.

Only 20 minutes after she got an email saying new login and it was to late. They had changed recovery info and no way to change it back.
Only thing we accomplished was disabling
the account.

Almost all of her friends have lost their accounts.
My wife started to learn to program - the setup overhead in python (going via mac -> git -> windows / linux) was crazy.
Am I being foolish using ‘Sign In with Apple’ on sites?
Probably not. In latin america, government ID is pretty public and you share it for a lot of trivial stuff. It isnt considered a secret
One thing I think would be interesting - get listed on Computer Benchmarks Game.
Instead of beautifulsoup you're honestly better off just running an instance of Firefox/Chrome and scraping data that way. You can do fairly easily these days and I have a library that allows you to do so in Nim: https://github.com/dom96/webdriver
Working for a UK company here, although remotely from another country, making around $90k as a lead engineer in a somewhat specialized field.

Seeing as salaries are constantly rising due to WFH being so common, and with anecdotal data from this thread, I'm feeling I might be underpaid (closing in on 10 years of experience on top of CS diploma and an MSc).

So my side question is, how do you target high paying positions without having to go through a LC type interview in a FAANG company? Recruiters who reach out to me on Linkedin avoid the salary question usually.
> Sure it did.

No, it didn't. One because as the FAQ you link notes, owner-operators of trucks are not categorically banned. Second, as your FAQ also obliquely indicates but fails to clearly and directly state, to the extent ant existing business process was banned, it was banned by the California Supreme Court decision in Dynamex applying the ABC test to determine employee vs. contractor status, which is why
the lawsuit it refers to against the application of the ABC test was before AB5 was passed, and later amended to include claims challenging AB5, which codified the rule of Dynamex, added exceptions, and made some consistency changes in other law so that relationships that were employment for some purposes under Dynamex would not still be contractor relationships for purposes of other law.
For now, maybe.
Is this a common thing? I initially feel outraged against Google for their practices, but then I see a comment about how this is just regurgitated news. Now I don't know whether to feel annoyed at a site that just regurgitates other site content or what. Then I start thinking about how the majority of news sites regurgitate AP/other journalists. Bad Google. Bad Wheelsjoint. Who am I supposed to feel sorry for at this point? Us, the consumers? https://www.bloomberg.com/news/articles/2021-08-19/toyota-cu...
We've suffered under "bad parts" in JavaScript before, and the solution was not to use them, which works out fine for the most part. But I tend to agree, adding a functional language feature built in a way that conflicts with Ramda and nearly all existing FP libraries is no better than simply using R.pipe.
Southwest backs off plan to place unvaccinated employees on unpaid leave in Dec
It would be interesting, yes, but the maintainers of that have explicitly refused to add Nim (and other "new" languages).
View your site in 3D to fix DOM, z-index, or performance problems
I can assume that this special syntax allows for better optimizations; the SQL variant is much more flexible, which means you can make much less assumptions, and thus less room for optimizations.

Not sure if they’re doing that (especially for the v1 version of what looks to be primarily a syntactic selling point, rather than a perf selling point). But that’s what I would do.
The worst example of this is the recent NCAA shoe company bribery scandal, where shoe companies paid student athletes and their families to attend particular schools sponsored by the companies. In any other industry, delivering money to people who become a part of your organization and generate revenue for it is just employment, and having your sponsors pay them directly is just cutting out the middleman. Only in amateur sports is that considered bribery and an offense that can get a person sent to prison.

Kickbacks, of course, are quite different, where a company official has a legal duty to negotiate in good faith in the best interests of their company and not make purchasing decisions based on which vendor gives them the biggest personal cut of the deal. It's hard for me to see the other side of that, how anyone can possibly not understand that that is illegal.
I was thinking about this earlier. I’ll give the idea away because I don’t have the time to build it. We should tokenize search. We can store data like location, trust score and reviews. Currently search is pruning a lot of things for the sake of money alone. Has anyone noticed a reduction in quality results and an increase in repetitive content? the current algorithm is terrible. If you are reading this google, rollback or fix the AI influence on search. It has become a lot harder to discover new content with this algorithm. And it seems to be punishing the wrong content. Just my two cents
How does you forgetting your password absolve you from paying for resources within your account?
> Python is such a joy to write and such a nightmare to set up, package and distribute.

Here's my simple-minded metric on when this problem can be called "solved":

Get a VPS from GoDaddy.

Deploy your Django app as easily as you can deploy a PHP app, say, Wordpress.

I have written about this before. I love Django. And yet I think that they have done a huge disservice with the development server and DB configuration out of the box. Even for a simple application, going from developing on your desktop to deploying the same application on, as an example, GoDaddy, is in a range between nightmare and impossible. I have personally given up multiple times and just said "Fuck it! Just use WP" even when I really, truly wanted to stay in the Python/Django ecosystem.

Try it. Develop a simple photo album application. Get a VPS from GoDaddy and deploy it.

No Heroku et. al., are not solutions. They are indicative of the problem.
I'm the author of HashBackup.

What I like about Backblaze B2 is that is has simple, no gimmick pricing, unlike almost every other cloud storage company. It doesn't have delete penalties, where they charge for storage you've deleted. It doesn't have minimum file sizes, where they charge for storage you aren't actually using. It doesn't have a minimum payment every month.

For backups, their business is very competitive with the big 3, especially considering that they will mail a physical drive to you with your data.
> as evidenced by Leibniz, it seems like most of it would have happened without him. his work on series was probably not going to happen for a bit without him.

I think that part of what was marvellous about Newton (Einstein, too) was how many things he did. As you say, it seems plausible any individual thing Newton did would have been done by someone else—probably the same is true of anyone—but it seems unlikely that any one person could have done everything Newton did.
I thought that was very interesting too. Especially when you pointed out that tweet from Alexis.
Until YC funds a company that specializes in making shell company^2 to make sure your C suite side deals are undetectable.
> return a custom data type that represents the composed set of functions, and we can (for at least part of the pipeline) handle simplification and combination of that into a single set of functions to run over the `timevector`

I'm really having trouble wrapping my head around this idea. I guess it speaks volumes about the potential and power of PostgreSQL in general.

Has PostgreSQL ever been used like this in the past, or is this really thinking outside of the box?

We don't use TimeScale or have any intention of in the immediate future (Snowflake provides 99% of what we need atm), but I'm always interested and impressed to hear what they're doing.
(NB: Post author here)

This is in the TimescaleDB Toolkit extension [1] which is licensed under our community license for now and it's not available on DO. It is available on our cloud service fully managed. You can also install it and run it for free yourself.

[1]: https://github.com/timescale/timescaledb-toolkit
> Today, after the invention and normalization of opinionated autoformatters, it means that the autoformatter can't figure out for me how my code should be indented

This is precisely why I prefer significant space: it forces you to write tidy code. Sloppily written code that depends on the autoformatter to be properly indented makes me suspect the logic could be sloppily written too.

Besides, any humble plain text editor understands autoindenting, so there's no sensible reason to not indent properly.
Without further context than the title provided, it could mean that they deleted the articles from another Google property, not search results.

Not sure what that property would be. Blogger perhaps if that is still a thing?
Both ASIO and Sender/Receiver are not a suitable foundation for concurrency in C++.
I absolutely believe he should go to prison. If a fine is the only punishment for a crime, then that law only exists for the lower classes. The only way to punish a rich person and deter other rich people from crime is to take away their freedom.
Not everyone can think lol.
My kids gave it a name: shade hopping
The Seattle area (though not signifcant swaths of Seattle itself) are built on a cardinal grid, meaning you can get pretty much anywhere with just 1 turn, ignoring dead end streets.

It is pretty nice, it means getting lost around here is hard.

Our addressing system is absurdly logical, first 2-3 digits of house address are the street #, then you have the cross street as the 2nd part of the address. (Named streets actually are also numbered on the grid, and you can see the real street # above the name sign!)

This means you can give me an address and I:

1. Know the exact location
2. Can navigate there

Again with a sad exception for named streets, you'll have to look up the # of the street first before you head out.

Because everything is on a cardinal grid, you just head north/south and then east/west.

The best part is, if you get lost, it is easy to re-orientate yourself!

If you get wet and the water tastes salty, you went too far west!

If you get wet and it is fresh water with a hint of sewage, you went too far east!

If everyone around you gets really polite, you are way too far north and have ended up in Canada, and if you see gas station attendants pumping gas, you've gone too far south and have landed in Oregon. Easy peasy!
32 Bit Real Estate
My understanding of the AG's letter is that it's not directed towards Coinbase. Coinbase is and continues to be legal in NY State, regardless of my dim opinion of its business model.

Edit: Unless you meant all of the thinly traded altcoins they've been adding which, yes, NY State has been correct to forbid. Penny stock fraud but with tire burning as the economic substrate.
Problem is that customer pricing demands are infinitely granular, with i only want to pay for X that i use.

The alternative is the tiers which have their own problems.

Small
Medium
Big
Call us

No one know if they are gonna have success in the beginning or need to scale up. Usually. I guess at a size like AWS it makes more sense to have those infinite pricing tiers and let the customers figure out how much they are willing to pay rather than try to negotiate with huge swaths of people that take sales staff salary to deal with.
I thought "essential" cookies didn't even need consent? Either way, cookie consent nonsense and the banners caused by it are a blight whose benefits ("solving" the absolute non-problem of advertisement tracking) pale in comparison to the enormous collective inconvenience and wasted developer hours they've caused us all. It's sad that we look at a banner that's not as bad as it can be and appreciate it, like someone saying their spouse only hit them three times today instead of ten.
Actually, the bare minimum is a well supported and centralised numeric library providing arrays, matrix and the base tools
> IPC, memory management, process management, network management.

I imagine the non-trivial parts of these are done for the JS VM (correct me if I'm wrong), and therefore a VM design course would have more intersection with Browsers with respect to these disciplines than an OS course.

> security

This one is everywhere, it has no special connection to OSes.

> They all happen at a slightly higher layer

Slightly?! That's an understatement of the week! The difference in abstraction levels is huge here and the specifics of the two levels are very, very different.

> in terms of what you need to know, an OS class or three is definitely helpful

Sure. But I think it's as useful as any systems programming course. I can agree that systems programming is a good preliminary for both Browsers and OSes, and learning either of the two will teach you a good deal about systems programming, but I doubt they will repeat each other.