skysight-inc/HackerNews huggingface dataset:
NULL itself is open to interpretation.

If I CREATE TABLE foo (bar CHAR(1) PRIMARY KEY, baz char(1) UNIQUE), then different things happen on different databases.

In Microsoft SQL server, only one insert of a null into the baz column is allowed, and the null value is indexed.

In Oracle, null is never indexed in this context, so any number of null insertions into baz are allowed.

On a composite index, I believe that nulls are always indexed, on any database (they must be).

As far as I understand it, this is implementation-defined:

SQL> select * from dual where null=null;

no rows selected
What does it do? Does it let one pass a virtual GPU to the guest without complete PCI-passthrough? E.g. will I be able to share host GPU between the host system and guests?
Well, luckily we have another two major RDBMS that allow it.
Pop culture references != broader societal concerns.

Of all the places to draw conclusions about societal concerns from, mass-market consumer pop culture in a culture known for relative strictness on what is acceptable/taboo is the last place you should be looking.
Getting to 100% carbon-free generation is a goal of the President's Long Term Strategy [1]:

> DECARBONIZE ELECTRICITY. Electricity delivers
> diverse services to all sectors of the American
> economy. The transition to a clean electricity
> system has been accelerating in recent years—
> driven by plummeting costs for solar and wind
> technologies, federal and subnational policies,
> and consumer demand. Building on this success,
> the United States has set a goal of 100% clean
> electricity by 2035, a crucial foundation for net-zero
> emissions no later than 2050.

Other releases have set a goal of 2030 [2]:

> 100 percent carbon pollution-free electricity (CFE) by 2030, at least half of which will be locally supplied clean energy to meet 24/7 demand;

I don't agree with the rosy outlook of the previous commenter, though. Things are looking up, but I think it would be quite a stretch to hit this goal.

[1] https://www.whitehouse.gov/wp-content/uploads/2021/10/US-Lon...
[2] https://www.whitehouse.gov/briefing-room/statements-releases...
A lot of these replies certainly amaze me. The infrastructure for gasoline is under constant maintenance and construction: rail cars spill oil, trucks have to be driven by humans, pipelines take maintenance, gasoline has to be refined at a small number of places, gas pumps at stations have to be constantly inspected etc. etc. Electricity also has maintenance, but the grid already exists and will continue to, and access exists almost everywhere. High speed car chargers require a fair amount of investment, but for apartment dwellers etc. slower speed chargers where parking exists would be fairly easy to add. Cars are also interesting in that they store power in a battery, so can be charged whenever electricity is most available or cheapest.

I suppose there are people who regularly drive more than the long-range vehicles currently available, but last time I took a long road trip I rented a car instead of taking one of my ICE vehicles. For me the future is definitely electric, and I'll have a charger at my house, and probably solar.

The interesting point will be when gasoline is less available, as a kid I lived in BFE and my parents had like a 300 gallon gas tank they had to buy and maintain and get refilled from a tanker truck. Places where selling gas already has thin or negative margins will no doubt stop at some point, and ICE will become even more expensive in a lot of places.
Not sure how Ethereum does it, but on Tezos any node can submit proof another node has misbehaved and be awarded a certain amount of the misbehaving nodes deposit.

All of this works via code and no human intervention is needed.

I assume Ethereum has something similar, as there isn’t much gain in restricting those who are allowed to submit a proof that a node/validator is up to no good.
My employer can see the data patterns, and I'm struggling to understand why I should care. My media library is entirely legit (I have a crate of 100-disc spindles in the closet) and if they really want to know what movies and music I have, so what? They could see anything I do on Spotify or YouTube as easily, and seeing me stream a bunch of incoming data will throw off far fewer red flags than plugging in an external drive with media files.

If they asked, I'd show them exactly what's up. They haven't, so they don't seem to mind.

