skysight-inc/HackerNews huggingface dataset:
> Fundamentally, SQL lacks meaningful abstraction, and there's no sane way to package very common operations.

Tables are the unit of abstraction.

You’re on the right track with your instinct that you should be able to pull repeated work into a reusable unit. In many DB systems you can just register these sub queries as views and treat them as real tables. In the ETL world that I’m typically working in, you go one step further and just write pipelines to make useful intermediate tables.

Reuse tables, not subqueries.
Thank for replying stranger. I posted everywhere and no1 taking it seriously.
That essentially every professionally-developed website I visit seems to have concluded differently makes me doubt your analysis - or, if your analysis is technically true, that that analysis is relevant to real websites' needs.
> We are kind of used to having a couple of days where we assume everyone will run an hour late because of this.

Why not just specify times are given in winter time? Invite someone over for "19:00 winter time" rather than just "19:00".

Basically, "amazed at the kind of power the government wields" only works if people follow it. You don't have to put up with that crap (until the dust has settled) when using a time zone people already know: whichever one you've been using for the past ~6 months. (That is to say, this doesn't sound like a religious country type situation where the religious leader declares a new year randomly and you could be seen as not following the holy law by using a more predictable calendar. I vaguely remember something about Israel and Windows 9x just not supporting it until the country decided these things with reasonable lead times.)
Only if a few hundred million dollars to change their mind plus making it within walking distance of the ocean but not beachfront might help or worst case a few miles from the beach with railway taking people from their units straight to a few of the nearest beaches. I can see calabassas be a good candidate or topanga if buying out all thr people there is economically viable.
canhazip.com
I don't know what to tell you. You're pretty set in your view.

Price limit $250,000, all found in under 60 seconds :

https://www.zillow.com/homedetails/1100-W-F-St-Mission-TX-78...

https://www.zillow.com/homedetails/2701-Tassajara-St-Edinbur...

https://www.zillow.com/homedetails/6532-Rivers-Bank-Way-Tall...

https://www.zillow.com/homedetails/4035-Taylor-Way-Valdosta-...

https://www.zillow.com/homedetails/109-Mallard-Lakes-Ct-Lexi...

https://www.zillow.com/homedetails/720-S-Woodward-Ave-Deland...

https://www.zillow.com/homedetails/1429-Fulton-Ave-Kingstree...

https://www.zillow.com/homedetails/901-Arbor-Springs-Cir-Gro...

https://www.zillow.com/homedetails/1580-Linden-Ct-Florence-K...

https://www.zillow.com/homedetails/225-Ashlyn-Creek-Dr-Conwa...

(Literally thousands more...)

People don't have to live in California or Seattle.
How do you fix the computers? It must take a long time to roll out changes for the computer code to deal with this
Can you link the article to see why it would say that? Puerto Williams is a lot further south.

But Magallanes doesn't really matter, they don't have DST.
Thanks for correcting there are other patents indeed. I frankly forgot about those as in the end Tokutek technology unfortunately did not get much traction and we in the end depreciated it and focused on RocksDB/MyRocks instead which targets similar end user advantages
So how does nuclear, gas and coal being vulnerable to politicking making it less reliable relate to the wind and solar which was working just fine? Also being able to have a backlog of maintenance because your power generation is incredibly fragile and centralised sounds really bad. If only there was another way.

You're really selling small modular power generation with fewer failure modes quite well here. You're making the other options sound less reliable with each comment. Do you work for the solar lobby?
I misread it as "Hacker News bot that automated archive finding and tormenting"...
Ah yeah. My monitor cut off the text under the graph so I didn't know they just gave away their predictive algorithm. n=6 obviously works, cool approach!
Ken Burns Dust Bowl
Yes, I use showdead=on for years and see the submissions fine. And reading the contents I understand why (other) users flagged them.
.ai is a valid domain name
g.co and t.co used by Google and Twitter are shorter.
Clippy WAS "forced chuminess"

Insincere and in a "How do you do, fellow kids" kind of way
> unsexy, money-losing area of business

At big tech the unsexy areas are the money makers. Everyone wants to work on the money losing parts. It's not actually clear to me which is better for a career.
This so much.

You want to be as close as possible to critical aspects of big money.
Lol just have child and name him Bob too. Ezpz.
I built a text annotation tool recently, first in React before rewriting it in Svelte. I found React's virtual DOM annoying, esp. when dealing with text selections + wrapping those selections with elements, etc. Svelte was just simpler in this regard (and overall, IMO).

But if you're not a frontend dev and want to use lots of off-the-shelf components, Svelte's ecosystem is much smaller than React's, so you won't have access to full-featured component libraries like MUI, Chakra, etc. Additionally, Typescript support is stronger in React (it's mostly there in Svelte, but lacking in some areas [1]).

For both React and Svelte I found XState helpful to manage annotator state. It might not be necessary if your app isn't terribly complex (in particular, Svelte's built-in stores can handle complex state well), but I've found it a good way to think about state+events and more confidently make changes as a result.

1 - https://github.com/sveltejs/svelte/issues/4701
> bald

Wigs are an option, although I'd be more inclined to own it and lean into it, shaving it outright. I'm not bald yet, but hair loss runs in the family, so I'll likely be dealing with this at some point. Skin care becomes important - sunscreen will help keep skin smooth and ward off UV damage over the long term. I worry somewhat about self inflicted scar tissue from the exuberance of my youth, but I'll dynamte that bridge when I get to it.

> glasses

Contacts or lasik may be an option. While my vision is good, I get nasty migranes from squinting too hard in the sunlight, so I keep a pair of sunglasses glued to my face most of the time.

> Life gets a lot better once one accepts and deals with reality and stops getting wrapped around the axle about fairness.

Life gets a lot better if one is forewarned, and knows what they're getting into - when one has agency and choice about the tradeoffs they make, and can embrace their choices, fair or not, with both eyes open. While you're right to warn against obsessing over fairness, karaterobot certainly didn't appear to be obsessing so. In that context of replying, intended or not, your words can come across as a suggestion to discourage - if not outright ignore - the topic of fairness and it's consideration. This is a great recipe for getting taken advantage of - fucked over through apathy or ignorance when you didn't need to be, through failure to advocate for oneself or for those whom one cares about - and this is unlikely to make life better at all, and which is what I suspect what some people are reacting to.

Neither extreme - obsession with fairness, nor utter apathy towards it - are particularly great. It's fine to embrace and accept what can't be helped - but it's also fine to acknowledge, be aware, and perhaps even fight to fix what can be helped.
it's more to avoid god classes and inheritance messes.
Thanks, that's interesting in the context of my original comment because I don't believe Jewish people as a group hold any particular power, not do I think they're insecure, nor beyond criticism - my point being that they are actually a terrible example of this witticism. It doesn't surprise me that Neo-nazis would paint such a charicature.
That's just arrogance though - "Even if you disagree with me for any reason, including reasons I never thought of, but excluding the one possible reason I did think of, I'm still right so disregard your silly opinion and do it my way.".
When a VC Passes, and Is Wrong: Real Talk Between Me and Ethena’s CEO Roxanne P
http://www.longislandindicator.com/p30.html

> We don't carry spare parts or we just have a dislike for some of these brands, so please do not send the following ... Alina, Craftsman, Helios, Kanon, Peacock, NSK, Fowler, Starrett, Sylvac, SPI, Scherr-Tumico ... Anything made in China.
I learned not to trust any home services contractors' word. Have been left out to dry by 3 of them in one week after confirming appointments a day or two before.

On the flipside, I learned how not to paint walls, i.e. learned doing it the wrong way.

I learned a sump-pump advertised to pump 500 gal water per hour will take 3-4 days to pump the muck out of my swimming pool in 4-5 days, i,.e. not to trust those ratings.
And how much electricity can you get per square meter of mined ground for solar vs. coal? The answer is in the linked article, though it is not obvious at first glance. And it's not clear to me how much recycling the materials in the panels is accounted for. Of course you can't recycle coal at all.
They still do; it's goto/ though
You can! And then if you want to establish causality from log to log, representing which part of a system calls which other part, you can add another id that lets you know which log is a “parent” of another. And maybe later, you may need to propagate metadata across a request, so you build that system and use it to better enrich your logs. And maybe later, you’ll need to correlate subsets of logs with other subsets of logs, so you build a way to “link” related sets of logs together. And so on, and so on. All of this is possible with “just logs” today and if it’s your jam, go for it. But these are reasons why tracing libraries exist.
Last week I learned that Sextus Empiricus argued that learning is impossible.
I’m not sure why you’re downvoted here. While it’s true I mentioned unsoundness in my comment, when talking about this I do mean it in the senses you are talking about. It’s just that, as you correctly identified in your first reply, the original assertion is that most programs do not compile, and that specific example is the most straightforward way to acknowledge “yes, it is true that there are non-zero programs which compiled in 1.0 that do not compile today.” Soundness issues aren’t the only example, as I alluded to in my other reply done there, just the easiest one to acknowledge that it’s non-zero. But as also repeated above by both myself and burntsushi at least, the team doesn’t take a “well we said we could” approach to breakage; if breakage would be significant, the rust project either does it another way or doesn’t do it. This means that I believe, as you say, that the original assertion isn’t right. Most programs do still work.

I didn’t get to it in my other comment, but I appreciate your work clarifying in this thread previously; I didn’t see I was mentioned until well after you had made some comments. You did explain the gist of what I was getting at. I wish people wouldn’t suddenly start downvoting someone because they believe you’re wrong all of a sudden.
setDisplayMessage() {
if (this.difference <= 1000) return 'Looks like you basically have no idea how long 5.5 seconds is.';
if (this.difference <= 2000) return 'I mean, you can do better. :D';
if (this.difference <= 3000) return 'You are getting the hang of it. Sort of.';
if (this.difference <= 4000) return 'As they say, it could have been worse.';
if (this.difference <= 5000) return 'Super close!';
if (this.difference <= 5250) return 'DOH! You almost had it.';
if (this.difference <= 5375) return 'Great score!!!';
if (this.difference <= 5499) return 'NICE!!!';
if (this.difference <= 5500) return 'YOU DID IT YOU DID IT YOU DID IT YOU DID IT I CAN\'T BELIEVE IT!!!!!';
return 'Aaand just like that, you went over.';
}

elif is for suckers indeed
Calibrated (my Audyssey is +-1DB 20hz-20khz) mics do exist and calibration files do exist for some mics, plenty good enough considering how terrible the average house/apartment room is.

Your totally right about room treatment and why I don't spend more than the budget end of HiFi, because I know how terrible my room makes everything sound..

Ive measured a few rooms and sets of HiFi and the biggest issue I find is not the general frequency response, but room modes, they peak far more than even the frequency response from a cheap boom box. Without active EQ or a notch filter and extensive room treatment then trying to flatten out the response of a speaker is futile if you ignore the room modes.
Add in transient and phase responses and you add additional challenges to getting good audio.
What was Bob 2 like?
Thank you. I think this was helpful!

Can I ask if the final entry about photoelectric output from high energy X-Rays is basically using the Xrays to energise emission of photons which are then captured using PV cells? Or is it an analogous pathway to DC voltage from a PV cell tuned to high energy Xray energy?

I kind of hoped it was 'X ray in, optics out' because that would be enormously entertaining: We could run PV cells at night. The "no green energy when the sun doesn't shine" is fixed by .. shining your own suns.

What was missing as well, was the comparison to thermal efficiency. I am pretty sure direct extraction even with its losses is ahead, but couldn't see this in the article.
Android here ... Was in Europe recently and was gonna esim my way into connectivity there. Then realized no support. My next Android phone better have esim. Instead I had to buy sims over a taxi ride to store and back and back by having the taxi wait outside cause I could not phone for a new one in the small chance I couldn't get the new sim to work.
People try to use archive links, link shorteners, obfuscated links, links to tweets (which then point to the target article), Google Translate links, even pastebin and github repositories to get around domain blocks.

No idea who Evon Latrail is. HN archive search has only one result from 6 months ago. A youtube video with no upvotes or comments. Not a relevant interesting person?
I was just there a few years ago, now it’s goto/ instead of go/. Maybe go/ still works, I never thought to check.
I look for a sortable, filterable, selectable table.

Like anything coming close to AntD’s table tells me that it’s serious business.
Uncontacted as in, uncontacted.

:-)

