skysight-inc/HackerNews huggingface dataset:
A good example might be a groupwise maximum. Those always tend to be a bit of a PITA in SQL if you're not writing them regularly. Be interesting to see what it transpiles to, as well.
> Once you have kids, you’re not willing to take them to the Bean on a weekend and end up in the middle of a shooting

A (irresponsible) buddy of mine once drunkenly fell asleep by the bean, and was woken up by a nice homeless fellow who told him “hey man, can’t be sleeping here, the cops will fine you.” Wallet, phone, etc all still in his bag.

I lived across the street from the bean for 3 years. I’m more likely to get injured in a car wreck driving around the suburbs than a shooting by the Bean
Imperial Science and the Company’s Museum
do construction workers in US have reputation of working under the influence too?

those who work on those "simple" projects like renovation of homes and stuff
The article picture almost had a Droste effect, almost.

https://en.wikipedia.org/wiki/Droste_effect
iPhone 12 mini, GoPro Hero8, and x100f.

Mostly, iPhone camera, works great almost always with me.

But phones are addicting and distracting. Lately, at home, I have been carrying my GoPro with me and using that a lot more. It is especially great for making videos, stabilization is better in GoPro. Photo quality is lower though. At home, I am mostly interested in capturing moments with my kids, quality is not that important.

And my favorite camera is x100f. It is absolute joy to use. It is like driving Ferrari vs Outback. Both cars will get you there, but one is not about getting there. It is about enjoying the process.

I take it out once or twice a week, and use it on special occasions. Sometimes, I use it for kids photos and sometimes, I am just playing with it, taking random photos, at home or on walks/hiking.

I highly recommend Fuji x100 series.
As said, currently PRQL transpiles to SQL, so all expressions in PRQL are can be expressed in SQL. But not all SQL expression can be translated back into PRQL - some intentionally and some are just not yet implemented (UNION - i.e. vertical concat).

But we also have plans for doing things that some SQL databases may not support, such as pivot (rows to columns).
Interested in learning what others do. I've been in this same situation and the options are not ideal. My best bet so far is to cobble together some public domain (no attribution) SVGs, lightly adapt as needed, and use them to generate my PNGs, etc.

That's what I did for https://delayedsend.com, for example.
This older video makes it feel like the drone industry has been somewhat stagnant.
All of these are equivalent if you have showed your team that you trust them and value their work.

If not, then only the first version is acceptable.
On the ethics front:

* Yandex released everything as full open

* Facebook released open with restrictions

* OpenAI is completely non-transparent, and to add insult to injury, is trying to sell my own code back to me.

It seems like OpenAI has outlived its founding purpose, and is now a get-rich-quick scheme.

What I really want is a way to run these on a normal GPU, not one with 200GB of RAM. I'm okay with sloooow execution.
A few random thoughts:

• There's a place for closed platforms if open ones are a reasonable choice. A closed platform must not be the only choice available to the customer, but it should be allowed to exist given a healthy market. It's hard to argue that iOS is a monopoly, and if so, than a browser engine and JS interpreter with access to the open web is a very powerful thing that the owner of the platform may deem too powerful for its own good.

• Chrome's dominance of the Web is very scary. Not as scary as IE's, since it's open source, but still, it's such a huge beast that it's almost proprietary through complexity. I don't know if there's an easy solution out of this.

• The time it takes Apple to patch security flaws is not the main issue here and should not be the core argument. What if Apple steps up its game and gets really good at this?
The issue is the strategic decision Apple is making and the discussion should be if a company that powerful should be allowed to make such decisions and impose them to the user.

• Apple could avoid this discussion by giving the user a one time only toggle switch to sideload any binary. It should be buried under many menus and preceded by lots of scary dialog boxes. It could even void battery warranty or something. Maybe keep a constant orange menu bar as a reminder that you are on your own and can't blame Apple for anything.
Here's one suggestion: SQL tediously requires specifying the equality condition on joins, when 90% of the time you just want to join on the fk defined between the tables.