It's not full access to my network, it's access to a carefully curated set of media files transcoded through a service. There are no tax returns, no resumes, no porn. Just FLAC, MP3, and MKV.
What most commentators are missing here is that Snowflake had a significant revenue reduction when they improved the efficiency of their product, ie they could do more with less customer cost, less cpu use. This is similar to AWS lowering prices for many things steadily over time. Snowflake did this knowing that they would get less revenue, they would have less growth, and I suspect they also knew it would cause their stock price to go down. Here's an article on it from March, https://www.yahoo.com/now/snowflake-plunges-revenue-growth-o....

Certainly snowflake wants to make it easier for people to spend money and solve all their problems on that platform, every company wants that. But it's a very competitive world out there, and snowflake leaders aren't complete idiots - they have to keep lowering their prices when they can, otherwise new people will come along and do things cheaper.
On the basis of living in Manhattan and knowing a ton of people who have moved places over the last few years, including myself. Also, just go look at StreetEasy.
Not sure this is correct.

PoS issuance rewards are 4.6%/year, which can be offset with burn rate, but it is at 0.5% now.

The site projects that in 200 years, burn and issuance will be at equilibrium.
Why in every story about Apple are their contrarian head burying. No other company would get this amount of support for finally after 20 years allowing a supposed owner of the product to change the battery
I love two things about that site, after discovering it now:

- The fact that the ordering form does not compute the total price, and also asks you to manually keep track of adding $0.25/ea for orders under 100 pieces.

- That they practically bomb you with their phone number, which is also said to be the company president's number. That's very accessible, if you're into that kind of thing.
Nice of them to give you a ... planb ... ags.

I'll see myself out.
None one-thousand, one one-thousand, two etc

Doesnt sound half bad
> human-focused (1) approach.

TBH humans would have been better of if we were 0-based, it's just a convention. And we have the confusing language where "20th century" means 1900's. If we wanted to bring the 1-indexing we use in language to the fullest extent here to fix that particular issue, time counting would have to start at 1111. Except that won't work once reaching 5-digit years.

If we would start with "zeroeth" instead of "1st", then this would have solved itself and 20th century would mean 20xx's.
That comparison rings backwards to me? Pakistan is a deeply troubled, dangerous, and poorly run country. Korea is one of the best places to live on Earth.
Are you running the scripts in the optimizedSD folder instead of the scripts folder? For me a 512x512 image uses 3.7GB of VRAM. You can reduce the resolution to use less (to a point, the model needs a fixed amount).
Almost victims
TrustedLen will mean it can safely take the upper bound, but Vec for example will still use the lower bound of the hint when something isn't TrustedLen

https://doc.rust-lang.org/src/alloc/vec/spec_from_iter_neste...
If your VM provider issues IPv4 addresses you can run into another issue: your v4 address might be dirty. I recently spun up a development VM and was unable to download packages from maven.org. Apparently the address had previously been used for abuse and ended up on a blocklist.
I always thought of the machine focus being that the location of the first element was the location of the array plus zero.
> College students have been begging for loan forgiveness for a decade. It is quite literally a handout.

I guess it depends how you define "handout". Usually that term connotes something undeserved, which is where I disagree with you.

> Admittedly I am quite upset because I sacrificed years of my life and potential income to do the responsible thing and pay off my loans. This is the ultimate slight at me, and everyone like me, because with this $10k-$20k there is no punishment.

Imagine if a parent said "I grew up poor and starving, so I'd be quite upset if my children had enough food to eat." That's basically what you're doing: you were punished by a broken system, and now you are mad if other people aren't punished the way you are. That's just selfish and petty.

> It is quite literally, by definition, another example of helicopter money to people who made a choice and now don't even have to live with it.

You're describing this "choice" in a way that seems to imply all choices are equal. That anyone can choose to go to college or not and have the same outcomes in life, that there's no benefit in choosing one path over another, that there aren't other factors influencing such a decision or the availability of these decisions in the first place, etc. "Don't even have to live with it" -- do you realize that sounds like you're implying lifelong debt is a punishment for education? Something that must be "lived with" if you get said education?

