skysight-inc/HackerNews huggingface dataset:
> They don't sell anything without hiDPI for quite some time now (a decade?). Making their software look good on obsolete screens is understandably not a priority for them. And if you are happy to plug in something that old, you are kind of signaling that you don't really care about what things look like anyway.

My apologies for buying 1080p monitors that had no issues with neither my Linux, nor my Windows computers, I guess. I can understand that they might not care about what I care about (supporting the hardware that I have, rather than going out of my way to buy a new monitor just because of a new computer deciding not to work with it well), I'd argue that maybe that's even fine because it's their device and ecosystem, but jeez, that tone is super uncalled for.

As an aside, I use the M1 MacBook at a scaled resolution of 1440x900 because anything finer is hard for me to see. That's a visible PPI of around ~130 because of the 13.3 inch screen. A 1080p monitor of 21.5 inch diagonal size would have a physical PPI of around ~100, so that's around 80% of the pixel density. That's not to say that the panel on the MacBook is not much nicer, but rather that with software anti-aliasing it could definitely be okay. Somehow I don't want to buy a new monitor just for the weekends when I visit the countryside.
Blogs, personal sites, digital gardens, those are still by far the best solution imo. But they require effort and so they’ll remain a niche in the broader context of the web.
Which; Hueforge turns my 3d printer into a really fun four-ish color 2d printer.
> Mozilla decided to leave the fediverse

did they? their mastodon instance at mozilla.social still seems to exist.
> but with a widely spread GPON you're not getting much more out of that, while with AON entire neighbourhoods can be upgraded by replacing a single rack in the local POP

Except in a few places it has been exactly the other way round. AON networks in Austria for instance have been built a few years back, some random companies ended up owning that infrastructure and don't upgrade. On the other hand the incumbents have built fiber, have rolled out GPON and have in the meantime upgraded to XGS-PON whereas many on AON got stuck. It's slowly moving but very gradually.
>less replaceable

Only when they are the only ones that have that knowledge, not when teaching it becomes rote.
On readability, I often find aligning things in two columns is more readable. To modify the two examples in TFA:

SELECT e.employee_id
, e.employee_name
, e.job
, e.salary
FROM employees e
WHERE 1=1 -- Dummy value.
AND e.job IN ('Clerk', 'Manager')
AND e.dept_no != 5
;

and with a JOIN:

SELECT e.employee_id
, e.employee_name
, e.job
, e.salary
, d.name
, d.location
FROM employees e
JOIN departments d
ON d.dept_no = e.dept_no
WHERE 1=1 -- Dummy value.
AND e.job IN ('Clerk', 'Manager')
AND e.dept_no != 5
;

In the join example, for a simple ON clause like that I'll usually just have JOIN ... ON in the one line, but if there are multiple conditions they are usually clearer on separate lines IMO.

In more complicated queries I might further indent the joins too, like:

SELECT *
FROM employees e
JOIN departments d
ON d.dept_no = e.dept_no
WHERE 1=1 -- Dummy value.
AND e.job IN ('Clerk', 'Manager')
AND e.dept_no != 5
;

YMMV. Some people strongly agree with me here, others vehemently hate the way I align such code…

WRT “Always specify which column belongs to which table”: this is particularly important for correlated sub-queries, because if you put the wrong column name in and it happens to match a name in an object in the outer query you have a potentially hard to find error. Also, if the table in the inner query is updated to include a column of the same name as the one you are filtering on in the outer, the meaning of your sub-query suddenly changes quite drastically without it having changed itself.

A few other things off the top of my head:

1. Remember that as well as UNION [ALL], EXCEPT and INTERSECT exist. I've seen (and even written myself) some horrendous SQL that badly implements these behaviours. TFA covers EXCEPT, but I find people who know about that don't always know about INTERSECT. It is rarely useful IME, but when it is useful it is really useful.

2. UPDATEs that change nothing still do everything else: create entries in your transaction log (could be an issue if using log-shipping for backups or read-only replicas etc.), fire triggers, create history rows if using system-versioned tables, and so forth. UPDATE a_table SET a_column = 'a value' WHERE a_column <> 'a value' can be a lot faster than without the WHERE.