from a
join b

should implicitly join on the FK if no condition is given.

It would require knowledge of the schema. I don't know if this is possible in PRQL, or if the transpilation to SQL has to be stateless.
What are peoples thoughts on palladium? I’ve found their articles and podcasts to be a refreshing analysis on modern socio-political issues with minimal culture war or partisan interference. Any other podcasts of similar quality and rigor anyone is listening to?
I think I would have prefer the scroll being correct, it would have made the discovery more rewarding. Good video
> you handle payments, integrate with other services, queue tasks for later

I distinctly remember buying things on Amazon in 2005. Actually come to think of it, I did everything you list in 2005, at multiple companies.
Needs a (Sri Lanka) tag or something.
The shifter isn't the only BMW-looking thing in that Supra's interior, it is a modified BMW Z4 interior as the Supra as a whole is a BMW collaboration. As for the other two, I would say the presence of the BMW shifter has more to do with them not wanting to spend money on designing their own than any contractual obligation or anything.
NIMBYs don't cause the gross mismanagement of funds on existing rail lines.
What's depressing as hell is when you first start searching for a job and you've put in a massive effort yet for like ~a week you get no responses. It really kills moral. But usually then all the replies come in a deluge and you wonder why you were ever worried to begin with. Job searching is a legit emotional roller coaster, lmaoo.
I'm never sure why people speak so positively of IHP. It's like, yes, I'm a fan of Nix and Haskell, but IHP is effectively paid (at $25/mo! that's not even a paltry sum) for any of the more worthwhile features regarding account management. I have no clue why I'd want to buy into an ecosystem where such features are sequestered away from me by default.
Nah, the C preprocessor is a disgusting hack. I really don’t understand why they didn’t opt for a more logical, AST-based macro system when the base language has such bad expressivity in itself.
https://akaricons.com
> Outlook will only send GET requests, which are idempotent unless you're ignoring the spec. A message saying "this code has already been used" after sending a GET request is a bug.

Alright, so imagine this: we have two endpoints GET "/page" and "POST /increment". Making a POST request to "/increment" increments a counter kept in memory and returns it's new value. The GET "/page" endpoint returns a HTML file, which contains JavaScript code that when executed, calls the "/increment" endpoint.

Are we now breaking the HTTP specification saying GET requests has to be idempotent if we visit "/page" in our browser? I think not, but this is sometimes how pages are implemented, which robots are gonna have to deal with, as otherwise many would consider it broken.

Don't get me wrong, I think it's a shitty implementation as well. But is it breaking the HTTP specification? Unlikely.
this looks great!
It's because they set "object-fit: cover" on the video element's CSS.
Abortion and the FDA
UK is talking about backstopping the stable coins is an example of influence. I assume they are referring to Tether which hasn't completed an audit.

https://www.cnbc.com/2022/05/31/uk-plans-new-safeguards-for-...
Great questions!

Window functions are here [1]. (We should add these to the homepage too)

Implementation specific queries can be handled by the Dialect parameter [2], though there's still lots of work to do to build that out.

[1]: https://prql-lang.org/book/transforms/window.html

[2]: https://prql-lang.org/book/queries/dialect_and_version.html
This is awesome! Does this support history syncing?
I've seen similar solutions being built internally in multiple companies, none with a syntax as well thought out as this. Amazing work!
You just compile a dev version of the game during development.
Don't take the CKA/CKAD exam
If you use firefox or safari, you routinely encounter sites that don't work without chrome.
I’m excited to try this out. The idea of cloud hosted browsers is not new, but this approach seems really promising. In this era of connectivity and cloud compute, it makes so much sense.
This can be transpiled into SQL which makes it then trivial that it can do everything SQL can do. SQL is Turing complete so it can do anything PRQL can do.

