skysight-inc/HackerNews huggingface dataset:
Jupyter would be even better if it supported the seamless combination of Python and SQL code cells.

My notebook code typically involves a data prep stage with querying a SQL database, then downloading into Python for more complex analysis, ML modelling, integration with external data sources, etc. So the notebook has a Python kernel with SQL usually as embedded """-quoted strings.

Does anyone have a solution to treating selected code cells as SQL - with SQL highlighting and tooltips - exposed as string variables to the Python code?

Sparkmagic [1] does part of this for Python/SQL/Spark interoperability, but as far as I recall, doesn't support SQL syntax highlighting.

[1] https://github.com/jupyter-incubator/sparkmagic
Are you trusting open source blindly? Then you're in for a world of hurt
LOL I like how you tried to mislead everyone by just putting Prost's stats alone. Then you argue it wasn't constantly. If your driver was better head to head you wouldn't have to do that. Long live Senna and his flame to win.
As expected, the headline did not stand up to the body of the article itself before turning into a marketing gig for a company developing drugs targeted to never-smokers suffering lung cancer.

"To a great extent, this is a function of straightforward math, said epidemiologist Ahmedin Jemal of the American Cancer Society. Fewer people smoke today than in previous decades — 15% in 2015, 25% in 1995, 30% in 1985, 42% in 1965. Simply because there are fewer smokers in the population, out of every 100 lung cancer patients, fewer will therefore be smokers. And that means more of them will be never-smokers.

There are also hints that the absolute incidence of lung cancer in never-smokers has been rising, said oncologist John Heymach of MD Anderson Cancer Center. Some data say it has, but other data say no. The stumbling block is that old datasets often don’t indicate a lung cancer patient’s smoking status, Heymach said, making it impossible to calculate what percent of never-smokers in past decades developed lung cancer."
Human beings are adaptable and they may well adapt themselves to the algocracy, just like they adapted to dozens of different social systems before.

It is a bit dystopian, but you can already see some of the adaptations, such as the very existence of SEO and its significant use by businesses.
There's a (fresh) extensive comment right above mine which explains the 4 different use cases for dates and the very minimal real need of TZ, let's all read it. Sorry I cannot comment otherwise your arguments because you didn't offer any.
Show HN: Meething-Mesh dark mode support - Free personalized video meetings
That's probably the best part of Windows.
TextAdept was my go-to for that.
How to Keep Time
Can't have been that hard if half an engineer was enough to do the job.
I agree that this is a problem, and it could be solved by a legal requirement - spreading of the material is illegal if it is done for degrading the subject of police action, and "traffickers" (i.e. "laugh of the day" video aggregators) are held liable for redistributing such content.
> since almost everyone is using AdSense it doesn't make much difference to them

You’ve hit on the actual problem. This is why so many believe the real fundamental problems the culture is facing with tech companies start with antitrust enforcement.
See also various beacons spread around the globe so people can measure propagation:

* https://www.ncdxf.org/beacon/

* https://en.wikipedia.org/wiki/International_Beacon_Project

The one in Eureka, Nunavut is quite the location.
BoA had it happen a couple of times after they screwed over home owners and tried to ignore the courts. It seems like there should be a significant consequence to forcing the aggrieved party to form a posse with the sheriff in order to collect the local branch's office furniture.

https://web.archive.org/web/20111210150756/http://www.naples...
So i guess "paying more attention" to flawed thinking is not part of the "smart" equation? See where this leads? I'll be direct: the concept of "smart" is vague and has different meanings to different people, and different measures, so to say "smart" people are like this or like that doesn't make sense.
> Now guess what, while currently being in lockdown, the possibility for an Elfstedentocht is increasing since it's pretty cold to our standards right now.

It's increased above the 0% it is when the temperature is above freezing, but there has never been any realistic scenario for there to be enough ice to hold it this year: significant parts of the route didn't yet have any ice yesterday. The weather predictions currently also predict increasing temperatures.
Why not add a government body that, upon submission, starts a fine ticker that forces any company to reply after a set period of time.

If no human reply is given, it starts to exponentially pile up the fine, until the issue is solved.

They shouldn't be able to allow people to make their livelihoods on their platforms and suddenly cut them off without even giving proper support. They should pay for this - innocent people go through an immense amount of stress and get stripped off their money and the product of their work.

If the answer is: "they're too big to have humans manage this", then you know what the reply is - cut them into pieces, half, fourths, who cares. Slap a user account cap on that shit with a number that a human workforce can handle.

I feel no sympathy for growth problems of this massive companies. I really hope European Union starts to crack on this shit, and hard.
Great. I just hope we won't have to wait 30 more years for immutable (single-assign) values to arrive.
This article is genuinely difficult to read due to the lack of capital letters. It shows a lack of consideration for the reader.
And if the timezone changes, should the meeting you booked at 9 AM now happen at 8 AM?
There's a similar-ish precedent: in my city, OsmAnd can display whether streets have proper lighting. Though I guess that doesn't change as often as asphalt—but then again, I can only envy people if potholes are fixed too fast for them.
The man could switch to any other ISP but choses to spend $10k on this. Insanity
Funny that you mention Maven, because Maven is not really vulnerable to this kind of attack simply because it requires a groupId in all dependencies, and to publish under a certain groupId you must prove control of the domain it refers to, which makes this attack nearly impossible (it's only possible if you use an internal groupId which is not controlled by you on Maven Central, AND an attacker could claim that groupId successfully with Sonatype, AND you configure Maven to first look at Maven Central, and only then at your internal repos which would be stupid to do as you normally do the exact opposite - and most enterprise setups won't even proxy to Maven Central at all).

Also, Maven uses pinned versions, normally, and won't just download whatever newer minor version happens to be published when it builds, which again makes this attack quite hard to pull off.
I just use VSCode over ssh for everything outside my local host. The support in Code for ssh is awesome and maintained by Microsoft AFAIK.
The article concludes with:

"Compared with other causes of premature death, air pollution kills 19 times more people each year than malaria, nine times more than HIV/AIDS, and three times more than alcohol.

Coronary heart disease and stroke account for almost half of those deaths, with lung diseases and other non-communicable diseases such as diabetes and high blood pressure making up most of the rest. "
What does the url model bring?

Packages are typically considered immutable once published. If I have a particular package e.g. "FooLib.Bar v 1.2.3" then this zip file should _always_ contain the same bits. If I need to change those bits, e.g. to fix a bug then I need to ship e.g. "FooLib.Bar v 1.2.4"

Also packages aren't always small. So it makes sense to cache a copy locally. On dev machine "package cache" and in an org's "internal feed" and only check upstream if it's not there.

So I shouldn't need to go to the source url to get it. Ideally, I just ask "who has "FooLib.Bar v 1.2.3" for me?"

It also means that tampering can be detected with a hash.

But the "check upstream" model is now vulnerable to fake new versions.
> The days of firing off an email from any ol' SMTP server are completely gone.

I'm not sure... I agree with the general vibe in this thread however my experience (within the last year) is that you can fire up a fresh one and send email to gmail at least, without SPF, DKIM or DMARC.

However as soon as you start doing any mass mailing of any kind you need all three of those things, SPF to not get outright blocked and get into the spam, and the other two to have their spam detection filters to even bother parsing your email content for the chance of getting into the inbox.

This is my experience from setting up systems that send automated status emails not marketing, so fairly low volume but frequent enough with same message content to be immediately classified as mass emailing.
> Why would every website's business model be based on ads and tracking?

Certainly there are for-pay services as well, but the absolute vast majority of people prefer to pay with their privacy than with their cash, to the point where starting a for-pay service of that type today without a known brand name behind it is not going to pay your hosting bills let alone put food on your table.
According to Wikipedia there are more than one overlappings: https://en.wikipedia.org/wiki/List_of_time_zone_abbreviation...
This looks like a cloud dashboard for https://pypi.org/project/speedtest-cli/ it's far from a legal botnet since it still needs to run on your devices.
They are different things.

You store your datetimes/instants as UTC, you store your "every day at 9 CST" rule separate from that.

Your rule table might have a column for a cron expression, and a column for the tz database name.

Meanwhile, your table for the meeting records has the time represented as a UTC timestamp.
Jimson weed is so common they could never ban it and the effects are so bad I'd hope you never take it.
I've never understood how virus scanners don't trigger those click to do something emails ...
> Google will be sent all of my browsing history

No, the browser locally determines what cohort to assign you to (based on your browsing behavior, etc). Only the resulting cohort gets exposed to Google (or other advertisers).

So they don't get your browsing history, they get the derived conclusion that you're one of X thousand people who share a certain collection of interests.

(You may still be unhappy about that, but it's certainly not the same as exposing your browsing history.)
What if you're scheduling a meeting for multiple people, and normally you're in Seattle, but for some of these meetings you'll be in New York? You don't want the meeting to be at 8:00 your time because chances are the people in Seattle aren't going to join your call at 5:00 their time.
This is true when you get to smaller tractor classes, but when you get up to the big specialized tractors like combines, Kubota and the others just really are not in the game in the US, it's dominated by a few players and they all have closed proprietary systems. Caterpillar and a few other players do this is the specialized heavy equipment game, it's pretty much the same playbook.

As well their really is no comparison, to JD's high end fleet tractors to the ones they sell to compete with New Holland or Kubota, they are different lines with different quality controls. It gets even worse when you get down to personal lawn tractors. They are basically just rebadging commodity built hardware at that level.
A lot of the free and open Internet arguments were about copyright and open source, both of which turn out to be almost irrelevant in the face of automated Kafka-esque monopolistic bureaucracies.

Turns out being able to pirate MP3s is a poor consolation prize when you can have your startup permabanned from AdSense or Amazon for no good reason, and there's nothing you can do about it.

Wrong goal on the wrong sports field.
This is the AI tyranny they warned you about. Let's say the future is fully automated AI locking you out of things for social credit score violations. There's no due process or appeals, there's no one working in customer service. They don't really care about you individually because you're just taking up space and not generating much revenue anyway.

One of the problems with very large corporations like Google is the marginal benefit of each additional customer is negligible. They have so much money that they don't really need extra business and would rather pursue other objectives. Look at all the stuff getting cancelled lately for whatever reason. The whole thing takes place extra-judicially and is not in the monetary interest of these companies. Stakeholder capitalism if you will. I think the old profit driven system was better because at least you knew what the rules were. Now, the way these big companies make decisions is largely opaque and based on secret rules and arbitrary decisions often based on nothing but whim, or worse, a "good enough" algorithm.
Oh, I'll really show my ignorance here. You're right. I was interpreting Nix as *nix, and your average enterprise distro of linux.
If I'm programming I'll use a graphical IDE, preferably something by Jetbrains or at a push VS Code.

If I'm logging onto a server to change something small I'll use nano. I don't have any reason to learn vi or emacs.

I never have to do anything that requires me to need anything more than nano. If there ever is that requirement then it's gonna be hosted somewhere else and deployed to the server anyway, so I'll edit it on my machine in my ideal IDE.
Wow, fascinating to learn
Remote multisig theft attack on the Coldcard hardware wallet
In Dutch that word would be "automatisme": a habit so ingrained in your mechanical memory that it doesn't require conscious thought.

Thinking about it, wouldn't the word "habit" cover it in English? It makes me smile to realize that our habits are so ingrained, we don't even realize we have a word for it :)
Hi

So it's basically a small docker container that you install on your computer and it would do a test every hour.

The dashboard is web based so you can check your results from anywhere.
Another reason not to use EST/EDT is that they are overspecifying the time zone in most cases. If you ask for output in EDT, but the date is in December (which is not part of daylight savings time) then should the date output be UTC-4 or UTC-5? Technically you asked for EDT.

Using EST as a shortcut isn’t a good idea, either - most software will “know what you mean” and use EST or EDT appropriately... except, both The USA and Canada have been toying with the idea of dropping daylight savings time, so it’s very possible at some point in the future that 6:00pm on July 1st will be EDT in America/New York, but EST in America/Montreal (or vice versa). This is already true for CST - Saskatchewan doesn’t use DST. And there have been times where one country or another changes the start date or end date of DST too, so there’s no reason to assume those will always be the same between Canada and the US.
Google is sent most of what people type into the location bar anyway (in real time character by character), except if they start by some prefix that makes it look like they're typing a link. Regardless of whether they have an account or hit enter.

That sounds like a much worse idea than this ad thing, yet here we are.
That just makes me feel much older :)
I'm still hoping .beat time[1] will catch on but I have been waiting since 1998... I even made a watch-face for my smartwatch showing .beats

[1] https://en.wikipedia.org/wiki/Swatch_Internet_Time
> Anything integrated deeply into chrome is going to be a lot harder to de-activate.

There IS still the option of not using Chrome.
> Javas FQDN model is actually pretty bad in practice

Right, that's why we see this kind of attack all the time on Maven Central, but never on npm... oh, wait?! NO! The kind of simple attacks you see routinely on npm (typo squatting, ownership transfers to malicious authors, now this) just doesn't happen on Maven Central at all.
I assume the https// is intentional to prevent autolinking or similar (excel loves to make hyperlinks and not everyone knows how to beat it into submission).
It is useful to have a hereditary figurehead to open flower shows and the like. It keeps the elected politicians from forming a personality cult, and gives them more time to govern. Pardoning turkeys probably isn't the highest and best use of the us President's time
Are those the main issues plaguing the web? I would lean that the foremost problem is radicalization, and that decentralization and censorship resistance will make the internet an even better tool for radicalization than it is today
Amazon-Backed EV-Maker Rivian Said to Aim for IPO This Year
I think corona hysteria may have overshadowed Brexits effects on the British economy.
Which Safari attempts to detect https://webkit.org/blog/11338/cname-cloaking-and-bounce-trac...
The Role of Influencers in App Store Optimization
It doesn't look like Gmail came out of 20% time, Paul Buchheit was asked to work on it so it looks like it was an assigned project not a spare time thing, and Google Docs was an acquisition (Writely).
I find it insane that the European Union doesn't really seem to care about any of this. It's a massive drain on their economy.

They only seem to talk about chip manufacturing, which only recently started in the first place.
They only took my account away in high school.

Silly: I had a dozen other accounts ;)
- Safari supported websql until safari 13 (september 2019), long after this issue stopped being relevant. How many people in an organization need to use PE? Probably only a few in marketing. Surely these few people could have just bought a macbook. A few macbooks must be a very small expense compared to facebook advertising.

- Or IT could have arranged a VM with an old version of Chrome.
This is the perfect kind of bug...

A single TCP packet can reboot the system. By next week, these packets will be arriving at every IPv4 address every few minutes.

It will force updates to be installed, but not risk private user data in the meantime.
My wife is a belly dancer.

Because Covid, she and her team (yep, those exist!) are practicing remotely using various streaming software.

Last training session this saturday, suddenly the teacher stopped everything, and said they would need to change what music they are practicing, after lots of dancers with confused faces, she then said: "Well, Facebook just threatened banning my account permanently if I keep streaming this music, because copyright violation."
Apple partners with TSMC to develop ultra-advanced displays
Yes, it's not really easy when people use these ambiguous names and talk about them in ambiguous ways.
Agree this would be awesome. I reckon you could obtain something similar with pandas with pd.read_sql("<query>"), but a dedicated SQL cell akin to markdown cells would make it much more pleasant
The obvious answer to this is firearms. I'm amazed at how little this is appreciated in terms of the extra stress for US police officers. US police officers are a completely different profession to every other country.

Every time they walk up to anyone, or a car, they could be shot and die. This is insane and I don't think many people appreciate this. It completely changes the dynamic of the relationship between citizens and police.

Not to mention, US police aren't trained to deal with this stress. Which is an extra problem.

I loved the interview Jocko Willink did with Joe Rogan shortly after the George Floyd killing. The answer isn't defunding the police. Its more funding. So they can spend 20% of their time training, like the military. So they can get accustomed to high stress situations and DEescalation. These skills need to be learned. And they're not.
How are the economic incentives of Proof of Stake any different from Proof of Work?
I pay $250/month for 1Gbps in USA, and it’s not even symmetrical.
Thanks Caspar, will have the team take a look :-)
Thank you for those. Do you happen to know a good one on C#? Trying to learn more about the Windows side.
'There is no good reason to use short timezone codes like EST, CST, PST — doing so will only bring you pain. Either use the tzdb name like America/New_York, or use an offset from UTC, depending on what you want.'

All you need to read/remember is this, this applies everywhere not just with date.
O2's billing emails, and a well known bank have broken DKIM signatures as they are improperly forwarded.

No chance of getting through to their tech support, especially since these types of email are usually from a no-reply@ address and the people manning the phones are not the mail server admins anyway.
> toying with the idea of dropping daylight

Europeans turn back clocks for daylight saving, perhaps for last time. source: https://www.dw.com/en/europeans-turn-back-clocks-for-dayligh...
just tried the Android app. very slow. didn't return any result for simple basic text card (black text on white paper).
I think this is two arguments. The first one goes along the lines of: Defunding isn't problematic since it is not literally the only way to earn money.

For me that's equivalent to the idea that deplatforming isn't problematic, because people can still publish elsewhere or, worst case, still talk to other people.

Key to both ideas is to reject the social significance of operational scale as well as the power dimension of gradual influence.

Practically there is quite a lot of power hidden in the leeway and the bigger a company gets the more problematic their influence is for society as a whole.

The second argument, I think, is that there is nothing problematic about content demonetization because we always can trivially construct a plausible advertising interest against any unfashionable content, hence it's not primarily seen as a chilling effect but something innocent that just, by accident, ends up continuously narrowing the conversation towards the presentable and trivial.

I think this argument isn't great. Just because there's innocent intentions at play it does neither show that there are only innocent intentions at play nor that the overall venture does not, in the end, have bad consequences for society.

If our ad-ecosystem would allow advertisers to nudge a TV station towards what news they show, it would be a bad ecosystem for society, even if it's understandable that someone does not want to show their brand next to real talk.
>Please consider escape hatches differently from basic stuff like head and you see we argue for the same end result. Head is plain bad, should be removed or annotated as the smelly thing it is. maybeHead and non-empty-collections are the way fwd there, would you agree?

I don't get what you're trying to say. I never said that head was good. The discussion about head is a sidetrack to the original question, which is "To what extend can we do without [partial functions]?", and to which my answer is "we can't do without". head is not a good example of a partial function, and its existence doesn't conflict with the idea that good partial functions are a necessary part of the language.
CD Projekt Red has GWENT source code leaked after ransomware attack
lol

has if the nix peeps are reading the code nix is wget'ing
Fognet. P2P internet router and design system enabling decentralized web access
Evidence of early (11/2019) circulation of SARS-CoV-2 in France
Guide to Landing a Developer Job Abroad
How to Impress Your Podcast Guests
Cutting your children off from their friends because you want them to copy your own hobbies is not, in any way, a healthy or sane thing to do.