> There is not a single skill I have learned applicable to any job I've held in the last decade.

Why is that your metric? More importantly, if that is your metric, why did you spend 3x the usual amount of time at university if you weren't getting anything out of it?

> We should not punish the people who chose not to go to college in order to "help" the people who chose to go into absurd levels of debt for a credential. Fix the system that is convincing people that this is the only way. 300B dollars is a lot of money to look to stylish.

You're not being punished. Your debt would be the same with or without this policy. The cost to the average taxpayer is less than the cost of tuition at a public college. So guess what? If this policy paves the way for future similar policies that apply to new loans, you too can get free college education and make that tax money work for you, if you can't bear to let it work only for others.

It's not about "looking stylish". It's about the importance of education and acting as a proof of concept that it's feasible to make said education accessible to everyone.
From : dang 21 hours ago : https://news.ycombinator.com/item?id=32571890

>I'm sorry, because I realize this is well-intentioned, but we don't allow bots to post to HN so I have to ban this account.

The reason we don't allow bots is that we're trying to optimize for curious conversation, and that requires human beings taking a personal interest in a topic and/or each other.
Ok, gotcha, just some insecure MAGA crap.
Your not only one, but we (society) have ruined far prettier landscapes for far less tangible economic benefits.

Hardly _any_ prairie ecosystems exist in NA, and we pretty much built a dam on every river with a pulse, ruining countless landscapes.
Search / Download Millions PDF Manuals
The place to search any User Manual of many categories product: Electronic, Dryer, Cooker, Hardware...
Here's also more discussion on Simula's price: https://news.ycombinator.com/item?id=29923197
Oh we've tried both and the bicycle cargo is much nicer for most activities, especially the bakfiets ones. We've tried lots of tricycles and I feel they're deathtraps, if you usually drive a bicycle. You need to really steer and when at >20kph, steering without banking, keeping 3 wheels on the ground is very hard, I find. Maybe lack of practice. But in a month of driving a tricycle, getting back to a bicycle cargo was really a contrast.

The only thing I'm missing really from tricycles is the canopy, the roof, some of those have. I haven't seen a bakfiets cover high enough for tall-but-young kids, and it's really annoying to resort to ponchos or other garments to keep water away... I'm almost in the mind of building one, if only I was a better woodworker...

Buying my second bakfiets short in 2 days, couldn't be happier to fork the cash over...
More like a touch pad on the screen
I'll bet you anything that form just sends an email to the president who then prints it out and fills out the order details.

It's probably much easier for them if you call, and once your setup you just call and ask for a refill.
Do you work in Ada/SPARK professionally? Curious what industry if so.
Would a dumb mobile phone suffice? Or do they need you answering email while you commute?
Why don't we promote more single-use aluminum containers? Are aluminum cans considered a success in terms of recycling and not going into the landfill? Why don't we have aluminum yogurt containers, aluminum milk cartons, etc? Has the 5-cent deposit program by some states been a success? If so, this seems like a good solution for more products than just beverages.

Aluminum seems like a really cool material for packaging. One obvious downside though is that aluminum is not clear.
For some of us, a lot, but at the end of the day... it's paid for and ours in perpetuity. The will and greed of adversarial publishers means nothing to us. Can you say that about the cloud?

Now that I think about it... I've probably spent less on my physical media than you've paid in subscription fees, in total.

And again, I can do what I want with it.
Absolutely, he deserves a lot of respect and study. I find him to be one of the funniest poets ever. The unedited version of "An Anagram" [0] is one of the greatest and silliest put-downs recorded in English.

0 - http://www.online-literature.com/forums/showthread.php?18947... (two of the last four lines are removed in many online versions)
Creative List Styling
> human-focused (1) approach.

