skysight-inc/HackerNews huggingface dataset:
Hey, I work for PlanetScale.

Definitely not normal. It’s hard to know why you’re seeing slow queries without more information.

The most common causes are either: missing indexes or network latency between the app and database (are they in the same region?).

We don’t have cold starts, but it is possible for queries to get faster once data is moved into memory. 3-4s is very slow though, I suspect it’s doing a full table scan and an index will solve it.

If you check Insights you can get more info, would also help to run an explain on the query (https://planetscale.com/courses/mysql-for-developers/queries...) to see what’s happening.

Also, if you email support, they’ll help debug it for you. Hope that helps!
"In the real world, everyone spies on everyone else."

https://m.koreaherald.com/view.php?ud=20131106000458
It's true, but, to quote Dr Ben Goldacre, "I think you'll find it's a bit more complicated than that."

Meccano (and Merkur) use proper fasteners. So, you're learning useful life skills with the fiddly bits.

But that also means the joins are much stronger, so you can build working machines that can handle real loads in Meccano.

Meta-but: when you do this, you discover that the thin metal plates are not strong. So, you need to learn to build box section structures and so on, which in itself is a real-life engineering skill which can help if you later go on to building structures from real-world materials such as metal tubing, wood, bamboo, etc.

So yes, the fiddliness is a pain, but it's an educational pain that leads to more learning...

Until you end up with the skills to build multi-meters-tall objects and working machinery.

Whereas Lego doesn't scale up well. Even large Lego sculptures, which are mostly static and unmoving, not machines, must be glued together. But that means you have to do un-glued test builds, get it right, then tear it down and repeat the entire process but with adhesives.

Above fairly trivial level, what Lego teaches is bad practices and bad engineering. Which is not a criticism of Lego! It's a toy and meant to be one, and it's a great one. But building complex machines is not what it was meant for -- whereas that's exactly what Meccano is good for.
or a PC in general:

> Global PC shipments tumbled to 56.9 million in the first quarter, down 29% from the same period a year earlier

https://www.wsj.com/articles/pc-shipments-fall-29-led-by-dro...
You don't even need the complex part for this. You can do the infinity-projection trick on the real numbers alone as well: https://en.wikipedia.org/wiki/Projectively_extended_real_lin...

A similar trick (point at infinity or ideal point) is used in projective geometry to distinguish between directions (vectors) and places (points) by using coordinates only: https://en.wikipedia.org/wiki/Projective_geometry

But if you actually want to do calculations with infinities and infinitesimals the surreal numbers might be better suited for that: https://en.wikipedia.org/wiki/Surreal_number
This just goes to show that you really have to be careful when slinging out math facts. I've done some under grad maths and the only line on that page that I understand is

"The extended complex numbers are useful in complex analysis because they allow for division by zero in some circumstances, in a way that makes expressions such as 1 / 0 = ∞ 1/0=\infty well-behaved."

It clearly does not satisfy a primitive understanding of 1/0.
I also found Dawkins while I was losing my faith, but all I can attribute to him is an edgy phase of that process where I thought it was cool to pick fights with religious people to poke holes in their arguments. I regret that now, but thankfully it was only a phase that I grew out of a year or two later (before I managed to burn too many bridges with very nice and reasonable people who happen to be religious.)

Had Dawkins not existed, the ultimate outcome would have been the same. I think once you go down the path of doubting, the obvious contradictions in religion stack up fast and drive you further along in that process, regardless the influence of Dawkins. Reading the bible had a lot more to do with my atheism than Dawkins. It was impossible to reconcile the contents of that book with the christian god as had been taught to me as a child, so the whole thing unraveled.
This is a lie. It only proliferates addiction and does nothing to help those addicts out of addiction. If you look at SF, people are dying of drug overdoses at an epic rate. More people died from drug overdoses in SF than did from COVID. Think about that.
http://catb.org/jargon/html/H/ha-ha-only-serious.html
Anyone comparing sales/growth/general economic measurements from COVID until now is running a fool's errand. Compare metrics w/Fall of '19 and use the average from the past decade to really gain insight.
A lot of people would
The “Up” children – then and now (2013)
His very first example of a "hard target", string theory, has been criticized repeatedly by Neil deGrasse Tyson (and many others), one of the people he explicitly accuses of being "in tribe". The rest of the article is downhill from there; I see numerous other errors/inaccuracies just from a skim. Seems like these are just a bunch of substance-free attacks from a contrarian. Sure you can find some individual people saying some questionable and unsubstantiated things, but his broader claim of groupthink doesn't hold water.
Oregon too!
Artificial Intelligence (AI) Ends in 2050.1
A Naples doctor, bitten by two tarantulas, did not suffer the dancing illness
I wonder if AI systems like ChatGPT will be helpful in this area. Something that’s able to track all requirements of a system and understands the code enough to validate it against the requirements.
This might be the dumbest shit I’ve ever read. It’s just one logical fallacy extended into 750 words. “Never do extremely good thing x because sometimes it causes bad thing y to happen”
And bill Maher interacts with other intellectuals. It doesn’t make things incorrect. I never said Huberman doesn’t usually interact with other researchers. I didn’t say most were right wing. I don’t know most of them.

Also how about any other part of my post? Besides doing what someone else did and bringing up how I’m a bully or conceited while being far more dismissive than myself.
And none of us are saying anything about "porting" we are talking about adapting the medium to a new format, but you seem convinced the only way to see it is exactly how it was designed in the 90s.
Thanks for the correction and explanation. I haven't used Ubuntu in years, so all of my knowledge of its issues comes second-hand and I don't want to spread FUD about things that aren't actually issues. Sounds like the problem is worse than I thought, which just solidifies my decision to stay away.
Is it years old? One place has a bunch of drawers and the drawers are labelled Dall-e, MidJourney, and Stable Diffusion. That seems pretty recent to me.
Day planner, paper, hipster pda: https://www.43folders.com/2004/09/03/introducing-the-hipster... [edit, another e.g.]
I keep a list on https://www.commandpalette.org - you can have an understanding of the distribution of the command palettes <> corresponding shortcuts there. Let me know if I am missing any apps - there should be more I haven't included yet.
I’m starting a Residential trash/recycling hauling cooperative

No investors, democratic organization, our vision is to give economic power to the working class
Page crashed?
I don't think that there's a hard number anywhere that you can say "this will be good, that will be terrible", and you can always have good or bad luck. I've noticed the littering too, maybe that's an indicator -- but in the end, it could be one person doing the littering, so it's probably not super reliable.

The dollar value is hard to estimate. I'd pay a few hundred extra to only have neighborly neighbors, but I probably wouldn't if my budget was tighter. Would I pay 2x or 3x the price? It depends. When my one neighbor was escalating hard, I totally would've, but when he's mostly normal? Probably not.
…and their votes count just as much as yours.
On the flipside, there are also a small selection of unproven treatments that work better than standard care.
Still slightly higher than Q1 2020 or Q1 2019, so really just regression to the mean after the unusual spike in demand created by the pandemic.
Source: https://www.statista.com/statistics/263428/apples-revenue-fr...
Here's data. # of Apple shipment.

2019 Q1 - 3.9m

2020 Q1 - 3.1m

2021 Q1 - 6.7m (111.5% increase YoY)

2022 Q1 - 7.0m

2023 Q1 - 4.1m

Apple experienced explosive growth in 2021Q1 over 2020 Q1 compared to other PC makers.

Lenovo (+59.1%)

HP (+64.1%)

Dell (+23.4%)

Apple (+111.5%)

Acer (+73.5%)

Where as Lenovo and HP declined ~15% in 2022 Q1, Apple managed to gain 4.5%. So compared others, Apple had more to fall.

Looking at the multi-year trend, the 2023 PC sales volume is returning to 2019 figure, except Apple.

Lenovo 13.4m (2019) vs 12.7m (2023)

HP 13.5m (2019) vs 12.0m (2023)

Dell 10.4m (2019) vs 9.5m (2023)

Apple 3.1m (2019) vs 4.1m (2023)
Thanks for explaining what floorplans are. What does it mean for a bank to "pull" a floorplan?
Horgan disagrees with adherents of scientism not on their epistemology but on some of their claims. That’s why, apart from a quick mention of falsifiability, he mostly simply negates what, e.g., Dawkins says—on cancer, or genetics, or multiverse theory.

Now I happen to think that he might be right, and that on most of these questions there is a fact of the matter amenable to investigation, but this is really quite a lazy approach; it’d be ambitious to properly address even one of these in a discussion of this length.
I think this may be a counterexample to

“Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems.”

Something along the lines of

let r = Regex("\s*(?:(false)|true)\s*").ignoresCase()

will match “false” or “true”, ignoring leading and trailing whitespace and case, and one can test whether it matched “false” or “true” by checking whether the captured group is empty.

It also doesn’t produce a space-trimmed copy of the string.
Aw oh no :(
I’m personally excited for the work to bring the HAMMER2 filesystem to OpenBSD. It would be great to have a modern filesystem in base. https://github.com/kusumi/openbsd_hammer2
It won't. My daily driver is still a mid-2010 iMac.
You could, but no normal Unix app will understand it or be able to use it, since this is one of the things that the Unix creators removed from the more complicated forerunners of Unix to make their smaller, simpler OS.

Sadly, this simplification was, IMHO, a step too far and a bad thing to remove. But Unix's namespace is much simpler, and doesn't really understand and incorporate extensions and things either. Which is a limitation but it makes it much simpler.

The fact that most Unix GUIs, from NeXTstep to KDE, put back in and use file extensions to associate files with applications shows that this is in fact important functionality.

Without extensions, having version numbering doesn't make as much sense.

But a Unix with file extensions and file numbers would be less like Unix than is, say, Plan 9 or Inferno.
This is like SBF and co, right?
I think a lot of the 13" buyers will end up upgrading as they sound pretty tired about the lack of dual-monitor support.
Gen Z will be one of the most practical generations in history, thanks to Youtube.
The reverse/inverse is taking about a physical sport in cerebral terms, like the other commenter comparing boxing to chess.

Another analogy would be someone talking about their music like (a) code.
I didn’t say conservative. I said or meant, [leans] right wing. I wouldn’t call Huberman conservative. Would you?

What do you call the Liberal Party of Australia? They aren’t left leaning at all.

I’d be eager to get an answer to this because I keep getting called elitist and I don’t get it. I thought Americans like myself aren’t supposed to think the world revolves around America.

“The Liberal Party of Australia is a centre-right political party in Australia,[21] one of the three[22] major parties in Australian politics”
https://en.wikipedia.org/wiki/Liberal_Party_of_Australia

You can also check how Wikipedia defines liberalism.
Any model of reality except reality itself is lossy. A model that can fit inside a human brain is extremely lossy. The only thing that differentiates between models is usefulness, but that is debatable too, if you consider short vs long term effects. Be careful what you wish and all that...

So we could all use a little modesty when it comes to the models that we build inside our heads. On the other hand, a model which you know is flawed will never drive you to act stongly. So a certain ammount of faith in what you believe is required for action and implied in that is the rejection of opposing beliefs.
As a programmer I’m happy to use a locked in box in my free time that does with a push of a button exactly the thing a vendor promised.

It sounds like you imagine all compute devices should be generalized compute platforms. Which IMO is as silly as demanding all products containing wood and metal rods should function as abacuses.

Free compute is not a value adding feature in a product unless the main feature of the product is general computation.

Adding compute capabilities to products often makes them better, but it does not mean the platform should invite free tinkering.

I don’t want to tinker with my phone. I want it to be able to function as a phone.

That said of course we all want vendor-agnostic compute platforms to exist, and the world is so much better because we can use Linux if we choose.

But the idea all devices with CPU should be open is a non-value adding one.
Preventing inflow.
Anyone using V Programming Language?
Fell over this relatively new programming language. I normally don't get so excited about new programming languages, but this seems to improve on a lot of the things I dislike about Go while having a lot of the benefits of Go.

Do anyone use V Lang in production? Or for other things? What are your experiences wit this?
Which book? The God Delusion was certainly full of that, but e.g. The Selfish Gene was much more interesting.
Sounds like how Windows COM (Component Object Model) works.
Yeah, that's my bigger worry: that "desktop" (and then "laptop") are going to become niche platforms that only old-timers use.

I dread our only-phone future.
Generally Apple users don't update their computers too often, and when they released the M1 models a lot of people had models pre-2016 that needed upgrading (since pos-2016 models sucked balls).

So, part of that unusual demand was also customers finally upgrading their old MacBooks.
ChatGPT is basically the opposite of formal verification...

It itself is not verified, and its results are so inaccurate that you need to verify them anyway.
A Brief History of Web Maps
I only just upgraded mine this past month, but I was still using a Macbook Pro from 2015 (not regularly, it finally was getting too annoying to use much after 8 years, but I have a Windows laptop also so I wasn't in a big hurry to upgrade).

Part of me kind of wishes I didn't though, that was a lot of money I dropped there, especially with all the layoffs (my company had their first layoff a week after I made the purchase also).
> It would not require a lot of changes.

It would require Apple to stop being Apple. Give up their App Store revenue (Steam) and give up their proprietary 3D API in favor of a standard? Might as well ask for a Start button.
https://archive.ph/5MrBJ
The update server supports the Omaha protocol, is called Nebraska and is available here under an Apache license: https://github.com/kinvolk/nebraska

Our team hosts the public server, but any Flatcar user can run Nebraska themselves and point their nodes to that.
A human isn't trained to program in Python by memorizing impressions of millions of examples correlated to a verbal description, from which he or she regurgitates mash-up that statistically correlates to the prompt, without having any idea what the content means.

Ask it to write the same program in some little known programming language. A human who knows how to code could do that by studying a small amount of reference material.
https://en.wikipedia.org/wiki/Red_Sea%E2%80%93Dead_Sea_Water...

But...

https://www.timesofisrael.com/after-years-of-delays-jordan-s...
The writing style is too hyperbolic that it detracts from the argument it is trying to make. A certain amount of figurativeness is good to add dimension to an argument, but here it has been overdone.
Why not call this SupaPool? Supavisor is very BEAMie.

Question about telemetry.

These are the metrics emitted by Ecto:

- :idle_time - the time the connection spent waiting before being checked out for the query

- :queue_time - the time spent waiting to check out a database connection
- :query_time - the time spent executing the query

- :decode_time - the time spent decoding the data received from the database

- :total_time - the sum of (queue_time, query_time, and decode_time)

To what extent are these metrics distorted by use of a Supavisor connection pooler? How could Supavisor compensate for that?
As a non-native spanish speaker I find it quite easy to understand, no more difficult than my mexican gf grandfather, and much much easier than spanish people from andalusia.

Some examples:

from Granada:
https://www.youtube.com/watch?v=pvpHcX2Ksac

from Cadiz (which they really pronounce Ca'i):
https://www.youtube.com/watch?v=mRh9OjCW6Y8
The only disadvantage I may see to this is that it skews your counter of daily cards. So you may feel discouraged if you see that you have a large amount of cards to review and that it will probably take you a lot of time to go through them all, while in fact, you will only spend a few seconds on those that you already remember. Unfortunately, there are times when I cannot for the life of me do my flashcards because there are too many of them to review, and I either skip that day's session because a) I tell myself I don't have enough time (which is a lie most of the time!) or b) I don't have the mental energy to go through them. The only (partial) solution I have found to that is doing them first thing in the morning by trying to plan my schedule accordingly and wake up a tad earlier.
The author is 25 (gen z) and has done multiple car reviews / car product reviews that feature his own car which is a manual...
Same way anti-piracy worked in the 90s: cash payouts to whistleblowers. Yes, those whistleblowers are guaranteed to be fired employees with an axe to grind.
There's something mildly charming about fixes to ed(1) in software released today.

> Fixed ed(1) to print bytes read/written and the ? prompt to stdout, not stderr.
TIL that I'm way out of the loop on a lot of pop culture. I maybe understood 1 reference in 20. Turns out that I'm most familiar with 1980s pop culture (that of my teenage years).
That's kind of orthogonal to how Hawkins started EA. He launched with this ad putting his game designers up front and naming them outright:

https://www.eurogamer.net/seeing-farther-the-advert-that-cha...
I don't know much about physics, but cameras take pictures of things faster than their shutter speed all the time. What occurs is blurring and bright spots.

Just because something is moving faster than the speed of light doesn't mean the light reflected from it never reaches our eyes.

I think another way to perceive it is as if you have a buffer that is beginning to overflow because you can't empty it faster than the speed of light. That overflow is how I'd imagine you'd detect FTL objects. It's like the visual equivalent of a sonic boom. Again idk what I'm talking about, but it was nice to think about :)
Please explain to me how getting $1 and immediately donating it produces more than that $1 in tax reduction.

It isn't about reducing taxes, it's about getting some sort of altruistic branding/advertising at little to no cost.

It still actually costs the company money in customer throughput, signage, implementation, bookkeeping, etc...
It's not just the pandemic shopping spree hangover, Apple's hardware pricing is completely out of the market. $1700-$2500 for a median spec computer?

It's ridiculous.
Gun deaths among children are soaring
Show HN: ChatGPT article summaries right from the browser
We built automation via Apple Shortcuts and a FastAPI app to easily generate summaries of articles and webpages directly from your iPhone!

Please see details in the README in the link. You can run the backend on whichever serverless hosting platform you prefer, but Digital Ocean is just one-click away.

We hope folks find this fun and useful!
When apps like Blender stopped working on my mid-2010 iMac is when I jumped.
Well, as an example, last year the lights at the intersection outside my apartment went out during a heavy rain storm. I also tend to have a lot of driverless cars in my neighborhood. I watched how cars were dealing with the blacked out intersection. I saw two different Waymo cars stop at the intersection as CA law requires. Then I saw a Cruise car approach the intersection. As it did it slowed a little but then seemed to speed up as it blew through the intersection. I could only imagine the nightmare during a bad nor'easter!
In theory, if it's implemented as a true land-value tax (only taxing the value of the raw land, not the improvements/buildings), that doesn't happen.

But, yeah, somebody with a stronger economics background (than my undergrad degree, which I've never used professionally) would have to do some calculations on whether preventing mass corporate ownership via taxation would be a net positive for the market as a whole.

I tend to suspect it would be positive.
For context dmitry was a bit of a legend back wen palm was alive. His patches fixed a bunch of stuff palm never bothered to. His apps were top notch and pushed the limit on what was possible in palmOS.

So, in a way, im not surprised he’s done something like this. A work of ¿love? ¿Art?. A testament of deeply knowing the object of his passion.

Take a look at his code and admire it for what it is. Read how he explains it. It’s worthy on its own.
Quick lit: vending machines dispense false eyelashes, milk – and now books
The Guardian is overwhelmingly progressive already. Its writers are generally pro-worker and anti-corporate. I don't see how publishing one article about one statistic points to an anti-tax bias.

If we were talking about the WSJ I would agree.
Dealing with untreated sleep apnea right now & it fucking sucks

Breathing properly through your nose when awake & asleep turns out to be really important. I’m incredibly curious on how previous generations knew & the term mouth-breather became a thing, as they were obviously (well, if you’ve never experienced long-term inability to breathe through your nose, maybe it would be hard to understand the severity of the cognitive impact this has) quite right.
> which is the one accepted by everyone else

The field of finance studies how to value various assets, beginning with fixed cash flows over time, and then introducing things like risk.
That has nothing to do with steam turbines. 1 Ton of coal produces 1979 kWh of electricity, which at the current $179/ton is $0.094/kWh just for the fuel, then you have capital costs, labor, profit margins, and that still only gets you to wholesale.

For comparison, fusion fuel is $0.00014/kWh, equivalent to coal at $0.27/ton. There's no where on Earth where coal is that cheap. You couldn't move it from the mine to the powerplant for that cheap even if they were next door to one another. Even if all the costs got subsidized away, you couldn't count on the fuel remaining cheap for the lifetime of a powerplant.

And of course there's that pesky CO2 issue that makes investment in coal unattractive even if it could be economically competitive.
In this case, it means either stopping financing floorplans altogether or greatly curtailing how much they will finance.