skysight-inc/HackerNews huggingface dataset:
You would think that but having used both I find writing Kusto/KQL much smoother, neater and faster and if I have to choose between writing a query in either one I'd pick KQL.

I understand this is just an opinion but it's an opinion held by everyone in my org who writes both.

Theoretical correctness loses to pragmatism a lot and I'd read the KQL every day. Look at the examples at https://docs.microsoft.com/en-us/azure/data-explorer/kusto/q... - look at the examples at https://docs.microsoft.com/en-us/azure/data-explorer/write-q... and tell me they're not more readable than comparable SQL?

(I can see the result type both by hovering on the query but also by just looking at the end of it - and in SQL most of the SELECTed items in complex queries are from subqueries anyway - at least in my use case)
This is actually a fair point. Thus, this should limit Google’s escape intoany safe harbour. Though still leaves the problem who is going to go after Google for them locking users out from their own files.
I never did. Even for full-fledged web apps that may have legitimate use of notifications such as Discord or emails, I never accepted.
> Python has pyenv, NodeJS has nvm, Terraform has tfenv, and the list goes on.

Nix makes these all largely irrelevant, in a consistent way. If anything I would say this supports nix's usage.

> Then if you're running on a server/VM/cloud, it seems to me that you should be treating your systems as cattle instead of pets. I never update packages on servers, I build a new image/instance, test it, and replace the server.

You can do this is nix as well. You can take a configuration.nix and ship it as a version controlled file, an iso image, pxe boot image, ami, vhd, or other formats.

> I wonder if some of the benefits of NixOS were either solutions looking for problems or solutions where better solutions rose to prominence.

I don't think so:
https://blog.flyingcircus.io/2016/05/06/thoughts-on-systems-...

> I haven't even started talking about containerization, either!

Containers generally take an impure process and create a "snapshot-in-time". Nix allows you to "hydrate" your configuration in a reproducible and repeatable fashion. OCI images can only really be layered, can't be composed, and commands like `sudo apt-get install` or `pip install` also makes the runtime behavior dependent on when the image was created.
Does this still apply to people in power? As "don't piss off the king" seems like a very cross cultural concept.
what expressions are being repeated here?
> But in the time it takes to do all of that (usually distributed and interwoven into other activities) you could have been prototyping out your startup. That’s the value of cloud.

Honestly reinventing the wheel like that to cut costs points to a management/vision issue. The founders should simply raise more money. The cloud is an incredible value proposition when you understand the amount of momentum and time it affords to an organization.

And, for larger companies, it also bypasses internal IT when the team just needs resources right now to innovate.
During the earliest days of Guix certain relatively voluble community members had a tendency to create an impression that you -did- have to buy into the entire philosophy or you were actively unwelcome as a user.

Things seem to be much more sensible these days but it's worth bearing in mind that a bunch of people who tried to be early adopters will have come away with that impression and plan your evangelism for the current state of the project accordingly.
Mathematics and Mathematics Education in the 21st Century
I don't think there's an elementary proof, but you will see a proof if you study algebraic number theory.
Building packages from scratch for Debian can be a hairy endeavour, lots of tooling and it can be hard to know which one to use.

But building packages for Debian is dead simple, it is literally one command. Adding a patch to an existing package, and then rebuilding it, is a common operation.
DoE says they breakeven is 2.5 - 7 years. That's in the US, imagine how much of a slam dunk it is in countries with carbon prices and higher energy prices.

https://www.energy.gov/energysaver/drain-water-heat-recovery
In theory, this could be used to create AI agents that can process visual/audio information in a way that's more similar to humans. It could lead to household robots or advanced conversational interfaces. or whatever the hell the metaverse is.

It's just bunch of GPUs. It could be used for anything people can imagine, good or bad
CPI is a completely different measure that includes a lot more than currency value vs other currencies (usually the dollar).

I'm curious why you wouldn't compare it to the direct measure, which is the value of the Argentine Peso.