EDIT: I'm sorry, I didn't realize that even if something transpiles from one language to another it does not guarantee that one language can generate all strings of another language. But taking a look at the abstractions PRQL offers I would be very surprised to find it not capable of it.
I do have a robots.txt to block this directory. But Bing only listens to that for what to crawl, not what to index.
Not sure why that would make sense. The only source of M2 chips is from Apple, and then only by buying an entire computer…
>So then your answer is that Apple's browser is significantly worse than competitors, and that users wouldn't use this much worse product if it were not for Apples anti-competitive behavior?

Yes. I hope it's exceedingly clear that I don't think Safari is God's gift to mankind.

>Are you saying that all someone would have to do is argue for allowing just Firefox

Yes. In fact they could be upfront and just say "just allow Chrome because I like developing for Chrome." But that's not what happens; it's "Apple is stifling competition because I want to use Netscape Navigator", when in actuality it's just developers that want to target a single platform, or Google who wants protect itself from Apple's power.

Maybe OWA is the exception here, but what I've found is the people making the most visible noise about this are connected to Google in some way. Consider this HN post from a couple days ago [1], where the author in his six-part series about browser choice, neglects to ever mention Chrome's dominance. Unsurprising that he was also a platform strategist at Google. You're telling me the guy who's job it is to make sure Google is an entrenched as possible doesn't like Apple's position on Safari? What a surprise. Then he tells you "don't worry about Chrome, this is about open standards!" - sounds underhanded to me.

At the very least, the cohort of users on Safari who can't switch prevents Google from just outright breaking some sites like Gmail and YouTube on every browser except Chrome.

[1] https://infrequently.org/2022/06/apple-is-not-defending-brow...
> But index crimes in Chicago are far below where they were at any point in the 1990s. The full context isn't just "crime is up", but also "up from where".

That context isn't helpful for someone who is considering where to live. I don't care what crime rates were in a city 30 years ago, I care how a given city's crime rates compare to other places today (and possibly in the foreseeable future).

> But it has not at all much to do with the quality of life for professionals in the city.

I take your point that, in a segregated city like Chicago, the north-side crime rates are going to be a lot lower than the city average, but I'm pretty sure rates are rising in virtually all neighborhoods.
Maybe they meant Opening up AI :)
For you or them? I think if they don't want to get better or admit they have an issue it is very hard. In my experience and from what the article says, it seems to stem from the internalized feeling that you are helpless (because other people traumatized you) but also that you are at fault (because you should've known better or you should be able to control your responses 100% of the time). This sets up a very adversarial and resentful inner view of conflict. As your responses destroy both your own health and your relationships, these views are reinforced.

Learning to accept that you are NOT ruined, that other people's actions aren't your fault, and that people don't hate you just because you have conflict seems to be the stem of this for me. From the therapy side, that seems to be what has helped my symptoms. Extremely freeing and I'm very happy to hear that there is a name for this.
I am literally angry with this attitude, yes; accurate observation. I do believe that companies need to change to accommodate those with disabilities. Is that so far fetched? Ableism is a systemic issue that should be addressed.
Harsh but stick a joke in there so it looks like you aren't a dick.
After we lost Net Neutrality, it was only a matter of time before this crap happened.
You're not talking about Hyperloop are you? They sure seem like human sized pneumatic tubes to me, and are highly reminiscent of the Mario pipes.
Perl/Bash/Python? Maybe for non-mission-critical things. By 2005 everyone who needs stability/scalability were using J2EE.
I wouldn't say "supreme" is inaccurate, since the Supreme Court is superior to every other court.

(That's if we accept that Parliament is no longer a court after the Supreme Court assumed its judicial responsibilities. Also, I'm likely wrong because everything one thinks one knows about the UK constitution is always wrong, but feel free to tell me how so.)
My friend made this: https://akaricons.com/

Let me know if it helps. I can forward your message to him
What does people on a forum criticizing other people have to do with Title VII protections? This has nothing to do with employment.
No they don't. This is just pointless sophistry. It does not explain the idea. It's writing that looks like the point is to show the writer's erudition, not explain the idea.
> I am genuinely curious if the Moon is hollow or not and what could be inside it

