skysight-inc/HackerNews huggingface dataset:
Hey abbadadda, sorry to hear about your situation :(

Our company's building out a solid data science platform, and has a history of hiring people with your generalist SWE/Data background. I've no clue what our staffing quotas are for this year, but we're growing fast, so I imagine there are spots to fill.

I'm not on the data team, so I unfortunately can't give you a direct referral there, but if our recruiters (they're good) and hiring committee like what they see, you could probably be on-boarded within a few weeks.

Our pay's pretty competitive, and there's a lot of talented/eperienced people (xooglers, fb, bloomberg) here – check us out?

Wishing you the best of luck, here or anywhere.

https://www.hioscar.com/careers/21166
https://www.hioscar.com/careers/1173526
SQL is good enough for the existing set of applications, but that's not really saying much. There are lots of other applications for which SQL is not good enough, and those applications either don't exist because an affordable alternative doesn't exist or they implement their own proprietary database (e.g., many popular BI tools). It's safe to say that your use case--using SQL to perform one-off queries--is fine; writing a program that can dynamically build (performant) SQL to access data of arbitrary schema is quite a lot harder even if you can assume a single implementation. And much of this difficulty comes down to lack of composability.

Perhaps SQL is fine if it's your interface for accessing data on a one-off basis, but if you're trying to build a complex tool on top of it (say, an analysis tool for arbitrary data), the inconsistencies and performance concerns mount. People often end up inventing their own proprietary databases to do these analyses (e.g., virtually any business intelligence tool) assuming they can afford to do so. Perhaps EdgeQL isn't the ideal alternative, but as it is SQL is not good enough for many use cases.
You can tell but the point is you don't have to care.
It may replace C++, but it will take decades to do so. The C and C++ ecosystem is gigantic and has been around for 30 to 40 years and will will be around for the next 100 years or more years IMHO.
In the past there were no reports which lumped slot machines and PC/console gaming into the same bucket, it obviously just doesn't make sense. There has been a blurring between the two on mobile with many games which are mostly gambling without the cashing out.
Semi-related, but is there some friendly algorithm behind the scenes at HN that resubmits articles if they go flying off /newest without a lot of attention? I submitted a blog post last week that made it to the front page, but its path there was kind of odd. I had submitted it the night before and watched it scroll listlessly off the first page of /newest. The next morning, it was on the front page with a posted time of "5 hours ago", probably a good 8 hours after I originally posted it.
The open protocol could start small and gradually grow over time, maintaining backwards compatibility.

The incentives aren't there, of course.
This is blogspammed PR that gets it wrong. This is a research project that is nowhere near production with many "ifs". Vertical surfaces don't make a lot of sense for solar since they get limited exposure. They'd have to be incredibly cheap to make financial sense.

Research like this comes out every day. 90% of the time it's not possible to make it practical.
If the root cause drives half the price increase, and the speculation drives the other half, regulation to fight speculation can do a lot! You certainly do want to fight both. And if it's harder to speculate, that might also reduce the pushback toward increasing supply.
Freed by Isis Yazidi Mothers Face Wrenching Choice:Abandon Kids or Never Go Home
Er, it has only ~35% global support today. I'd hold off.
Yes, I am aware of the Linux emulation in FreeBSD and elsewhere.
I acknowledge the problems with SQL that the author stated, but I still prefer SQL over the alternative presented.

What would be other alternatives to a declarative language like SQL? Prolog?
There is! Humans find them and software reposts them. It's called the second-chance pool and is described at https://news.ycombinator.com/item?id=11662380 and various links back from there. There are so many good submissions that get overlooked by the randomness of the initial traction wave—especially the quieter, offbeat kind, which often are the best kind of submission for HN, uncorrelated with anything else. I sometimes email people to let them know their post will be re-upped, but it looks like I didn't do that in your case.

By the way, if anyone sees that kind of post languishing without attention, please let us know at hn@ycombinator.com. It's clear that many if not most are still getting missed, and curiosity is what we're optimizing for, so we love getting those emails. One day we're going to write software to make this system more formal and open it to everyone.
I doubt this will happen. For one thing, the dominant targets for Linux are servers and embedded systems - both of which are cases where resource overhead is pretty important. Running a Windows to run Linux inside of incurs a pretty substantial overhead, so I really can't see any case where developers would be willing (or even necessarily able) to spare the resources to install Windows on their formerly-Linux-only targets just to maintain the convenience of getting to develop for "Linux" on their Windows PCs.

And desktop apps developed for WSL will simply never be Linux-compatible out of the box at this rate, given that WSL does not contain any graphical or UI functions; MSFT has been pretty clear about this right from the start, and so I really can't see a scenario where people mistakenly believe just developing user-facing applications for WSL will make them "just work" on Linux, given that all the UI code is on the Windows side.
When we created an account, there was no such clause. We discovered that it was added later. When they pointed it out that it violates their policy, I found it surprising. At the very minimum, they should have allowed us to get permission and if denied, then at least return us 30% of our revenue at that time which was in the account. They did neither. They shut down the account and did not even answer back to our emails. I would never trust Paypal again after that bad experience.
You got me. I exaggerated. A large number of streetside trees in the downtown area have accident scars on them.
Whether he was supernatural or not, Jesus of Nazareth did launch a crucial institution which plays a huge role in our everyday lives.

Namely: the institution of "not following tyrants who proclaim themselves to be gods".

In Jesus's day, world leaders did proclaim themselves gods, and used sword and pen to enforce it. Praise Jesus that doesn't happen any more. The reason it doesn't happen any more is because no amount of gunpowder or brainwashing can sway a born-again Christian to bow down and worship a worldly king. Once Christianity spreads and takes root in an area, it becomes impossible for the rulers of that area to enforce their own godhood. Caesar can no longer make himself god when a sizable portion of the population believes the Gospel of Jesus.

The kingdom of heaven is near.
Tremendous.com is hiring its first engineer
Go is a terrible replacement for real time systems. While newer go has a much better garbage collector, it still isn't 100% deterministic. Most real time systems are written in C / C++ / Systems Verilog (FPGAs) / etc. I've once seen it written in a special java where the internal core sys (garbage collection) jars were overridden to disable gc entirely. Once the JIT was primed and ready to go this was exceptionally good and was fast as heck.

If go is killing anything, it is killing Ruby and it is seriously cutting into the server side stuff written in node. In my experience, Go is a nice fit right in the middle between C and Python. The best part of it is probably that the language spec is so short any developer can read it all and memorize it. As more and more stuff uses Go due to its overall simplicity and sensibility, some java stuff will suffer for sure.
Not just your (user X) data, but your friend's (user Y) data. What if the API had sent user Y a confirmation, like "User X just installed CAapp and wants to access your information. Allow or Deny?"
Java, Kotlin and Scala can all compile to Javascript and hence can run on the client and server as well. For example this is written in Scala.JS: https://scalafiddle.io

But that is irrelevant since enterprises don't care about SPAs and so are fine using standard web frameworks like Play, Dropwizard or Tomcat.
Why is it not a great replacement for Java? My experience have been opposite, C++ still have its place, but Go has taken over where previously maybe Java would be reached.
It's sort of like the mouse trap problem. Mouse traps and SQL are already incredibly simple and incredible effective, that's why you don't see a reinvented mouse trap at home depot and why SQL remains unseated despite many efforts to replace it.
> Caching?

That's the first step. If you have a 64kB cache, then you want to fill that cache ONCE, calculate everything you can with that 64kB chunk of data. Save off the result, and then load a new 64kB chunk. This is called "tiling".

Its actually kinda tricky to do just right, but once you know the concept, you basically spend effort ensuring that main-memory hits are minimized.

GPUs have many different memory regions: global Memory, L2, L1, "Shared" memory, and finally registers. Maximizing your math and minimizing your memory-moves is one big part of optimization.

-------

There are a ton of other optimization tricks: GPUs are more efficient if they access memory in certain ways. "Shared Memory" in GPUs are typically banked (on modern NVidia and AMD GPUs).

If you have 64-threads, it is more efficient if thread#0 accesses X+0. Thread#1 accesses X+1. Thread#2 accesses X+2. (etc. etc.) Thread#63 accesses X+63. In fact, a GPU can perform all 64-memory loads simultaneously.

However, if the 64-threads all access memory location X+4, you have a "bank conflict". The 64-threads can only read this memory location one-at-a-time, resulting in a massive slowdown.

There are a huge number of tricks in "tricking" the for loops to access memory optimally across your many, many threads that are calculating the multiplication.

--------

> Some kind of clever mathematical tricks?

The clever mathematical tricks have been solved and are known. LU decomposition, etc. etc. Its important to know them, but that's not generally what people mean by "optimization".
My experience is that same: asking for recommendations, alerting neighbors to car break-ins, coyotes, suspicious people on bikes at 3am peering into properties, yard/garage sales, free stuff and occasionally shaming people when they add descriptors to suspects as well as complaining about kids not respecting private property.
Repaer also works natively even on a Raspberry Pi.
Been using the KeePassXC[1] community fork for about three months now. The transition was smooth; it's pretty much identical to KeePass or KeePassX. Has TouchID integration for MBP which is super useful. Plus the source is available on Github and is actively maintained.

[1] https://keepassxc.org/
Nobody is gonna start torrenting spam web sites to access their useless content.
GIF is not very CPU-intensive, but I definitely remember systems slow enough that JPEGs loaded at visible speed over a couple of seconds. I also had a Libretto 30 that could play MP3s, but only with the Fraunhofer decoder and not the Winamp one which couldn't quite keep up with realtime.
Well let's get one thing straight, VP9 does not achieve 50% more compression compared to H.264... Second the demo videos were cherry picked to support their argument - using full motion panning...
> This sounds like early 20th century capitalism... I don't think it's very applicable to the current programming industry, where companies have to fight to retain good employees.

It absolutely does; just because capitalist are competing for labor doesn't mean that management switches from being agents of capital to agents of labor. Valuable, contested human resources are still resources, not owners.

> Also, the top-down structure is no longer preserved within the Agile's "self-organizing teams".

One of the most frequently reported problems with Agile in practice is that the idea of empowered, self-organizing teams is, even in organizations that give lip service to Agile development given limited, effect by management. In any case, that concept applies mainly to how teams deliver on business goals, not on setting business goals, so even ideally it would not prioritize staff opinions over business goals.
This is called a debit card in the US, and almost everyone has them - but the key distinction between a debit card and a credit card is that the debit card is a direct link to your bank.

People like using credit cards (or charge cards, like some Amexes) to buffer transactions between the bank and the merchant, so if the merchant screws up there is time to resolve the issue before the credit bill comes due.

If a merchant screws up with your debit card, or it gets skimmed/stolen, the only limit to abuse is how much money is in your checking account. If you just got a direct deposit from your employer and are expecting your rent payment to pull from that account today, but your account was drained because your debit card got skimmed at a gas station... not much you can do.
> This claim you've just made, however, is different and broader - and disclaimed in an article here

There are some numbers in there that I agree would be fair to use in favor of the EV, but on the whole this is cherrypicking in favor of the EV.

In particular, just because Tesla uses renewables (for which they likely got a nice tax break and/or subsidy) to produce some batteries, we should all be using their numbers to represent the CO2 emissions for batteries? First of all, Tesla may have the single biggest battery factory, but they're not the biggest producers, or at least they won't be:

https://www.handelsblatt.com/today/companies/catl-cars-germa...

The amount of cars they are able to produce is also very small, though in terms of demand for EVs, they certainly have a big market share. This is unlikely to stay true if EVs really go mainstream in Germany, because the EU will likely be favoring European carmakers with subsidies.

> I could get into a demonstrative calculation of how a solely coal-powered electric car is still better than the US-average ICE car in terms of CO2-per-km, but that's been done before

What does the "average ICE car" have to do with anything? EVs aren't "average cars" and even Diesels aren't "average cars" in the US. To quote that abstract:

"The calculated fuel-economy-equivalent values for individual countries vary greatly, depending on the mix of fuels used to generate electricity within each country. [...] The corresponding value for the United States is 55.4 MPGghg (4.2 L/100 km)"

You can certainly get a Diesel that beats 55MPG. It just won't be as fancy as a Tesla.
>> Python got to the top without a comparable corporate support from its creators.<<

Yeah, but Google did a lot for python adoption.
Who is making them? It seems they are making them in their factory, but is another company manufacturing them?
Mobile game companies will never do that, because while you and a hundred of your friends will give them $20 to own a genuine game, Whales will give them $1000 a month for their shiny skinner box
You can install native Linux on ALL Chromebooks. https://www.debian.org/
In EdgeQL, expressions are element-wise functions over the cross-product of the input sets:

edgedb> SELECT {'First', 'Second'} ++ '!';
{'First!', 'Second!'}

EdgeQL queries are essentially set comprehensions.
The Bora was good, we had one as well, sold it and bought a Civic that had its share of issues. However I would not buy a VW electric, not after Dieselgate. They're cheaters and cheaters need to be punushed.
SQLite is a wonderful tool for such a scenario.
I think you are referring to OpenSSL 1.1.1. OpenSSL 1.1.0 doesn't support TLS 1.3 (Debian Stretch ships with OpenSSL 1.1.0)
I as a consumer don't care if the comparison is apples to apples at a component level.

I am doing a high level comparison between laptop computers. One has been fast and reliable, the other has not. One was 10x more expensive than the other.

I don't care if the MBP had a quantum drive from the year 3000. If my user experience with it is worse than a Chromebook, I'm not buying another one.
It'd be awesome if nmap and other network tools work in WSL2.
So, to fix SQL, they're taking an SQL server and building a proprietary language on top of it.
OP has a point, though: at its core, advertising is the practice of getting as close as legally possible to lying (either by omission or straight-up nonsense) without actually doing it.
If only there were some kind of legislative organization elected to represent the people?
For those lower-income tax payers, is there really any reason to have an end-user initiated return?

With no itemized deductions and only wage income, the IRS already has everything that is needed. They should just mail/email a pre-filled form. If everything is correct, no action needed (other than paying any taxes due). If something is wrong, that bumps you into the existing "pay TurboTax" model.
I think it may be a stretch for a semi-technical user of keepass to realize that they have been pwned because they downloaded a client from keepass.com. They may think they were phished via email or some other avenue, so I don't think it's much of a guarantee that letting this happen would lead to users thinking 'Ah, that's what I get for trusting a tld! I'll be wiser next time.' I think it is more likely that an individual will react with 'ugh, hacked again, how did they guess my passwords!?'
It looks like this is built on top of Postgres, so they're already doing this.
> 1. Utility solar will always be cheaper then distributed solar.

Utilities are often privatized monopolies these days, that's not at all a safe assumption. Look what happened with California and Enron.

https://en.wikipedia.org/wiki/Enron#California's_deregulatio...
Even if this doesn't end up being practical, people should get to know about them, right?
Why would they actively disdain developers in creating novel tools that push the limit of their language in creative ways? Sure, there _is_ going to be a group of developers that are ignorant, arrogant and curious at the same time, but it is not the job of the programming language to reel-in those engineers versus the ones who create new frameworks and shape the development process.

Some tooling is not meant to be touched upon by engineers who aren't as experienced as the more senior developers who create those tools, and that's fine, eventually they will learn not only the limitations of the language but also how and when to push past those limitations by digging deeper into the langauge via compiler, reflection, unsafe code or more.

Many languages give engineers a way to write code without thinking of the more complex shenanigans going on behind the scenes, while at the same time exposing just enough of the core of the language to allow breakers to break past it's constraints, i.e. Javascript or C#. Not every language desires to be like C++ or C or Lisp.
My experience with Go is mostly limited to conducting interviews where the candidate uses it, but so much with it seems clumsy and inelegant. For example I was surprised how much is involved with a simple thing like sorting a list according to some custom comparison function. I guess once you learn the correct incantations for that you can just crank it out, as with any other language, but I wonder what it's like when you're trying to do something that's actually hard.
Because Hyper-V is a type 1 hypervisor, VMs that use it can be faster; I've found using docker in virtualbox is a lot slower than using docker for Windows (which uses Hyper-V).
If you are talking about real money loot crates/boxes/packages (as opposed to in game earned virtual currency) you are quite literally talking about gambling. In the case of some games, marketed directly to minors. I am about as free market solution as it gets, but I definitely draw the line at exploiting children (and defrauding their parents simultaneously)
I have no background in databases so this may be naive or wrong, but the single biggest pain point in SQL that comes to my mind is that it can be difficult to tell what a query is doing without also knowing the constraints on the tables involved. Here's a real-life (ish) example from work:

We have some_table which we want to join to other_table, but we need to map an identifier through mapping_table in order to do it. So we end up with a query like:

SELECT (...) FROM some_table INNER JOIN mapping_table ON (...) INNER JOIN other_table ON (...) ...;

I know for sure when writing this query that the middle join to mapping_table will map every some_table row to exactly one row (no more, no fewer) in mapping_table. The problem is that the query doesn't capture this. The mapping table isn't really named something as obvious as "mapping_table" so someone reading the query has a hard time inferring what the intent was. It totally changes how you mentally parse and think about the query if the result set can be accumulating multiple matching rows from the join, or maybe even losing rows if there are no matches. You have to go bring up your database schema to figure this out.

And, as a fan of static typing, I can't help but cringe at the possibility of someone changing the constraints on the table without realizing that there are queries which implicitly depend on the old ones. SQL offers no resilience to this and will happily change the meaning of your query without a peep of complaint if you drop that constraint from mapping_table.

If there's a fancy way to capture this "mapping" relationship in standard SQL that doesn't just use a dumb inner join, I'd love to know about it. If not, I'd love a query language that supports some annotations that help reading and are either stripped out before sending to the database engine, or are actually checked at runtime.
>>I can have 100+ GIFs playing at onee with no impact to my CPU
It wasn't that long ago that a page full of emoticons (animated gifs) would bring a computer to it's knees (when posting on vbulletin or something)
I don't think you can say this is a statement of fact. How are you measuring this?
They're saying that both of those expressions are valid, not equivalent.

SELECT count(star) FROM table

and

SELECT star FROM table

Are both valid, not equivalent.

Furthermore, listing any kind of set depends on some ordering, be it random.
Nextdoor is comedy gold - from people complaining about teenagers ringing their doorbell and running away, to reporting "suspicious black males", someone asking for free lemons. It's hilarious!
This sounds like fraud, but unless they get investigated and uncover a pattern of this behavior I'm sure it will be easy to dismiss it as a technical error.
Talking about coroutines, how do you do a synonym of async/await + Promise.all + cancellation token?

In a microservice world, I habe to send a request to 6 microservices and I want to do them concurrently not sequentially
Just to be clear, you quoted me enumerating a sequence of three things that together informed my judgement, yet you tried to refute my judgement by only responding to one of those things and thus mischaracterized my criticism in that process.

Also, I think indifference is a better accusation here than incompetence.

If I had to summarize my point of view across the various posts I've made here, it's that I think they are failing all the good folks who made the mistake of looking up Keepass after hearing that it would help them take an important step of cyber security in their life, getting fooled by an imposter, and getting pwned.