Because if El Salvador had bought Argentine Peso instead and let's assume they bought them in September, when they first started buying Bitcoin (if I assume they bought the Peso gradually over the past 4 months like they did Bitcoin the Peso would look better since its value has only dropped over that period), they would have bought $88mm USD of Peso on September 1 at a price of 97.71 Peso per dollar, giving them a 8.598 billion Peso holding.

At today's price of 104.50 Peso per USD, that holding would now be worth $82.28mm USD.

Compare that to their BTC holdings of $60mm spending the same amount of USD to buy Bitcoin. Clearly $82.28 > ~$60mm, so they would have done a lot better with the Argentine Peso instead.

Of course, BTC is highly volatile and for all you know it may rise by 50% making their holdings more valuable than the Peso. However, what it does show is that BTC appears to be a poor currency, that specifically does not protect from inflation or currency risks.

It might be a great investment, as a lot of people appear to be treating it, but that in fact makes it a poor currency. An investment should appreciate over time. Whereas a good currency should depreciate over time (although slowly) because if it appreciates over time then that greatly reduces the incentive to spend/invest the resources that currency represents in actual productive endeavors, which damages the real economy, and means a country does not build as much infrastructure, grow as much food, or employ as many people, as it would with a slowly but consistently depreciating currency.
> a bagel is a bagel

You trying to start a war between Montreal and New York?
Buying a house is, by far and away, the best thing I have ever done for my personal happiness and wellbeing. Have I constrained myself financially? Yes, sure. But every day I work in my garden, work in projects in my garage, take on home improvement projects etc. Despite the constraints, I have never felt more free. I would never, EVER go back to renting. Ever.
I think a key point is that traditional finance/banking has far more buffer and dampening built into the system than crypto. Crypto seems incredibly rigid and brittle - so it works well until it doesn't. Crypto seems to work well for people that know what they're doing but it's no surprise that the majority of people don't. Far from a new insight but worth pointing out.
> In 2022, we expect 46.1 gigawatts (GW) of new utility-scale electric generating capacity to be added to the U.S. power grid

This report only includes utility-scale generation, so rooftop solar is not included. Given that there's basically no micro-scale nuclear and coal, and very little wind, solar is under-counted in these types of energy assessments. (I personally know 1 person who gets all their electricity from their own wind turbine + batteries, and another who used to do the same but now has solar panels and batteries. So I know they're out there but there aren't many.)

I'd love to know how small-scale generators figure into the equation. And I'd love for small-scale wind power to see improvements and gain rapid deployment like solar. Currently almost all small-scale wind is off-grid and used with batteries.
I hit similar issues a while ago, and I think they have this figured out now. The installer Just Works (tested on a MBP2015) as of a few months ago.
I'm hosted on Digital Ocean, and the irony is, I'm literally mid-migration to Ghost from Wordpress — if this had happened a week later this wouldn't have happened.