https://m.youtube.com/watch?v=XYbR6eYrVbQ
This is surely what the authoritarian powers want.

No rooting, no jailbreaking, no way to break out of the dystopia they will inevitably try to create.

"Those who give up freedom for security deserve neither."
I didn't mean it as a direct consequence. Seltzer water will de-hydrate people that have bladder sensitivity to acids (like myself).

Also, the purpose of the " in the "undrinkable" statement was to make it clearer that it's about people considering it "undrinkable", not that it's toxic or it doesn't hydrate. You just wouldn't drink distilled water unless you were dying of thirst in the desert.
> Frankly, it seems like some sort of macro system is needed.

Like dynamic SQL? That has its own problems.

Rather than trying to extend SQL I think that people should stop trying to use SQL/RDBMSs for every task.
And the name is now reused for Rust's package manager cargo's lint tool. I wonder how Rust was able to use the name clippy, I would have thought it were trademarked by Microsoft.
It's a nice idea, but I like how HN is devoid of blatantly automated posts. Reddit is full of them and it's annoying.

Dang has actually written a response to OP a few days ago, saying essentially that he understands the intention is good, and that this sort of automation is at odds with the core philosophy of HN existing to promote curiosity and interesting conversation between human beings. When a post is popular enough, the community tends to organically post the un-paywall links, making the bot unnecessary.