I mean, I think if it was, that would have caused some prior comment (and alarm).

It's not hollow.
If you do something that benefits Firefox, but has an outsized benefit for Firefox' competitors (or rather, anti-Firefox hegemony) and the net effect is overall worse for Firefox, then that thing that benefited Firefox was not good.
The logbook is awesome: https://github.com/facebookresearch/metaseq/blob/main/projec...

This is the true secret sauce -- all the tricks on how to get these things to train properly that aren't really published.
Ask HN: Cool gTLDs?
With the proliferation of new generic top level domains (gTLDs) what ones are your favourites that you like to register? For me .xyz seems a bit spammy, but other ones like .blog and .page and .link seem cool. And I discover new ones all the time!

What are your favourites?
A common strategy for binary auction scams is to rig the market in your favor so that you think your a genius and then you go all in. Then they rig the market against you or simply block withdrawals.
This is really important to understand. Someone explained to me once how small changes (low single digit reduction) to cars on the road leads to huge congestion benefits. I'm sure someone on HN will have a good citation. Public transportation helps you have your luxury experience.
Yes! Whist will support all native Chrome features like history sync-ing :)
Uh, I don't think so. It's a hard job and often involves heavy machinery. One of my cousins works construction and does enjoy drinking but always after hours afaik.
Contractors who work in the home, not really. Construction workers might crack a beer at work, but it's nowhere near the "builders" stereotype the UK has.
https://www.flaticon.com/

https://thenounproject.com/

https://fontawesome.com/icons

https://icons8.com/
I think using the word 'traders' for these scammers is generous.

Should reddit be allowed to present financial advice via their forum.

That to me is a problem. Free Speech or financial system rules.

People can say things on a forum with no repercussions. True or not.

AMC is a shit stock now and it was 5 years ago. Gamestock too.

Elon Musk says one thing wrong and is attacked by SEC. Not fair at all.

Crypto should have been snuffed out by regulation many years ago.
> Submodules done right

Click-bait marketing seriously?
I know what it is, do I qualify for at least a junior position? :D
Some cyberpunk novel or another suggested you could engineer a structure where atoms surround a core of vacuum, making the assembly as a whole lighter than air. Cool idea, altho of course any piece that breaks off will float up into the atmosphere and become a hazard to powered air transport, so it would have to degrade after prolonged exposure to UV.
EdgeDB looks promising. Postgres under the hood so you know it's stable.
> I'd switch the tone based on [whether you want a discussion or are insisting on a change]

I think that's a great example of where "tone" is absolutely not sufficient, especially in the modern world where many readers aren't going to share your first language and won't absorb the nuance.

If there's a situation where your disagreement is absolute, you need to say that factually, ideally with a recipe for how to resolve that included:

"I can't approve this scheme, please do X instead."

"This API isn't OK to use here, you have to..."

"Under no circumstances will I ever approve of a feature that does this."

You can phrase those as nicely as you want, but it's imperative that your disagreement be spelled out explicitly.
Cool, so we should just stop building and running almost anything in existence because it's not all-encompassing? That sounds like a suboptimal path forward.
>Again I’m failing to see the distinction. Why did that team need a string? Presumably it’s mutating right?

As a Rust programmer this is what I'd expect, because that's what alloc::string::String is for but this is not how std::string is used in C++ & especially not how it was used at that time

So I spent some more time reading. Beyond signifying ownership std::string has other properties that the raw pointer char * does not have which influence the C++ programmer and especially the enthusiastic but perhaps less experienced C++ programmer

1. It's a real C++ type whereas char * is left over from C

2. Unlike char * the std::string remembers the length of the string which also speeds up equality comparison (we know "classification" != "class" from the length before we even look at the text data)

3. std::string has a "Small String Optimisation" which will be emphasised repeatedly to you by C++ gurus. This means small local strings don't need heap space which is good. So... you should use std::string?

Now. If we compare &str and alloc::string::String:

1. Both Rust types, not left over from some prior language

2. Both know how long they are

