skysight-inc/HackerNews huggingface dataset:
The author should check out Quill[1] as prior art. Compile-time query generation where you can see the generated query just by hovering over the code is chef's kiss.

One of the terrible things about most ORMs is that you can't see the queries when you look at the code. There's usually some awkward hoop you have to jump through to see it, like writing a unit test and logging the query from it, and Quill bypasses all of that.

[1] https://getquill.io/

Overall I'd say that this post does a better job of presenting the trade-offs than most. Some of the statements ring false to me, but I won't bother picking nits.

> Portable Across Languages

This is interesting, because what you're proposing in this section is a better SQL.

I don't think that's a bad idea. A relational DDL and query language that is optimized for integrating with modern programming languages might be enough of a step forward to actually displace SQL. However, implementing it as a middle layer between SQL and a programming language doesn't seem like the way to go, because it adds an extra layer that programmers have to understand. Make no mistake, people will encounter problems even if the tooling is perfect, because their own understanding won't be perfect, and they will have to go on debugging odysseys to fix their understanding, by tracing down through the layers from their code to SQL. Now you're adding a language that is just as powerful as SQL, maybe more powerful, right in the middle. I would never in a million years use a tool architected like that. The potential for getting bogged down in the details of how the different layers translate is too high.

This is why after all these years of ORMS and other database libraries people often still embed SQL in strings in their code. It isn't (always) because they're stupid or stubborn. It's because they know that embedding literal SQL puts a hard ceiling on an entire dimension of debugging.

Painfully often, when I ask somebody, "I think there's an error in this code that queries the database. What SQL does it generate?" they reply, "Oh, give me a second, I have a Datadog trace that shows it, I just have to find that link," or, "Let me run this unit test that logs it." Or, even more depressingly, they haven't even seen the SQL yet, because there were other things that were easier to investigate, so they investigated the easy things first even though they suspected the query was the culprit, like the proverbial drunk looking for his keys under the streetlight instead of where he thought he dropped them.

Introducing another equally powerful conceptual layer between code and SQL is a step in the wrong direction. Replacing SQL with a better query language that integrates better with code would be great. It will happen someday; fingers crossed it will happen in our lifetime.
The conclusion is sadly pretty simple: you don't rise based on ability or creativity, but based on your ability to take from those that try to.
All Good Things Must Come to an End: Logan Movie Review
It would be part of HRT for menopause for the reasons I gave: mental health, sexual desire, muscle maintenance.

The discussion about estrogen in men is just for context. It's not unusual to talk about levels of any hormone in men or women. There's nothing "shocking" about testosterone in women, or estrogen in men.
Here's another [1] project that does VGA output from an RP2040 (the project also includes some game). There's also some support for VGA in the pico_extras [2] repo.

[1] https://kilograham.github.io/rp2040-doom/
[2] https://github.com/raspberrypi/pico-extras/tree/master/src/c...
Me, the even scarier "untreated Thunderbolt". A truly life-threatening condition.
“oh no, people couldn't chose what caste they were born into, this book is an imagined dystopian fiction”

despite everyone being content with their caste and having lots of consequence free sex and activities fulfilling to their mental faculties

yeah I also found this world to be attractive
*Anyone not from a blocked country*
If you want a kubernetes cluster to experiment, then k3s runs just fine on raspberry pi 4 hardware
You can disable iMessage and still get plain SMS and MMS. The app is called Messages, and Apple's version of RCS is called iMessage.

But you are correct that you cannot switch to a different SMS/MMS app.
The tweet specifically refers to the model "Seems like OpenAI updated the model" and if you look at their profile you'll see "CEO @HyperWriteAI, @OthersideAI - I make AIs do the impossible." as well as a pinned tweet announcing that they're building a personal assistant/agent on top of this stuff.