TBH humans would have been better of if we were 0-based, it's just a convention. And we have the confusing language where "20th century" means 1900's. If we wanted to bring the 1-indexing we use in language to the fullest extent here to fix that particular issue, time counting would have to start at 1111. Except that won't work once reaching 5-digit years.

If we would start with "zeroeth" instead of "1st", then this would have solved itself and 20th century would mean 20xx's.

I especially don't understand why mathematicians use 1-based indexing (for matrix rows/columns etc...). Like programmers, they should see the advantages of starting at 0 (e.g. the coordinates of subdividing into block matrices are simpler if starting at 0). Mathematicians do start at 0 for the origin of plots, after all.
I agree with the point of your post, however I question whether streaming's utopian moment even actually happened. I was a very early adopter of Netflix streaming and their catalog was quite poor for a long time. Just tons of cheap no name filler content, old public domain type stuff, and a surprising amount of softcore pornography. There were high profile movies and shows sometimes too, but they were the exception and even back then they would get removed regularly. Today's streaming landscape, greedy as it may be, at least offers the ability to stream premium content that Netflix never would have had even in their days of solo dominance. Perhaps the streaming golden age is closer to something that could have been, rather than something that actually was.
> a simple test here is do I put off video games to work on my own projects, the answer is yes, even though I in the immediacy maybe more intensely desire to play video games

I’m not sure how this contradicts my prioritizing comment. When you do put off video games, you are not changing the order of your desires, you are revealing how they are already ordered.
What's with so many SQLite posts on HN these days? Never saw so much love for sqlite before.
It’s always been like that. Bring your macbook to an Apple store for a battery replacement and they will replace the top case.
I don't believe there's anything OS specific for it, just most guides are for Windows for simplicity.

However it does require a nvidia gpu and Macs are generally AMD or integrated gpus.
the way agencies like the CIA use the term metadata, it is very much inferior to full "data". metadata is just the record of the time, date, parties,... of a phone call, without the voice record of the call. the latter would arguably make for a much better source of information (because you'd know what was actually said, could match the voices,...).
Not on many instruction architectures - addressing modes often support adding/subtracting a constant.
> HTML vs plain text is a distraction; it's not the 1970's anymore and saving a byte or two here and there just isn't the computing world we're living in. Not when images, video, or audio files regularly get attached to email.

It's not about HTML vs plain text. It's about HTML vs a way to style text which is actually useful to the users. HTML is so bad for this purpose, in practice 99% of HTML mails don't use any tags in their proper content and mails which could use some styling to make them more readable are using plain text, because HTML is of no help to them. My remark about overhead was actually about the quotes, whose sizes grow linearly as threads get longer (and the threads grow quadratically instead of linearly), not about HTML. You don't pay for tags you do not use (almost). The only rich HTML mails (as opposed to plain text HTML mails) I get are marketing mails, which want to track me and "stand out from the crowd", neither of which I have an interest in, and HR mails.

> What's more, how do you loop someone into a conversation they weren't previously a part of, if you don't have the history of the thread in each mail? This is something Slack gets right

Slack doesn't get it right. When you join a conversation, you always see the whole history. But in practice people conduct conversations according to the assumption of who is taking part in them at a given moment. They can't predict the future and that someone will add another person to the conversation, and now this person will see everything they wrote. There is no way to add them to the conversation with a context of "the last n messages" e.g. In an ideal mail client you would select which messages from the thread you want to share with the newly-added conversation participant.
No; if it's not in the core, that means we don't want to bloat the code base. Caddy is extensible for very good reasons!
You have definitely seen cyclists following the rules, you just don't notice them.

The "rules of the road" were made for cars, not bikes. Bikes are inherently different and should have different rules. Cars and bikes should not be riding side by side in cities.
> Was C ever much more than a veneer on top of assembler?

Maybe in the very early days, but that necessarily had to end as soon as compilers started doing non-trivial optimizations. Today, C is very far from being "portable assembly".
Articles like these make me glad to live in the Netherlands. Here we had "stop de kindermoord" which translates to "stop murdering children" which was aimed at the higher incidence rate of accidents due to motor vehicles. in the abstract they talk about vehicle type, race and other factors while I dont see the real killer anywhere in the abstract or introduction; Speed. Way back during the protest we subsequently figured out how to incorporate cars into cities without accidents.

1) In pedestrian and cycle heavy streets, you reduce the speed to a maximum of 30kmh (~20mph) and sometimes to 10 near schools and residential area's

