skysight-inc/HackerNews huggingface dataset:
>I'm pretty sure that the degree of normalization given in the end goes also well beyond 3rd-Normal-Form.

> I think that is 5th Normal Form/6th Normal Form or so, almost as extreme as you can get

The original schema is also in 5NF, unless there are constraints we aren't privy too.

5NF means you can't decompose a table into smaller tables without loss of information, unless each smaller table has a unique key in common with the original table (in formal terms, no non-trivial join dependencies except for those implied by the candidate key(s)).

The original table appears to meet this constraint: you could break it down into, e.g., four tables, one mapping the quad id to the IP address, one mapping it to the HELO string, etc. However, each of these would share a unique constraint with the original table, the quad id; hence the original table is in 5NF.

As for 6NF, I don't think the revised schema meets that: 6NF means you can't losslessly decompose the table at all. In the revised schema, the four tables mapping IP id to IP address etc. are in 6NF, but the table mapping quad id to a unique combination of IP id, HELO id, etc. is not: it could be decomposed into four tables similarly to how the original table could be.

(Interestingly, if the original table dropped the quad ID column and just relied on a composite primary key of IP address, HELO string, FROM address and TO address, it would be in 6NF.)
For what it's worth, Wikipedia has a page that will actually show you articles nearby: https://en.wikipedia.org/wiki/Special:Nearby

It's quite rudimentary and nowhere near as nice as this: just shows a simple, plain list. One nice thing is that it just resolves to coordinates, so if you happen to know coordinates of interest, you can just enter those: https://en.wikipedia.org/wiki/Special:Nearby#/coord/40.7128,...
Afterlife
but no walls, no personal space and not a moment to themselves outside of a stall in the toilet. it’s quite the hellhole.
When shit goes horribly wrong due to a system failure you’ll often find someone gets blamed and it’s usually the least politically influential and/or those with the deepest pockets.
It was a tragedy and good example of how the government will crush what it does not understand under a boot. Things haven't gotten better.
No permissions required to read motion data.

If I remember correctly, it might be necessary to declare the capability in a manifest, but there's certainly no prompt, nor a way to opt-out of an app reading motion data in the settings.
Just out of curiousity, have you tried things like game streaming? I've heard decent things for streaming games via Steam at least.
How would you do that remotely to evade identification and capture?

You could… attach it to a drone, I guess.
What was the last console you used? A PS2? These talking points would have been relevant 20 years ago, but they sadly aren’t the same ease of putting in your game and playing. Consoles are constantly updating their firmware, have annoyingly large mandatory game updates for online play, require you to pay for online (PS3 was a treasure, PC is usually free it isn’t monthly/yearly subscription unless you’re doing an MMO usually), and they’re basically just slower crappier PCs.
Whats the point of bringing up the most expensive GPU, is that what most gamers have? Most gamers on Steam have a varient of a 1050 or 1060, originally a $140, and a $250-$300 card from 2016. https://store.steampowered.com/hwsurvey/videocard/ You ignored PC exclusives too.
‘Dare in Reality’ Hackathon: Big Bounties at Stake
Here https://archive.ph/htHfA
Microservices and How to Analyse Them
> - Excessive Liquidity: There's money sloshing around the global economy looking for a place to go.

Here is an intuitive explanation: China runs an trade surplus vs USA. China gets USD and USA gets products. Because of the trade surplus there is no reason to invest into USA because as long as China is sending products to the US there is no reason to produce those products in the USA. Yields for conventional domestic industries drop as they move to China. The problem is quite obvious. If China spends its money on American capital it is inherently engaging in speculative investment. A basic understanding of economics tells you money should go where the highest yields are, in other words, the money should stay in China until their wages rise and they have no competitive edge.

Well, but the trade surplus is born from foreign exchange policy. So the money comes rushing into American stocks and housing regardless of the risks. It's plausible that Bitcoin is just being used to evade capital controls. The speculative nature of Bitcoin isn't a downside, it's actually a nice bonus to them.
WWI was caused by the anglos exploiting their colonial holdings so effectively they were existentially threatening the Germans. Etc.
To be fair, I think PC has probably more exclusive games than consoles by a very large margin. Not necessarily mainstream AAA games, but great ones nonetheless. It really depends on the types of games you play. Whether it is action adventures or games like Factorio, one system might be better suited for you or not.
Does a website also have access to the accelerometer data (via browser)?
He'd be disgusted at the censored echo chamber Reddit has become.
>but no walls, no desks to themselves and not a moment to themselves outside of a stall in the toilet.

all the perks of dorm room living! I guess someone really wanted that feature when they were first building the company.
"They were singing, bye-bye, Miss American Pie.."

[edited]