I didn't check this part but the OpenAI employee very likely follows them and knows all this context.
StackOverflow petition to allow removing AI generated content
Cats live warm--what is a perfect thermal balance for them (where their body needs not expend any effort for heating or cooling) is unpleasantly warm for a human (who will be sweating.) Typical water will be chilling for a cat. Going swimming in most environments will pose a hypothermia risk at times and thus fearing it is a logical evolutionary result.
I still miss i.reddit. I've been trying hard to get off of reddit entirely but it hard because the community and information subreddits provide is still very good. But the other day I noticed the reddit frontpage is just repeating posts if you continue to click next page...
And very likely for virus/trojan etc which unfortunately give the project bad reputation
In DDR3 era heat, drivers, crashes (lots of crashes) during gaming.

In DDR4 era heat, drivers during game dev (substance painter, UE4 etc.). Lots of finicking with the card/drivers/software.

On my home NAS (Ubuntu for longest time, now Kubuntu) I've had more random issues with my RX 580 than my 3060, I know it's not the most fair comparison due to their age but still.
Personally, I’m less invested in the tools I’m using, and more invested in what I’m creating.

Granted, it is frustrating sometimes to see tools that you really enjoy using, be replaced with tools that aren’t as good or as well thought out.

But ultimately, I believe that you can create just about anything, using just about anything, and even if you’re forced to use a toolset that you don’t like as well, there’s usually nothing stopping you from adapting those tools to help you create what you want to create more comfortably.

Also bear in mind - if you stick around long enough OR study your computer science history, you’ll realize most things are cyclical, and there’s very little that’s actually new.

Almost every new trend is a new incarnation of previous concepts. Master the basic concepts, and everything else comes pretty naturally.
>I just want to have one stack and master it.

C/Linux isn't going anywhere in our lifetimes. If you want one stack, that's it.

For anything else, yes the layers of abstraction will continue to accumulate.
Seriously mentally ill and addicted should be involuntarily committed. I know that's a big decision and will lead to abuse but the alternative of just having them roam the streets is worse. The "temporarily homeless" as I like to call them, those who want to be productive but have fallen on hard times, deserve access to affordable housing. The government can build huge amounts of tiny apartments to give these people, it worked in Chicago until they recently gave up and converted those units.
Yes. There are several ways, depending heavily on the version, and ranging from most trustworthy to least trustworthy:

* By patching the ME firmware itself - see the me_cleaner project, and methods documented here: https://puri.sm/posts/deep-dive-into-intel-me-disablement/ . This is Pretty Reliable; the runtime code has been deleted from flash.

* By setting a bit in the flash configuration, assumed to be added for the US High Assurance program: https://github.com/corna/me_cleaner/wiki/HAP-AltMeDisable-bi... , https://www.ptsecurity.com/ww-en/analytics/disabling-intel-m... . This is Mostly Reliable; the mechanism has been fairly aggressively reverse engineered and was added for a program with strict requirements.

* By sending an HECI command that says "hey ME, turn off your runtime" https://review.coreboot.org/c/coreboot/+/52800 . This is Somewhat Reliable; the method is well understood and seems to work but I'm not sure someone has done a deep dive audit into whether it could be re-enabled somehow.
If you are looking for documentation, try clicking the prominent "read the docs" link. Once you do so, you'll notice "THAT schematics" is the very first link after the overview.
They probably have totally different priorities. Apollos only goal is good UI/UX.

Reddits is tracking, Ad revenue, prioritizing cached content and who knows what other priorities have been pushed into it.
If her case was latent and she wasn't a danger of spreading the disease, my understanding is that her lungs wouldn't be so ravaged that they look like she has late stage lung cancer under an x-ray. And others have pointed out your 2-3 year number is weird and not terribly accurate as well.
Site-specific browser extensions are the classic way to do this, but most mobile browsers don't support them. Even Firefox severely sabotaged extensions in the Android version.
70% of 2.50 is $1.75 which would put them under with current mobile app store pricing of a 30% fee for subscriptions. $3.75 gets them closer but then margin is $0.125 which would total to $112,500/yr if all 900,000 users switched to paid which is highly highly optimistic.
As a concept, analog computers rely upon an assumption of continuity.
Funny how HN selectively applies this rule. Third front page thread in two days without updates.
Old Reddit may be 1% of the user base, but it's 99% of the worthwhile users and janitors.
The Road Through Your Screen
Hopefully Brazil's social systems can handle the influx of extractive wealth, but odds are low.
> In a sense, it is the exact opposite of what the article describe: the system _prevents you_ to just jote a quick note and forget about it