3. Though of course be very careful with NULLable columns and/or setting a value NULL with point 2. “WHERE a_column IS DISTINCT FROM 'a value'” is much more maintainable if your DB supports that syntax (added in MS SQL Server 2022 and Azure SQL DB a little earlier, supported by Postgres years before, I don't know about other DBs without checking) than the more verbose alternatives.

4. Trying to force the sort order of NULLs with something like “ORDER BY ISNULL(a_column, 0)”, or doing similar with GROUP BY, can be very inefficient in some cases. If you expect few rows to be returned and there are relatively few NULLs in the sort target column it can be more performant to SELECT the non-NULL case and the NULL case then UNION ALL the two and then sort. Though if you do expect many rows this can backfire badly and you and up with excess spooling to disk, so test, test, and test again, when hacking around like this.
The surface of Europa is hard vacuum and its not landing there, with several miles of ice to the ocean. It's as protected from contamination as it's ever going to get.
Yes. We are using rolling sentences. Not just pairs. But the whole story. I have written a little about this in my previous post, shape of stories, https://gpt3experiments.substack.com/p/the-shape-of-stories-...

So we can see how as we are appending sentences and getting the embedding we get the movement of the story in the latent space.
AI model beats CAPTCHA every time
Elevate your business with Zappletech. Our Contact page Zappletech is designed to facilitate seamless communication, allowing you to connect with us effortlessly. We are proud to be trusted by a diverse range of clients, showcasing our commitment to quality and innovation. With multiple locations, we ensure that our services are accessible to you wherever you are. Don't miss the chance to start your cooperation with us today.

For more information, visit our site: https://zapple.tech/contact/.

Key Points:

- Begin cooperation with Zappletech today.
- Trusted by various clients across different industries.
- Multiple locations for enhanced accessibility to our services.
Moderation is a double edged sword, I get Musk stance, he is just pro freedom.

Does not apply in India, Turkey, Brazil..
Absolutely true!

"No Valkey move", I like it! That should be come it's own meme!

Being free but not open source makes no sense at all. It is just our little ego that wants to "keep" what we think of as "ours" to ourselves.

Give all you have to all and progress will go so much faster. Others may learn from the implementation of Datomic and make something better. So your ego is hurt, but humanity wins!!

Give all you have, and it will never be enough! Give anyway!
What is a Concept Map? (2009)
Its pretty amazing, if you are curious just try asking it to do a live translation with a friend that speaks another language, its realtime and very seamless
I thought someone had sent me a fix for this in the distant past, but I can't find the "MSDOSxxx" label in the source. However the custom generator should be easy to fix:

https://gitlab.com/nbdkit/nbdkit/-/blob/a2fe619c45a97fd89063...

However one definite restriction is it only serves FAT32 (not FAT16), which would be a dealbreaker for really old guests like this.
Why wouldn't guestbooks, forums, webrings and things like that count? They certainly predated blogs, were on the web, and seemed social enough to me.
Or stops at a local minimum :D
Ok, you're almost there. Why would it be career ending?
I’m saying this sincerely: I appreciate you for taking the time to edit a comment after recognizing that it was snarky.
We are brought into existence from dust, and marvel at the creation we find ourselves in. It looks like we're the only living things in this vast cosmos, how strange.

But sure, we could just focus all our attention on increasing our industrial capacity and expansion. Although that also seems so empty and unsatisfying to me.
Will the levels of radiation allow life to exist there?
Yes, I guess new ideas have never contributed to any change in social dynamics ever. That's the course of history you know: the social psychology and accepted wisdom is exactly as it is now, unchanged from Roman times because no new thinking based on discovery or philosophy ever led to a shift in the structure and beliefs of society.
100% GameMaker https://gamemaker.io/en
Refik Anadol Studio reveals plans for first museum of AI arts
Proper compositions use the perfect 5th as the soul source of harmony, as in 10th century Gregorian chant and liturgical music (the peak of human creativity, put to its proper purpose.)

Any other dissonant intervals (major 3rds, etc.) are the work of the devil.

1950s era DCI, JP Sousa, brass band works by Elgar and Vaughn Williams, it’s all a discordant mess, created to titillate an unruly (and ungodly) audience.
'Try to detect benefit cheats.'

Or wait till the 1st one surrounded a mountain successful at a hight of 3,5km

;-)
There are literally bullet points to list what the Foundation will do.
TIL! LangSmith is great.
OS/2 2.1 (1993) cannot support FAT32 (1996) as it predates it.
Europe's deadly floods are glimpse of future climate
Amazon Joins the MPA as Its Newest Anti-Piracy Member Since Netflix in 2019
Global heating 'doubled' chance of extreme rain in Europe in September
Anti-Aging Enthusiasts Are Taking Rapamycin to Extend Their Lives. Will It Work?
GPON has been such a bad idea...