I can remember the day, reading about Aaron's death. And the following days, reading up about his life. The investigation by MIT to see if they played any role in it. Led by Hal Abelson. Above song was playing whilst I read this submission, so I posted it because it felt appropriate. But I should have added some context..
نبيل – درس حياتي
The east coast has been hit by floods as far back as both written, oral, and geological history tells us. In fact the army corp of engineers and predecessors have been building, dykes, dams, spillways, and sea walls all over the north east since colonial times. Saying this doesn't make me a climate denier. I'm just putting things in perspective. Each year the east coast of the US geologically moves in one fashion or another due to plate tectonics, ice age recessions, and erosion more than the forecasted sea level change (which by the way has been consistently wrong- over estimated for the last fifty years) Scientists need to better separate their hypothesizes from facts. The basic facts are that there is more damage because there are more people who want an ocean front view. Just compare ocean front pictures from the 18 hundreds to now. People are packed in like tuna in can. Of course there is more damage. That's because there are too many people.
I don't normally ask for references but for this one I would prefer to see them as I have run across plenty of studies on nih.gov on endocrine disruption from glyphosates and articles about lobbyists and roundup. One can find some of these studies with a quick google search. [1]

[1] - https://www.google.com/search?hl=en&source=hp&biw=&bih=&q=si...
The open source fdroid builds don't do that, instead they receive notifications another way, without google's push service.
> They wouldn't sell it unless they were absolutely sure it wouldn't be used against its own people

Why not? NSO Group is willing to sacrifice the lives of others for profit, so who’s to say that NSO Group would shy away from that?
PC games don’t need “cross play” FYI, you create a server and it is visible for anyone who purchased the game regardless of platform.

I haven’t used in game voice for more than a decade now. discord, teamspeak, steam chat, Xbox live all work well and are used by quite a lot of people.

Can’t comment on that single issue, but it does look like there was barely any information provided to repro the issue.
IIRC the rate was limited because someone showed it could be used as microphone.
The glaring problem (IMO) with throwing hard LC-style questions at interviewees, is that it's a fundamentally stressful and high-stakes situation - which is so far removed from the actual working environment.

What are you actually inferring from the situation - how well the candidate can write software? How well they tackle stress and anxiety? How much spare-time they have to grind these types of questions? etc.

Probably a mix of them all, but there's a lot of irrelevant noise - if you're just looking for one thing.
I'm not making any assertions, but don't you think there's some kind of selective process at work when you're breeding bees in an environment with fixed frames? Like, can they sustain a cluster over winter within the parameters?
I mentioned copyright because the gp mentioned it as a reason, but unless the rendetion is extremely abstract, i doubt it prevents propagating the image either, except in the most literal sense.
Next.js, Vercel, and Supabase :)
Not dirrctly in the article, but a key change within Intel after the 4004 was removing the mandate that all chips be a 16 pin DIP. This severely limited performance of the 4004 by not having enough lines to do data etc in one clock, instead having to shift register and serialize it.
Why not? A PS5 or whatever the current Xbox is have pretty much the same I/O as a SFF PC. Bunch of USB, HDMI, maybe DisplayPort (?), Ethernet. They have enough memory in this generation (16+ GB) to be quite useful machines. And they have GPUs which are roughly equal to a midrange card. The PS5 even has a standard M.2 slot. They're really just an SFF PC with heavily locked down software.
Well, paying more for the console may mean less money for games, or having wait may mean deciding on a different system or not having enough money may have the opposite effect of selling at a loss.
extradition treaties, international law enforcement treaties etc all undermine your premise
Aaaaand this is why now even "$20 gifts" have to pay import taxes at the EU entry customs.
> Pick up the controller, press a button, and off you go.

100% this.

It gets even better when you realise that modern consoles support sleep too. You can go from "off" to "exactly where you were last night" in a matter of seconds.
Ok, now actually read what you said.

If the price of stocks goes up without revenue going up that just means people value future consumption more and present consumption less. That has absolutely nothing to do with inflation. If anything, it's disinflationary.
How long will it take that all software is just as slow again and the fans are spinning constantly?
> But US interests align far more with Israel, or politically moderate countries like Jordan than some others in the region.

funny though that Saudi Arabia, which I would definitely not describe as "moderate", is also a very close US ally...
I realize they’ve spoiled the challenge, but Kid A was released over 20 years ago. It’s fine to ask for a spoiler alert, but you’re coming off kind of aggressive here IMO
How to Not COP It – Part 2: Home Energy
"You are bothering to do the interview because for one reason or another you're interested in the job."

I'm interested in learning how other companies do things, what technologies people are looking for in the industry, what sorts of questions are being asked in interviews, and what kind of problems people feel are in the domain of a particular job title. I'm also interested in compensation trends in the industry.