Create daily notes (tied to the day you wrote them) or transient notes (tied to a concept) as scratch areas to quickly dump your thoughts onto the page.

Then return later when you have the time and focus to explicitly process your notes - either discarding daily/transient notes that are no longer interesting, or growing them into evergreen notes with sufficient detail and linking. Make sure it's easy to list all your daily and transient notes in an "inbox".
Does Google struggle to find employees? High comp, reputation for do little work, and ridiculous hoops if you want even higher comp and a promo.
- Do something that on most days loses a bit* of money, but sometimes gives you a big payday.

Welcome to Startup Land

* (or a lot)
Failure to comply with a health officer's tuberculosis treatment orders is in fact a crime: https://app.leg.wa.gov/RCW/default.aspx?cite=70.28.033

Detention, isolation, quarantine, and treatment are all subject to due process and overseen by the courts.
>It's particularly bad because so often (esp. for western programmers) 'countOfCodePoints' == 'countOfBytesInUTF8' == 'countOfGraphemeClusters' == """length""" so it's hella easy to accidentally write buggy software.

Then programmers will pick a random view and assume its length equals the number of characters and bytes. Also the grapheme view will introduce an OS-dependent bug.
My Excellent Conversation with Seth Godin
I'd love to convert my ninja 250 from 1987 over to fuel injection but I don't think I have the electrical expertise to figure it out. There are even throttle bodies available from japan where they had fuel injection much earlier than north america. Oh well.
I'm familiar with interrogation, and image -> interrogation -> t2i will usually generate a completely different image that the original (and it should!), unlike i2i.
> Your problem is then what to do. If you've decided that you want to wait for the big payday, how are you going to stay in business until your ticket comes in? How do you keep your investors faithful until then? This is the actual skill in this trade, btw.

I’ve been to one of the Wilmott-Taleb seminars in London. Taleb answered that question this way:

1. You buy way out of the money calls or puts which will eventually get you your big payday. Most sellers of these sort of options use Black-Scholes or similar model to price them, underestimating the frequency and/or magnitude of payout, and thus mis-pricing them.

2. Simultaneously you sell in-or-near-the-money puts or calls, which are more mathematically tractable, model-able, and thus manageable. Results in small and predictable income and payouts which you can manage to keep the fund afloat until #1 pays off.

3. Make sure your fund LP’s understand that this is essentially an insurance policy. People are accustomed to paying regular small payments for insurance against big unexpected events, and tend to accept that model for the fund too.

As you say, the skill in this trade is in discovering options for #1 that are indeed mis-modeled and mis-priced, and in #2 managing that in/near-the-money portofolio as optimally as possible to cover or minimize the steady bleed from #1. It’s not easy.
Let us know when you finally get it.
> There might be an edge case in which a raw query, tailored to a specific need or a particular use case, might be faster, but generally speaking ORMs will know much much better than the average developer how to optimise queries.

This statement is wrong. ORMs can't use DB specific features, so they have to generate lowest common denominator SQL.

With Postgres e.g. I can insert an entry and return the generated ID in a single query. ORMs can't do that.

I can also upsert entries in a single statement. ORMs can't do that.
No. Python internally would be made much faster by working on pure UTF-8. Absolutely nothing internal to the language uses the operations that code point semantics speeds up.

Since you mention the varying internal representation of strings: that’s PEP 393 <https://peps.python.org/pep-0393/>, which landed in CPython 3.3, and it generally made things slower by introducing a lot of branching and reallocating and such, though it does speed up some cases due to having to touch less memory, and some methods due to being able to quickly rule out possibilities (e.g. str.isascii can immediately return False for a canonical UCS-2 or UCS-4 string, since if they were ASCII they’d have been of the Latin-1 kind).