I'm trying to figure out how to upgrade the droplet but being honest, my husband is the one who set all this up for me, so it's going to take me a minute to figure out how to add more bandwidth or whatever.
Still very glad I still use openRC
I wonder how people make money off of this (if they do)
You have to know that you can dispute the charge. Many people would not know that.
Why custom react hooks could destroy your app performance
Cloud drives are a cache. (Actually treat all storage as a cache, i.e. the data will be lost, it's just a matter of when.).
It doesn't need to be so life or death here. This is a privacy focused browser with the explicit message that it cuts out tracking, so the tracking without consent is pure hypocrisy.
> It's in the aggregate portion, like you said. Other example queries have a select portion. Why does it matter that it's not in the leading position like SQL?

I don't mind it not being in the leading position. The author provided a very simple query and in that case it's not immediately apparent what fields to expect the resultset to contain when returned to the consumer.

This is a troubleshooting issue more than anything else. IMO placing the "selected fields" into the very centre of the query is distracting and obfuscates what is happening.

> This is a proposal for a "transpiles to SQL" language. So long as that transpliation is predictable, you cannot run into the sort of issues you are describing.

I think a good test of whether any transpiled language works well is to look at whether it could work on its own as a language. See: Typescript.
> and thus have better immunity than that given by the vaccine

source?
Which itself requires hours of listening to alternative influences in order to develop, no? The pressure to conform within 2 sigma is strong in almost any society IMO.

What people don't seem to grasp is that most of the supposed alternatives to mainstream are pretty mainstream too or we wouldn't have stores like Hot Topic in the first place.
I'm glad if I can help! :)
> She's a constant source of embarrassment, but also entertainment, for the rest of the family.

For remodeling her kitchen?
running a wordpress is a noble endeavor but it isn't ideal for unexpected traffic hugs from a site like this.
And, further, the cartoon leaves out a big reason why you should get vaccinated: your chances of infection do go down, and your chances of hospitalization or death go way down. Of course, they then try to claim that isn't true, using a misleadingly-cropped chart that doesn't say what they claim it says.
You are welcome, I'm happy if it's useful!
On Linux, the last commit on it was about a decade ago.

On FreeBSD, the last commit on it was last week.

They're not the same tool, and FreeBSD didn't abandon their core tools, because they're part of the base system.
Spinning black holes may prefer to lean in sync
SELECT id, name, author

Quick, what is this query about? What's ironic is that I think you have it backwards: the columns are the implementation detail, not the table. The table is the context: you can't change that without having to change everything else. But columns are the last step, the selection after the filters, joins, etc. They can be changed at any time without affecting the logic.
English is my only proficient language and I still mix those up :)
> I do think people give the language itself to much grief when the problem is more the library side with the copious override shenanagins and other stuff.

I sympathize with this, honestly—the separation between Nix the language and Nixpkgs the library/codebase is just an implementation detail from the point of view of the user. This is especially true for core constructs like overrides—overriding is a pretty fundamental abstraction that would be part of a differently designed language, so the fact that it's more like a Nixpkgs convention is not going to be clear (or particularly useful) to somebody learning Nix.
What was your road into software engineering? I’m a lawyer now, and make pretty good money, but I can’t quit the thoughts of how much better legal tech could make it. So I’ve found myself interested in software but not wanting to drop my pay…at least for too long.
This reminds me of Jules Verne’s Mysterious Island, which was the first adult book I ever read. It featured a catastrophic underwater volcanic explosion. Great book, it’s a Robinson Crusoe-style sequel to Twenty Thousand Leagues Under the Sea.

Interestingly, Verne wrote the book nine years before the Krakatoa explosion. He must have been thinking of Tambora, though I’m not sure that eruption was well recognized at the time.
I don't think bombers typically fly around war zones with their ADS-B on :-)
> Why would anyone be OK with not getting paid their fair, and agreed, share?

Agreed? Surely their employment contract included this clause, wouldn't that be plainly illegal to do that otherwise?

> I don't understand why anyone would side with a trillion dollar corporation, instead of a worker,

Because not everyone chooses which side they are on first and comes up with the justification later.
I would happily buy an EV once the designs start to resemble more of ICE cars. I really don't like the aesthetics of most of the EVs on the road today. If say Volvo made their current V60 wagon with an electric motor option, I would jump on it.

I know Audi has the etron, Ford has electrified some of their vehicles, and GM/Chevy is starting to do this as well. I imagine I'm driving my last ICE car as of now...
Just call google support... oh... wait... right...

I wonder how many ads we need to watch before google implements something even remotely similar to user support? How many billions are enough before we get support?

I know I'm overreacting but I'm getting tired of these articles. We all know that google is messed up (to put it lightly). Some people here don't think that's the case and that's fine. Other people, including me, don't find it surprising at all.

Post something about google killing cute kittens.