I can get all that information from a decent interview even if I walk away. Politely, of course! It's a matter of respect for each others' time.
The 3DS also happens to have perhaps the most fruitful console homebrew scene in recent memory, having full on all-versions unpatchable exploits that are very simple to perform. I wonder if that's in some part the reason that Nintendo has moved away from region locking, given how absolutely trivial it was to bypass it on the 3DS.
I literally said none of those things, or even suggested them, so now you're just making up arguments for the purpose of repeating the exact same flawed claim -- and yet, somehow I'm the one who can't entertain a possibility? You're honestly starting to sound like a troll now.

I never said a game couldn't be made better. All I did was point out that there is no singular "best" set of game mechanics, as you have repeatedly suggested. You're obsessed with using absolutes to describe behaviors the vary wildly, and insisting that's "how it has to be" and any other approach is somehow lesser than yours. But the only actual argument you've made so far is that you, personally, have discovered the absolute truths of the gaming universe, and anyone who doesn't agree with you simply doesn't understand game design.

So, it has nothing to do with your expertise, and everything to do with your insistence that you are THE expert of EVERYTHING gaming, and there is no room for any other opinion or development path.

Sorry to burst your bubble, but you're not the only person with experience in the gaming industry, and I don't actually know ANY developers who share your mentality toward game design.
That’s not the reason. The reason why people don’t delete is because nobody wants to be left with inconsistent data relations. Deleting a customer is more deleting their PII(our scrambling it) and leaving everything else in tact.

Or in the case of Silicon Valley, leave everything in tact with a disabled flag and then spam you for the next decade or so.
imho it is inevitable that Signal will eventually capitulate to law enforcement

Signal staff is hyper-woke, all it will take is a subpoena for some alt-right villain's data and Signal staff will be in a lather over the company's implicit support for "hate speech"
His death to this day frustrates me.

The world needs Aaron Swartz now more than ever.
And not a single evocative nor exclamation, commonly found in porn.

Nice. Clean. Fun? Profit!
How many games on console support splitscreen though?

And you can always run this the other way around: All modern games that run on console and PC support controllers on PC. It's games that are very old that sometimes need a manual intervention. BUT consoles can't even play those games at all, so they basically have no controller support too, just with zero recourse.
The worst thing someone can write in a company chat message is "Hi".

I write back "Hi", and then then I sit there waiting...
When I had US training in the 90s, stall and spin recovery were taught, but only stall was supposed to be practiced.

I was told that spin was not because it could damage some of the instruments which have gyros.

We did it anyway (in a Cessna 152), and it only took about 1.5 turns to recover. Great fun. Easiest way to induce a spin was flaps down during stall.
Sounds like it's just as well, the interview is a useful filter for you. Conversely, I like to work with companies tackling meaningful problems.

If I might ask, what do you do to excite your candidates about the challenges involved?
Another pretty big advantage of a console platform which isn't jailbroken (yet?) is far less cheating. Sure, you still got all your in-game exploits (some games don't have many, other games are riddled with game-breaking exploits), but you have to invest in a hardware cheat to get an aimbot or whatever on a console (one might argue that, depending on the game, you already get an aimbot out of the box anyway). Cheating in online PC games has become such a large problem that I'm wondering how much more the market will take.
Here I repost a composite of my old comments https://news.ycombinator.com/item?id=14542595 https://news.ycombinator.com/item?id=14546682 from a previous occasion when this was discussed https://news.ycombinator.com/item?id=14537650 . I confess to a certain amount of annoyance that the author of this document asked for feedback on this website, but after getting that feedback didn't (afaics) update the site to make any mention of Namesys or ReiserFS/Reiser4.

> Well, since you ask, here's Hans Reiser's old stuff:

https://reiser4.wiki.kernel.org/index.php/Future_Vision

https://reiser4.wiki.kernel.org/index.php/V4