PEP 393 was done because people were complaining about how much memory their UCS-4 encoding had been using.

Note also how PEP 393 retains code point semantics: Latin-1 (Unicode values 0–255), UCS-2 or UCS-4; all fixed-width encodings of code point sequences. PEP 393 does also allow a string to cache UTF-8 representation (see PyCompactUnicodeObject.{utf8, utf8_length}), choosing “UTF-8 as the recommended way of exposing strings to C code”, but I gather this isn’t used very much.

(Related: PyPy 7.1 shifted to using UTF-8 exclusively internally, and according to https://www.pypy.org/posts/2019/03/pypy-v71-released-now-use... got a “nice speed bump” out of it.)
Permitting is the limiting factor.

In the United States, the current political climate will either support and fast-track or essentially deny/permanently delay all mining permits.
Why do they mask then?

It seems a little hard to psychologically disentangle what one does for social approval vs for other reasons. For example, maybe it feels emotionally uncomfortable to not mask. Is it because the subconscious is worried about disease, or because the subconscious is worried about social approval? Probably some of both, but if we removed one perhaps the external behavior would change, hard to tell.

Also IME it seems to cluster with other appearance related traits (e.g. type of dress, mannerisms, etc).
Communication has always been known to be a risky endevour with potential for various compromises, even for sovereigns. That telephony and now network communication infrastructure the world over is minimally at risk of, if not subject to, surveillance is understood.

Carrying a general purpose computer of substantial complexity that is equipped with state of the art sensors, optics, and components (including ai), which is then topped with yet another thick complex layer of software, which is subject to known and unknown access (by various parties), is not the same thing as a telephone (analog, digital, wired, or not).

Today, unless in a secured EM cage, there really aren't that many places where you can be certain you can have a private conversation, face to face. Visiting friends? Alexa and friends may be listening. Even the lousy TV sets :) Walk in the park? Your companion likely has a smartphone.

A healthy society requires the availability of private spaces and private interactions. When a citizenry becomes aware of pervasive surveillance it self censors. Self censorship prevents airing of views in an unemcumberred manner. When views are constrained, problems remain unaddressed.

Tyranny typically thrives in such insecure and non-optimal circumstances.
I think that probably falls under: HN has grown and has limited staffing.
Discussed extensively yesterday and today:

https://news.ycombinator.com/item?id=36141083

https://news.ycombinator.com/item?id=36162235
For me, it was buying a graphics card that was endorsed by Intel that turned out to not support any of the advanced graphics that were happening at the time. I was less than happy. I think Matrox, back in the day, was also a bit of a disappointment. Supposedly they supported standards and were going to be amazing. Reality is they were not amazing.
> Why should drivers be video streaming?

Because nobody has drawn a red line and Ron Jones in 1967 has shown us how vulnerable our freedom is.

We already has a lot of mandatory non-FOSS software in cars which use to phone home which effectively is a streaming (not a video yet, but amount of data is never decreasing). And a lot of so-called safety (surveillance in reality) devices are around us nowadays - phones exposing a lot of uncertain data about us, bank cards which allows banks know where we are right now, etc. If some crackpot politician proves to safety-demanding influencers that video streaming from every moving car helps us to prevent $bad_things_list so that kind of demand is totally possible, especially if using cars for mass killings would become more common than mass shootings.

> I'm just suggesting that regulators should compare accident rates of cars with and without automated breaking.

It's impossible because you have not 100% of the data.
Matrix can replace the 1-1 and group chat function of Discord, but you would need Zulip to replace the Slack/Teams group forum function. And having them separately kinda kills the whole idea, doesn't it? That's not including that neither have screensharing. Not even sure if they have group audio.
The decisions made at the executive level regarding Netflix will have a much greater impact on each shareholder's value than the decisions made regarding Squid Game's creative direction. I mean it's not even a question. Now could you find someone to do as good a job as an executive for less? Maybe but when you have a 180 billion dollar company why are you going cheap here to save a few bucks? The wrong executive can be utterly disastrous, and a lot of what I think stockholders are paying for is risk reduction.
The amount of people that still have no idea how to either download video posts or have sound enabled while playing the video... are astonishing.
The suggestion seems to be to turn the client into a generic interface for any reddit-like site, and port people to that. Imagine if a few million people swung over to a new site like the exodus from freenode.

Reddit's content isn't special. It's all network effects.
Let's make it a Democrat, then.
I didn't get what you mean by that suggestion. Can you maybe elaborate or re-phrase it?
It's hugged by HN crowd so maybe tomorrow lol.
My understanding is that the vast majority of them end up in products. Embedded in all kinds of systems. IoT, assembly lines, signs, lobby displays, interfacing with all kinds of dumb systems to get them an internet interface. $5 for a Pi-0/pi-0w is hard to beat on anything that ships less then many 10,000s of units.

Only a very small percentage are sent to hobbiest/makers. Much like how the GPU manufactures (or their distributors) sold directly to crypto miners.
This should be a crime, and she should be in prison for attempting to spread a deadly disease
boot.dat error means you're still using the dongle. Don't do that.
Do we have anything equivalent for AMD’s PSP?
On disk yes, at runtime it's still UTF-16, I believe.

This is still relevant for many databases as well, as far as I remember.
“Array of foreign keys” has been at the top of my list for so long. Would simplify sooooo much.
Which functionality produces qualia? It certainly seems related to sensory processing, but that still boils down to nerves and neurons. Does it require a notion of "self"?

The end result is that physical systems are producing a completely non-physical and subjective phenomenon.
I found the forums in which people had provided recipes for updates to Debian and Android to be helpful but it was a lot of work and should have been supported by the vendor, I agree.
> lack of limitations of usage for the code makes it open source.

Except the GPL has a huge limitation (can only be used in GPL code) which "closes the door" to a lot of uses, and yet it's the gold standard.
You can buy and download individual audiobooks on Downpour.com, which come free of any DRM.

You can find a long list of DRM-free audiobook sources here: https://www.defectivebydesign.org/guide/ebooks
I read someone else’s opinion on a separate hacker news thread saying they thought the reason for the increase was because of AI and LLMs. Twitter recently did something similar.

Not sure if it’s true but it struck me as making sense. The timing is too coincidental.
Presumably if more than the 30 people who show up care about the city council, then there will be someone who reports about it and writes something up, maybe like a substack, about it. Maybe they will call it something pretentious like "The $city Times" or "The $city Chronicle" and combine that newsletter with other topics of local interest. Maybe they will innovate a physical delivery format, too, that delivers the news on paper. Then they can really charge people for it.

This is literally all just a question of supply and demand. The only people who care show up, and the rest wouldn't even spend $2 on a local newspaper.

Also, you don't have to go to the meeting to know what happened there: all of these councils and committees produce minutes that are accessible from your city's website. I bet out of that city of 1 million, only 2x as many people read the minutes of the city council (which are almost always public) as go to the meeting. The production of those minutes is a public service.
Don't forget Apple's cut. And presumably Apollo devs don't want to work for free. And not everyone will pay. And, and, and ... soon you're charging 5, 6, 10 bucks a month.
Democrats are the party of the educated elite. As the percentage of college educated increased they become a big enough block to take control of the party from the blue collar group. Big corporations have served the well educated population of this country quite well in general.
That’s the public instance. It’s a runtime flag to osrm-routed so if you set up your own instance, you can configure it how you like. (Or use the Node or upcoming Python bindings.)
I hope the Reddit IPO fails or otherwise never makes good on the $1.3B fundraising. It would be fun to make fun of everyone ruined in the financial fallout.
According to calculations, His only pivot is to make it sub only for like 5$ a month. Remember 30% goes to Apple.
The "simulation" was a bunch of dudes sitting around a table playing AI drone D&D, and the dungeon master said "the AI has gone rogue, roll a six to override." Oh noes!
> reasonable for access to all of reddit

Not all of reddit. You're still blocked out of NSFW content (which will not be accessible over any tier of API).