One fiber, One ISP port has always been the right way.
https://archive.ph/qqnjm
Smart TVs take snapshots of what you watch multiple times per second
Don't pay for URL shortening services anymore
Employees are more expensive because they are less replaceable. A company must invest a certain amount of money into labor to make a profit; however, if that company learns it can invest less money into endeavours to make the same profit, then it can decrease the amount invested into labor. The only way to do so is to create some sort of technology, or social relation, that makes the price of individual workers cheaper. Thus, any reduction of cost of labor that increases profit is something that makes employees more replaceable.
Why would he never do something like that if it's a dream of his?
ExxonMobil deceived the public with plastic recycling, lawsuit claims
Nordiska Kompaniet is no longer a proper department store, but a collection of boutiques. This has been the case for a couple of decades. The real department store that's left in Stockholm is Åhléns, but it's very mid-market, not fancy.
I’m counting myself lucky dealing with Bell Aliant who issue a router with an SFP stick. I’ve pulled it and stuck it into an Edgerouter X SFP. They do split their IPTV, VoIP and Internet networks onto various VLANs, but that’s about it. No weird authentication hacks like PPPoE either.

Just MAC authentication and go..
Sure, and some of those things were made up thousands of years ago and have proven to work well since.
Others were made up in the last 30 years by global corporations trying to extract maximum profit as fast as possible, future be damned.
It requires additional work to support that.

I wouldn't like to put a product out that I'm not actively testing. Both I and my coworkers use Linux and macOS daily.

So, supporting Windows is not something I'd like to work on in the future. The project is open-source, though, so I'd be happy to see the PR for Windows support.
My guess: Most people are motivated by money and power. Matt probably has enough money and judging by the fact he's still running Automattic, he clearly loves to have power. But now a big VC is investing in WP Engine and he's afraid he'll lose control over the direction of Wordpress.
I wonder how many nat security council meetings there would be between a discovery of life on Europa and the public getting to hear about it, for cases:

1) the life is non-intelligent
2) the life is intelligent
When something is not available in EU, you instantly know they're up to no good.

edit: Sorry if privacy hurts your feelings, people who downvote me.
All versions of RPG Maker frequently go on sale on Steam, the older ones you can get for pennies. XP, VX and VX Ace support Ruby as a scripting language, meanwhile MV and MZ supports web export and JS scripting. Can't recommend these programs enough.
> perhaps if this fragment is a CTE or view

Yeah I guess I should have specified that this technique usually works best when done in the outer query, not buried deep inside.

It can be particularly effective if you fetch partial results, ie due to pagination or similar.

That said, these things aren't set in stone. I shared my experience, but my first tip goes first :)
Ask HN: Do You Google Less?
Google used to be my go to place whenever I needed to search for something online. But quite recently I’ve found myself using more and more ChatGPT & co in my day to day life as a developer.

While I still use Google a lot, I believe my usage has decreased by 50% in the past few months. ChatGPT has covered the needs and feels even better now with specific queries, such as « help me write an SQL query », or advanced ones.

Sometimes I start with Google (old habit) only to open ChatGPT a few moments later as the SERP doesn’t fit my needs.

Just wondering if you have the same feeling?
Should we bring life there - just in case we find none? Like some deep sea smoker sample of life, transported to another deep sea smoker?
Trump wants a peace deal in ukraine that could involve land concessions.