Imagine having machine-automated archive link posts on every NYT and WaPo submission, it would be annoying and the early comment count would become meaningless noise, not even indicating that some person found it interesting enough to dig up the archive links for.
You highlighted the problem we are trying to solve so well, and we love WFH too.

Our platform doesn't want outside activities to be the only way to bond. The easiest way to bond is to talk about interests both people share.

Could you please check out our platform and give us some feedback? We are essentially trying to cut out the legwork needed to form meaningful social bonds.

https://www.getparallel.io/
Moore School Lectures
I have looked extensively and unfortunately haven’t been able to find anything of the kind. Closest you would get is the Flutter framework which supports web. But that’s not Python.
See also "Shortest URLs on the Internet" https://news.ycombinator.com/item?id=32801359
...Wages are also legally required to go to end workers.

I'm suggesting employers pay their employees. This isn't a radical concept and works just fine everywhere else. They already do this everywhere other than restaurants. If they aren't paying employees enough, that's a problem. You don't solve that problem by adding an optional tax on customers that is kinda-sorta-not totally required. All that does is ensure that in a certain percentage of cases employees get paid zero percent of the invisible tax. I'm just saying make the tax visible and required and stop this weird dance we do in america.
Could shave off a character by using ftp:// instead of http:// though I suppose modern browsers have removed FTP support recently. Are there any protocols that are known by even shorter abbreviations?
Bluk? Bluk! They're not even trying!