I wouldn't be surprised but I would be interested in that story.
played maybe around 5% of it, I am mostly collecting them as modern gaming is rapidly becoming too unbearable for me(MTX, Lootboxes, the recent NFTs, etc), and I am most likely plan to just play the collection(which I collect with criteria of at least 1% of interest of playing ,so no baby games like Racing with Ryan etc) when I stop buying modern games
I miss the promise of WinFS
Ask HN: Now that SV is dying, where will the next generation of hackers hack?
It's a real motivator to leave Google and the MAG cloud in general. It has at least reminded me again to do regular Google takeouts.
I feel like FreeBSD lost a lot of momentum once a lot of the Apple contributors moved onto other companies...in contrast to linux which has (or had) several corporate contributors continuing to fund/drive open source commits.
Meat Made Us Human
Evolutionary Narrative Starts To Unravel
A really easy clue (as is the case on that site) is if the location of the eyes are aligned almost perfectly as if to the pixel.
Go look at the state populations in 1789. The small states and big states were roughly evenly divided between free states and slave states.

Anti-majoritarian structures have nothing to do with "white men." They exist in many countries, like Switzerland, where the voters are overwhelmingly white. Indeed, for most of the 20th century, the Electoral College benefitted Black people and immigrants, because rural states voted Democrat. The FDR coalition featured rural whites and minorities against affluent coastal elites.
Here's an archive link for now:

https://web.archive.org/web/20220124201438/https://eleanorko...
I'm also completely unfamiliar with the PRQL syntax, outside of right now.

Reading the comment however, it would seem that `let` adds columns which are implicitly returned in the order they are defined.

I do see benefits in this, and can imagine pitfalls. Hard to judge without kicking the tires.

Update: It's quite possible we saw different syntax!

https://news.ycombinator.com/item?id=30063266

Without the `let` I would imagine having trouble reading it as well, I'm not sure if that would go away with familiarity but my instinct is that it's a useful addition.
That got me thinking. I tested again on CheckTLS.com and if you use the port 465 and direct TLS, everything is fine. If you use port 587 and use STARTTLS, it's all good too.

Our decision was to not use STARTTLS for port 25, but that's maybe not a good idea and we should allow it back: this would make both services happier ;)

In a nutshell: TLS via 465 works correctly, and STARTTLS via 587 too.

Don't hesitate if you want to weight on this, happy to discuss this further!
Well the theory for the end-to-end image based self-driving models is that they are supposed to cover that.

The reasoning is that given enough training data the system would know the pedestrian is going to jump out or the cyclist is going to fall just based on sheer volume of training examples. It would have seen that scenario tons of times in the image data.

Whether that will actually work is the question though
"Best" is an opinion, not an absolute. "One size fits all" explains states that only one size is available. The marketing of this product is the equivalent of saying "we have shirts in sizes to fit everyone", and then turning away all the short people.

I had a court appearance last year that I needed to attend using software that "works on every device". Not linux. Not older macs. Not the older windows machines in all the small law offices.
I also saw a proposal for a better syntax for SQL, called BQL, that was a strict superset but allowed for better modularity

http://intelligiblebabble.com/a-better-query-language-bql-la...

It had this github repo https://github.com/lelandrichardson/BQL but never went anywhere

I hope PRQL has a better fate! unfortunately, by deviating from SQL lexical conventions (using :, using [], etc) we lose the ability to copy-paste from sql code elswhere.

I want a better SQL, but I also want some compatibility. Like typescript is for javascript.
I've used Gnome a lot in my past. Also KDE since the early betas. At some point I just found out how tiling wms are kind of nice. After that it's no going back. It's like learning vim and then trying to go back to an editor with no modal editing.