3. Neither has "Small string optimisation". You can do this trick (oh boy and how) in Rust, but Rust's standard library intentionally does not provide it and nobody's public APIs expose such a thing.

> &mut str would let you mutate the existing characters (similar to char) but it doesn’t give you permission to resize (since doing so obviously might involve a reallocation and change underlying pointers referenced elsewhere).

Yes it would, and this exists but I've rarely seen it put to any use.

> The more generous interpretation I’ll read here is that Rust has stronger conventions here.

Ultimately yes, the conventions are stronger, a cultural difference. You can go look for yourself, at both the sprawling vastness of public Rust library and Chromium's own APIs in that era which often take string despite having no interest in ownership.

Chromium has a map (of configuration parameters) inside it, in which the keys are std::string. If you understand this as an owning object for mutation that sounds insane but if you just think it's a convenient object that knows how long the text is and keeps shorter text out of the heap it's awesome. Right?

Of course, you can't just compare a char * to a std::string, the map has no idea that would be possible, so you make a std::string from your char * and compare that. Don't worry there are only a few dozen configuration parameters to check, what do you mean this hash lookup now incurs a heap allocation ?
* This shall be extracted to a separate function.
Apple can block any web feature that they don't like, regardless of "browser"...
> inadequately encrypted passwords,

Assuming this means unsalted hashes. Since when has the FTC been going after this?
If you install Ubuntu or any other user friendly distro you might not ever use any of them.

I know what they are, obviously, but I don't think I've needed any of them other than uname because I don't know where Ubuntu prints the kernel version.
OpenWallet
I’m not an expert on US law but arent the libraries funded from tax?
You say that you won't ride a bus. But what I'm also hearing is that you really don't want to pay for a bus lane, either. That the very existence of public infrastructure that you will never use is a deep, personal affront to you. Am I hearing that clearly?
> I think the million dollar question is how government organizations can hire and retain better.

Simple: offer salaries that compete with the private sector. Of course, this involves raising tax revenues which is incredibly unpopular politically. But we get what we pay for and as long as public sector pay remains a joke compared to the private sector, we are always going to have this problem.
I wonder if there are any other United Kingdoms out there besides Britain.
No one is arguing for that. Supporting public transportation for others will help you maintain your luxury driving experience.
> Corporate morality rarely extends beyond its value as PR. Once the financial cost of doing the right thing exceeds the PR value, it's probable that the financial considerations will prevail.

Make that the morality of most individuals. Few people in the world are bleeding hearts. Most will pay lip service to a cause and then go back to work on Monday to pay taxes to the very government they condemned as oppressive. If every Tom, Dick, and Harry are each fickle enough to preserve themselves when their livelihoods and investments become threatened, why expect a group of them under the banner of ABC, inc. to be any more self-sacrificial?
American cities, being large and complex systems, are not centrally planned or managed to the extent that would allow for optimization of logistical concerns. The financial motivations of large development firms, coupled with their political power (aka bribery of elected officials) has resulted in cities that are disorganized and unoptimized for the movements of goods and people. These systems are very good at creating profitable projects for those with enough capital, however. The federal highway system is about the best thing one can say about America concerning large scale construction projects - the relic of a bygone era.
So far Orville S3 has been lackluster compared to previous seasons. The episodes so far have felt more like a knock off.
From an engineering perspective, racing cars are much closer to aircraft than they are to road cars; they just have their wings upside-down.
Knowing very little about HVAC, when I worked in higher education I was surprised to learn that some colleges centralize heating and cooling for their entire campus. For example, Harvard has a chilled water plant which cools 75 buildings: https://www.energyandfacilities.harvard.edu/utilities/chille...

Interesting article from the Crimson (student newspaper) from 1978 about their recent-at-the-time move to computerize the heating and cooling systems: https://www.thecrimson.com/article/1978/1/12/the-great-chill...

Edit: fixed unintentionally humorous typo, whoops
How about when Iran chants “Death to America”? Do they feel the same way?