How about: y.uk
Fun with IP address parsing (2020)
Perhaps X just doesn't have enough geopolitical relevance to fund it with ridiculous amounts of taxpayer money.

If a problem that ought to be simple is actually hard, it's very likely that it's because whoever's making decisions doesn't want to pay for it.

Simple example: queues. It's a mathematically solvable problem but someone somewhere will think that hiring enough people to provide perfect service is too expensive and they're better off making people wait in line instead.
it depends, if you irritate your bladder through the ingestion of coffee or acids(it's a thing for some people, including myself), it might actually de-hydrate.
I have two comments: I think there is a vanishingly small probability that anyone is using a "botnet" to flag things they don't like. If your read the guidelines and spend some time on the site, it's usually pretty obvious what will be flagged (you can look at my submission history, I've had things flagged/killed and none are a surprise).

Second comment: based on the poster's recent submission history, the flagged / dead posts would have ended up that way under any circumstances, would probably have the account banned for pursuing some weird agenda on a tech discussion site if it was brought to moderator attention, and in no way have anything to do with "botnets"

Happy to discuss (in good faith)
Sounds like microservices to me
Had the privilege of attending a talk given by one of the MS researchers behind Clippy. They were using some very sophisticated ML behind the scenes (Bayes Nets) to interpret intent and guide troubleshooting. The magic of that often goes unappreciated with all of the vitriol / hype around the character.
You probably need to look into modern logging if you think that's how logging still works.
Where I live the "roads" are private easements, which provides adequate protections from government surveillance. Private property, with reciprocal easements, is a solution.
I do this all the time. I call it Service Oriented Monolith. I.e. you use the principle of micro-services in a single code base. It works pretty well because micro-services gives you clear segregation.
I've thought about making a site that publicly indexes and exposes all flagged and dead HN comments and stories.

Occasionally there are gems.

hnflagflyer.com
I will post a follow up.
Twist it however you like, end of the day the tourism stats are fantasy propaganda and it's the tax payer funding the crown. Their property belongs to the people of the UK and will one day find its way there.
Apex ai. domain serves HTTP
What a lot of people don’t realize about QA is that it’s also a point of Empathy to your end users. Some might think it’s the PMs job to think as an end user but in my experience PMs are so bogged down with other sales adjacent duties that they rarely if ever can provide that pillar.

This is a core issue with for example Google products where MANUAL PROCESS BAD seems to be a religious bastion.
>Now we just build our stuff using wathever curated image is there that can be used and ship it without worrying about OS patches.

So you basically replaced the "we regularly have to update the OS" with "we regularly have to pull the newest image". It's possible because I have a Linux admin background but I don't see that big of a difference here. Oh and just using whatever curated image is there doesn't necessarily provide you with a secure environment. [0]

[0] https://snyk.io/blog/top-ten-most-popular-docker-images-each...
Still gives you negotiating leverage, but just in a different way.

Doing all the grungy work means that a.) you can describe what grungy work needs to be done that a potential new employer and b.) you can describe the solutions you took to these problems. Basically, you can pass all the bullshit filters that savvy employers put in place, because you are not actually bullshitting.