Like. I need my editor, a browser, a few chat apps, music and lots of terminals. And I've used this config since i3 already for maybe over a decade. Every damn keyboard shortcut has been there for a long time. It's kind of hard to learn out of that...
I am _literally_ mid-migration to Ghost because of how slow Wordpress is :( :( :(
I think you missed the key point. Software needs to be altered to run on Nix, and it needs to do so _systematically_.

Grab a script from the internet? Edit the shebang! Download some prebuilt software? Good luck finding /lib/ld-linux.so.2! Need to use some proprietary software you cannot edit? HALP!

Of course there must be some tooling to get around this, since stuff like steam is available (at least I hope), or else anything not packaged by nix would be a nightmare to install and use as a user. Any niche or domain specific software would become unusable. Take for example Quartus II or Vivado (just to name the two top FPGA EDAs), those two are not packaged by nix. Yes, there are a few recipes floating around, but those honestly scare me enough to not want to do it with more obscure tools like those for other, smaller brands, FPGAs.

(disclaimer: I never used nix, but that's my understanding from the article, and my own experience running proprietary stuff)
Is there some reason that a filesystem couldn't be written to permit multiple paths to the same file without the clunkiness of sym links?
Companies can say that they won't have an actual human look into your issues, but there's a person that handles letters that might turn into lawsuits and other legal issues, and you can always ensure that they get contacted instead. Certified mail is pretty quick to write and costs like $3 to send, and you can look up the company's agent for service of process.

It might not do anything - writing a letter that sufficiently implies that you are actually collecting documentation and preparing for a lawsuit is an actual skill, and your demands may be unreasonable for them to handle - but you will get an actual factual human being to at least start reading what you've written. And as a bonus, their KPI is in terms of "number of incidents per year" rather than "number of resolved tickets per day".
Manara (YC W21) hiring full-stack engineers and designer (remote)
To interpret a tool like prediction markets as you have, is it fair to say that you strongly believe in the divine right of kings?
How to Call Kubernetes API Using Go – Types and Common Machinery
What from the article makes you think that meditation is a bad thing?
Any idea if this will have a measurably effect on climate change?
Yeah... no. If your claim is that the code on your own device can just be inspected, then you can inspect what data leaves your device instead of assuming Mozilla hoovers up everything including your porn stash, credit cards and the weed hidden in your cd tray.
if you're expecting more bursty traffic coming your way from reddit or HN, it might be best to deploy a static site out to something like Vercel, GitHub Pages, Cloudflare Pages, Netlify, et cetera. it's not really as easy as running from a WordPress instance but it'll better handle these sort of events.

DigitalOcean's App Platform supports static sites too.
No, it's not a perfect example of better being the enemy of good enough. You're just missing the point. Nobody is using this as an interview question.
I like that everyone is trying to make something like SQL that reads more naturally to them. More alternatives is good! SQL is a widely accepted standard, and has strictly defined and super broadly accepted semantics.

As someone who has written quite a few half-baked-for-general-use but fit-for-purpose SQL generator utilities over the years, I'll suggest that if you intend for a novel syntax to be a general SQL replacement then being isomorphic to SQL would massively increase usefulness and uptake:

1. novel syntax to SQL; check! Now novel syntax works with all the databases!

2. any valid SQL to novel syntax; a bit harder, but I'd start by using a SQL parser like https://github.com/pganalyze/libpg_query and translating the resulting AST into the novel syntax.

3. novel syntax to SQL back to novel syntax is idempotent; a nice side effect is a validator/formatter for "novel syntax"

4. SQL to novel syntax back to SQL is idempotent; a nice side effect is a validator/formatter for SQL, which would be awesome. (See also https://go.dev/blog/gofmt, which is where I learned this "round trip as formatter" trick.)

I don't mean for this to sound negative, and I know that 2, 3, and 4 are kind of hard. Thank you for building prql!
The surviving NFT projects that will require no active maintenance in the next 10 years will be the ones who fully dedicated to on-chain only (cryptopunks, chainrunners, etc).

Unless there is an active community that maintains its strength during market cycles (like BAYC), current NFT project death will be 95% over the next 10 years, just like a start-up.
I still want a filesystem that can do both.

I want to have regular folders, and then folders that I can issue a SQL style query to generate their contents.

Take multimedia. With a traditional file system you can only have one type of sort. Typically by type (audio, video, image) and then alphabetically. It would often be nice to have a folder that is formed by querying the metadata, say all the items released in the 1950's, or all the items that are a low quality copy.