2) traffic seperation. to improve traffic flow, the dutch governement made sure to always seperate traffic from destinations and only intersect pedestrians and cyclists in the last mile in a 30kmph area.

3) Careful road design. Its really uncomfortable to drive above the speed limit because they narrow roads, add trees, obstacles and turns that are perfectly safe at 30kmph that make driving only safe at the apropriate speeds. adding trees next to roads also increases safety for pedestrians as an offroad car is bound to hit a tree instead of a person.

4) great investment in public transport and highways. Despite everything someone might tell you, the Netherlands is a great country to drive in with the most ridiculous infrastructure to keep traffic flowing.

5) accident investigations. There's safety focused public design. We blame the road for an accident rather than a driver. Because even if someone was wasted drunk, an accident could have killed an innocent person. Therefore the road design can be changed so that even an imcompetent or drunk driver wont harm someone. Also, everyone in a car has the legal responsibility to drive safe when encountering pedestrians because as a heavy vehicle, the onus is on you to not cause damage. even if some cyclist ran a red light. You should have been able to stop.

look up strongtowns for better accessibility for non-dutch speakers.
Yes, one or two years of well taught judo intro are also a lot of help in learning to 'fall'.
> This is for example how CPUs and GPUs are sold, and many other products.

What on earth kind of CPU or GPU have you bought where basic features require a reoccurring subscription?!
> when we count, we start at 1

If I ask you to count the number of red balls in a bag with only 3 yellow balls, then the initial count in your head is 0, you inspect the balls one by one, never encountering a red ball, and thus never incrementing the count.
And then you pronounce your final count of 0.
So that's counting starting from 0.

What you call "starting at 1" is not so much the start as it is the first increment, which need not arise.
32 Ether or mining equipment is nothing compared to what you need to have any real influence over fiat money.
And so is ETH going through Tornado Cash, but that didn't prevent Tornado Cash from being sanctioned
Even with this development in recycling, Styrofoam should just be banned for packaging. Aside from disposal, it's very brittle and you end up opening a box only to find smashed up Styrofoam that now escapes all over the house/outside/car which is nearly impossible to clean up adding yet more micro plastics to the environment.

There's nothing wrong with using formed cardboard packing instead of styrofoam and it can be recycled again, or at least if it ends up in a landfill, it'll biodegrade instead of still being there at the eventual heat death of the universe.
Obviously I was being hyperbolic, which is partly why I emphasized it. Though this list doesn't actually read to me as being anything more than "monetizing everything they can even remotely related credit ratings". It's not really a different "product" selling credit ratings for their intended purpose to banks and selling them to non-bank businesses for looser moral purposes, is it?
Friendly fire is by definition an accident. Killing this citizen was intentional. I feel it's odd to allow them to be conflated.
I remember reading quite a few years ago about an auction process that turned things upside down. Each buyer had a push button, and there was a display at the front that showed a price going from high to low (the opposite of the usual auction where the bidders drive the price up). The auction starts with the price up high, and the displayed price goes down relatively quickly. When one of the buyers pushes their button they win the auction at the price shown on the display at the time the button was pressed. If a buyer presses the button too soon, they may be paying a higher price. If a buyer waits too long another buyer will win the auction.

This process is used for items that are relatively high volume and low cost. The example I saw was for flowers; growers selling to flower shop owners. This process makes it possible to move a lot of product from seller to buyer very quickly.