You still make your money in the transaction, that point where you actually get an offer letter from an employer and negotiate a compensation package. But the input to that compensation package is based on how much value your new employer expects you to add to them, and a primary input to that is how much value you added for your past employer, and how much your new employer believes your claims of that.
Build 'projects', seriously. Also see Vienna housing model.
There is no potential in mobile housing history tells us over and over.
Yes, the slippery slope from "forum dedicated to encouraging the suicide of transsexuals" to "file-sharing host". Definitely a smooth gradient between the two.
How about the search puppy from XP (I think)?

While I thought it was cute saw no reason for it to exist as the Win2k input panel was the same, probably with a spinner.
So, that is great! But that isn't an option for everyone and that is okay.

But would it be bad if you were to have good social connections at work as well?
I remember the hate well. Clippy was this obnoxious know it all who did shit like lean in and wave his eyebrows at you tapping on the monitor glass condescendingly asking QUESTION after QUESTION when you were trying to do stuff like focusing on writing your dissertation or important TPS reports for the boss. It was so annoying. It even made noises. [1]

I think it was appealing in a cartoony 90's kind of way for maybe 10 minutes for anyone who liked that kind of thing, but if you had to sit down and use this program for hours until you were done this character was the worst. Good thing you could turn it off, I remember a ton of people asking me how to do that back in the day.

[1] https://www.youtube.com/watch?v=3G_uCbKoG5A
> It’s perfectly fine to think prostitution is a bad thing that shouldn’t be encouraged - that’s not hateful lack of inclusivity for sex workers - it’s an ethical viewpoint concerning human dignity and likely negative social outcomes that’s reasonable to express.

When you look at the consequences for said viewpoint, they're all extremely negative for sex workers. At that point it stops being so philosophical.
I knew it. Those crippled children in their wheelchairs were out to get me this whole time!