Do you think rewarding the aggressor with large-scale land concessions (the only kind they have indicated they will accept), along with other concessions they will certainly demand (a lifting of sanctions, no need to pay financial restitution for the immense suffering and damage they have caused; and certainly no prosecution for war crimes) -- can provide a viable foundation for "peace"?
This is off-topic but, I really don't get why some of those websites are blocked for some countries. For example I'm trying to reach from Türkiye but it seems they blocked the access through here.
There's no doubt that industrial ag makes it possible to feed the world. But 10 acres can feed a neighborhood and we have plenty of spare labor. 19th century industrial scale was super labor intensive compared to today.

Just as you might have a mixture of crops, why not have a mixture of methods? What if you had to do 10 hours a week at the "unemployment farm" to qualify for unemployment benefits?

I don't imagine it would put any dent in the need for giant ag producers. But it could fuel a lot of experimentation.
Sam Altman only said this: https://x.com/sama/status/1838864011321872407

>except for jurisdictions that require additional external review
Very good initiative, I will try it out for my project and donate monthly if it is successful!
An easier way to get your logo in the inbox: Google's latest BIMI changes
I don't believe this, gpt4o and chatgpt is already available in the EU. Adding advanced voice mode doesn't change anything.
The Deutsche Telekom didn't force Meta to use the private interconnecT. They kept it open after meta wanted 40% off the previous price and the talks broke up.
Thoughts on working inside a data center suite
That’s likely due to the improvements made to the AI models. I don’t think ChatGPT 3 could have made me changes my search habit. But recent models are really impressive now.

Also, I know you shouldn’t trust what the AI says, but you shouldn’t trust either what the Internet says.
Never, but never, in any situation should you give a police officer a turned-on mobile phone. First, turn it off and then hand it over. It’s as simple as saying, “Hey Siri, turn off phone,” and then confirming. Once this is done, the phone is indistinguishable from a brick in terms of stored information. If you hand it over turned on but locked, there are several police devices that can unlock it and copy the information it contains.
Some areas may become inappropriate(lethal...) for housing. A lot of people may have to be moved, not to mention the amount of new housing to build.

Some states should have a lot of spare housing and keep it available... because because once they need it in a kind of urgent matter...
FBR – This robot constructs house walls in Florida [video]
We can't any more so than any other lander/prob/rover we've sent. And will it really matter when we eventually (probably not in our lives) send people there anyway. All their body-biome and other contaminants will come with them, too.

We are going to contaminate the solar system with humans eventually. A spore that may survive and MAY be viable is the least of the Europa's problem.
>Somehow I can tell instantly that it’s a chatbot [...] because of that I find it harder to use than just typing to it.

That to me is precisely the reason to still use it without hesitation, because once it starts getting very-much-human, I don't know if I want to use it unless I really have to.

I think there's a lot of merit in keeping it sounding just a little artificial so that it is easier to have some psychological distance from what is already an overly anthropomorphic experience.

In religion/religious studies, there is the occasional debate of whether or not deities are/ought to be anthropomorphic, and atheism of course finds the whole notion ridiculous. Considering that our hopes and dreams with AGI can often feel religious -- maybe it's time to take that same lens towards AI.
"The user has asked the LLM to do web request based off untrusted input."

I'm not sure if you're talking about the initial attack vector that plants the attack in the LLM's persistent memory, or if you're talking about subsequent interactions with the LLM.

The initial attack vector may be a web request the LLM does as a result of the user's prompt, but it does not necessarily have to be. It could also be the user asking the LLM to summarize last week's email, for example.

Subsequent interactions with the LLM will then make the request regardless of what the user actually requests the LLM to do.

"The LLM is a completely stateless machine"

In this case, the problem is that the LLM is not stateless. It has a persistent memory.
This is a great low budget sci-fi film (and pretty scary at the end too).
Another related link was submitted earlier at https://news.ycombinator.com/item?id=41636491 if it helps.
The relentless march of government surveillance and surveillance capitalism will ensure that eventually we will have Global Citizen ID.