(and http://lwn.net/2001/1108/a/reiser4-transaction.php3 )

. And here's some emails etc. I wrote in response:

https://web.archive.org/web/20040728044342/http://www.st-and...

https://marc.info/?l=linux-kernel&m=111624697710426

https://www.mail-archive.com/reiserfs-list@namesys.com/msg09...

https://www.mail-archive.com/reiserfs-list@namesys.com/msg20...

https://www.mail-archive.com/reiserfs-list@namesys.com/msg20...

https://www.mail-archive.com/reiserfs-list@namesys.com/msg20...

https://www.mail-archive.com/reiserfs-list@namesys.com/msg20...

, plus some of the discussion threaded from those posts. (Sorry, my stuff needs rewriting and updating but I'm not in the position to do it at present. If there's anything you would like to ask about please do. https://news.ycombinator.com/item?id=9809041 and https://news.ycombinator.com/item?id=10548477 touch on things that are a bit further down the line, but related—in particular, to the handling of "internal metadata" and files with a compound internal structure.)
> Now, if this social app is reading accelerometer data on your phone as well as the passenger’s phone, the app can easily figure out that both phones experience the same vibration pattern. ... Don’t be surprised if you receive a recommendation from the app to add this passenger as a friend.

Overall I find the article interesting but this quote is borderline tinfoily. Given the amount of noise in the accelerometer data and signal s much closer to the sensor than the bus itself - such as body movements, it would be hardly precise. Moreover the cost of doing all that research and computation as well as data transfer would hardly pay off.
If you squint a bit, it could be a castle.
Because if Israel loses a war they will use nukes. When they ask "please help us" we support them... because of the implication.
Doesn't mean there isn't an even better option out there :-)

Also I'd like to work on something related to tackling climate breakdown, so I'll almost always chat to companies in that space. Sadly I need to pay off some debt before I can take a paycut to work on these problems (or risk a startup).
This is a post on our experience getting a solar/storage system installed and some other measures. Again, it's not too technical so any questions please ask. For example, I haven't touched on the backup power option as the grid here is pretty reliable.
I do think the author still has misconceptions over how a database works, and I'm kind astonished.

No, your "poor" database system won't go through every row when you are querying a varchar column. As long as it is indexed, the database will perform a index scan of some sort. Assume O(logn) as the average complexity for most databases.

Of course, if the data on a column is repeated a lot, normalizing it would bring some advantages, but that would also include performing a join,which isn't cheap.

The key takeaway for me is: let's not let this Rachel person touch databases ever again.
I said this to recruiter at $currentjob and they pay me ~50% more than the last place.
Rust is more tricky, since it places emphasis on correctness and memory management.

Starting with go was far easier for me
Most fiat currencies are backed by the fact that people made themselves liable to accept that currency. It's a literal "I owe you". A restaurant owner promises to work to earn money, the bank gives the restaurant owner money via a loan. The money is spent on a bigger restaurant, the construction workers who built the restaurant get the money and they can then go to the restaurant and pay to eat there. They don't have to worry whether their shiny rock is currently worth something. The restaurant owner has a loan he wants to repay. He'll gladly take your money. At the end of the day it is just delayed barter.

Except, nothing forces people to spend their money so the barter transaction may never conclude which allows economic imbalances to build up over the short term which violentely resolve themselves through a crash. Inflation could be interpreted as a tiny crash every year that rebalances transactions made in the economy.
I've been trying to pick up a PS5 for a friend since they came out and it's been futile. I keep a watch on our local eBay and noticed there's one person who sometimes buys out all the available stock from the big electronics store, then puts them up for the MSRP. In the description they write something to the effect of "I am not making any money off of these - I just want to help people get a console for the price they normally sell for before all the scalpers buy them and mark the price up". I have no idea how they plan to prevent scalpers from buying those and charging 20% more... and also I wonder how the warranty will work since they obviously can't give you the original receipt.
I wonder, is it actually competition? Apple will never sell any of their Chips to OEM partners so they will have to make do with whatever AMD, Intel, nVidia, Qualcomm, etc. sell. Will it actually lead to more people choosing a MacBook than any other Laptop? With these prices I‘m not so sure.
Default permission for all apps to use accelerometer, recognizing sounds from the accelerometer? This would explain the situation when I talk about something nearby my iphone and then relevant ads appear in the internet browser on the device, or within local network.
Probably no effective ones, but you can packet sniff and look for traffic to known C2 servers.
Roles and Benefits for SBOM Across the Supply Chain (2019) [pdf]
is your screen a parchment tty? :-)
spoiler alert — the article poses a riddle/challenge to find the sample in question, be careful reading the HN discussion if you want to try for yourself
About number 1, most popular games by player numbers are PC exclusives, or not? LoL, Dota, CSGO(?), WoW, many MMOs, every older game that still runs on modern PCs, but not on new consoles.

2 I agree with. I'm hoping Steam Deck might make a big difference.

3 It's also gotten better in general, AND consoles seem to have more bugs than they used to, because things can just be patched now. Think Cyberpunk! Consoles are still better, I just think the difference is way smaller now.
All very good.

I have to admit that randomly browsing the stacks, flipping through the pages, has led to many serendipitous discoveries, that otherwise might not have occurred had I had to go through the trouble of requesting, waiting, and receiving books, subject to lending limits, etc. I miss doing that, actually. But at this point in my life, most public library stacks disappoint me, and the university library is an hour drive's away, though I do checkout books occasionally from it.
A totally valid point. It seems like the proposed ban is based on the fact that the computations costs a lot of energy, are “wasteful”, and only makes the miner in question happy. I don’t see how this differs from playing high-end computer games. Surely, you could argue that kids in the 70’s, only having access to board games, could get just as much enjoyment out of these as kids today get out of playing CoD, with the added benefit that you have to meet other people in person and that you’re not getting addicted to loot boxes. So, should we follow China in banning computer games?