They'll pretend that it's not mandatory while the entire system conspires to make life more and more difficult for those who oppose and resist it, until it becomes impossible to live in society without it.

Remind me in 5~10 years.
This is a surprisingly crowded space. Aside from the big names like Scratch, Blockly, Roblox and (to an extent) Minecraft Education. There are heaps of projects out there created by educators who wanted to improve their own course. One particular example I was quite impressed with was Blockly -> Unity:

https://app.code-it-studio.de/course/step/4/44

I've worked in this space a lot: professional game development, led EdTech engineering departments, and worked as CTO of a company building a UGC interactive fiction platform. I've a six year old daughter who is really interested in creating — art, media, games, whatever. My personal opinion is that a lot of these platforms make a critical mistake. They all neglect that game design is hard!

Look at all the games that flop on Steam each year. These are made by professionals. It's disheartening for kids when the thing they've worked hard on simply isn't fun — particularly when they share it with friends and are met with, at best, a shrug.

Kids are going to be different, so it's still worth trying all the stuff that's already out there. However, I'm currently working on something in this space that's a bit different. Basically, removing the complexity of game design from the equation, but still allowing creativity, the ability to program functionality, build new mechanics and the ability for kids to share their work.

Of course, it's an interesting one, because kids most certainly say they "want to build games". It's just that kids, young kids in particular, don't understand what is actually involved in building the games that they love to play. The goal of what I'm building is very much to guide kids to graduate beyond the platform and ideally set kids up to make games from scratch — it's just not a good place to start.
> Hungary is a democracy.

Oh, is it still? OK, maybe... But just barely, ad not for long.

> the elections “were well ... marred by the absence of a level playing field”.

Yeah, that's what should'a tolja it's not much of a democracy any more.

> I don’t see how that’s worse than the French people voting Macron out and France still being governed by Macron and his people.

That's probably mostly because the French people have done nothing like voting Macron out. France hasn't had a presidential election this year, not last yar IIRC.

> Throwing around words like autocracy is by now lame and tired

Yeah, you're right, it is. When it's unwarranted. But do you know what's even more lame and tired? Defending autocrats.

Especially if it's done as badly as your attempt here.
Restaurant Portions Are About to Get Smaller. Are Americans Ready?
Related: "Holy Hell, the Social Web Did Not Begin in 2008" https://news.ycombinator.com/item?id=41644267
https://news.ycombinator.com/item?id=41572137
I think maybe a way of dealing with that would be to require the person to chat to a qualified therapist about it for a couple of one hour sessions before hand. That way the people who were temporarily depressed could be helped out and the ones with something like terminal cancer could go ahead.
http://archive.today/7DcyJ
But would you want it to feel exacty like a real person in the first place? I think for that it would have to make itself far less articulate, etc as well.
async function assignDriver(rider, availableDrivers) {
const driverDistances = await calculateDistances(rider.location, availableDrivers);

for (let driver of availableDrivers) {
if (driverDistances[driver.id] > 5) {
continue;
}
if (rider.preferredVehicle && rider.preferredVehicle !== driver.vehicle) {
continue;
}
if (driver.rating < 4.0) {
continue;
}
if (driver.rating >= 4.5 && rider.preferences.includes('Premium Driver') && !driver.isPremiumDriver) {
continue;
}
return driver;
}

return null;
}
Maybe the real truth, was the friends we made along the way.
Someone who defends the insanely slow speed of US innovation with consumer finance has not spent any amount of time talking to folks outside of the US.

There is this wild myth that the US is the only true developed economy.

The US is incredibly insular with how it approaches financial innovation.

As many of us deal with software, it’s the equivalent of “N-I-H Syndrome”.

We’re only just now starting to get Fedwire after India, Australia, the Eurozone, and countless other countries have had instant payments for a while.
> I don’t know who came up with the “30% of your salary”

Well of course, it was "the experts". You know... "THE experts".

I wish I had $20 for everytime the media parrots something without every questioning it. And the masses nod mindlessly and think, "Yes, of course."

In this case... Landlords, banks and real estate agents - all with an interest in higher === better - are the likely candidates for "the experts".