skysight-inc/HackerNews huggingface dataset:
Guido is part of the community, not the community. At least not anymore.

Go to pycon and try to talk to him. He doesn't want to talk to just anyone. And he's not great at accepting feedback.

We love him, of course. But there are reasons maybe that the community of users should have a strong voice in where python goes as well.
I think that's why the GP said "on the same machine" — I read the article as comparing to the typical DB that is located on a separate machine in the data center, accessed over a network, as is currently the common setup.

But if we're considering running SQLite, the apt comparison would be against other DBs running on the same machine, because we've already decided local data storage is acceptable.

I assume Postgres/MySQL/etc would have higher latency than SQLite due to IPC overhead — but how significant is it?
It is just business in general that opposes the "right to repair" . Military contractors are not exception to the rule and there's no need to single them out specifically.

We have a business culture that unhealthily prioritize short term profit at the expenses of product excellence and stakeholders.
Who knows why, but they already are. Apparently hotmail in the early days used Linux for some servers. Linux is pretty common in Azure.
I am not sure how it works - I’m not a gamer. But I’ve seen many articles and videos pop up about this game and the controversies around it. I think the fake review thing involved buying one copy of the game and posting a political rant about how everyone who enjoyed the game is immoral, and then having friends or followers or whatever upvote the review. But I really have no idea. By “fake” I mean that it is a review not focused on the game itself or fun, but some weird agenda.
> "Do you see a rise of hate speech?" Mr Musk said. "I don't."

> He asked our reporter James Clayton for specific examples of hateful content.

> When he couldn't pinpoint individual messages, Mr Musk said: "You don't know what you're talking about… you just lied.

That is hilarious, thanks for the article.

And I don't see examples of crimes committed by X or Musk in there?
https://www.cnnbrasil.com.br/politica/condenado-por-armar-bo...

https://edition.cnn.com/2023/01/14/americas/brazil-congress-...

Couldn't find a translation for the first one, but in a gist you don't need to when, first the GSI is complacent in the coup and when there would have been a bombing attack.
Maybe a little odd, but it did start with Python. I mean, Jupyter stands for Julia, Python, and R already - so it's not too weird they just keep using the same file format.
> NYC uses that to subsidize 80% of the bus system

Don't kid yourself. No one is going to pay 5x to ride the bus. It doesn't cost that much to offer a local bus ride.

I don't think you realize where the money really goes. It goes to pay huge pensions, not to benefit the rider.
Hasn't there been a pretty consistent rachet completely independent of which party happens to be on top at any given moment?
Contrary to the "over-engineering" claims, I'll put this explanation up for consideration: it's a result of fighting the system without understanding the details. Over-engineering absolutely exists and can look just like this, but I think it's mostly a lack of thought instead of too much bad thinking.

You see the same thing with e.g. Java programmers adding `try { } catch (Exception e) { log(e) }` until it shuts up about checked exceptions (and not realizing how many other things they also caught, like thread interrupts).

It's a common result of "I don't get it but it tells me it's wrong, so I'll change random things until it works". Getting engs in this state to realize that they're wasting far more time and energy not-knowing something than it would take to learn it in depth has, so far, been my most successful route in dragging people into the light.

(Not surprisingly, this is one of my biggest worries about LLM-heavy programmers. LLMs can be useful when you know what you're doing, but I keep seeing them stand in the way of learning if someone isn't already motivated to do so, because you can keep not-understanding for longer. That's a blessing for non-programmers and a curse for any programmer who has to work with them.)
OMFG; I am in Perth, I have the same system, the very same problem and solved it almost the same way and was in the process of writing it up.

The system uses RS422, with a base64 encoded AES key in the aaservice binary, and I was contemplating building an esp32 based open source implementation of the controller.

That's a crazy weird coincidence.
On a tangent: it bugs me that the default XDG directory structure doesn't fully match the standard Linux directory structure. What's with these inconsistent defaults?

XDG_DATA_HOME="$HOME/.local/share" # okay, reasonable
XDG_CONFIG_HOME="$HOME/.config" # ...uh, pardon?
XDG_STATE_HOME="$HOME/.local/state" # well at least it's in ~/.local
XDG_CACHE_HOME="$HOME/.cache" # ...but this one ain't; what in tarnation?

It'd make more sense to be consistent with how system-wide applications use /usr or /usr/local, like so:

XDG_DATA_HOME="$HOME/.local/share"
XDG_CONFIG_HOME="$HOME/.local/etc"
XDG_STATE_HOME="$HOME/.local/var/lib"
XDG_CACHE_HOME="$HOME/.local/var/cache"

This would make $XDG_(CONFIG|STATE|CACHE)_HOME consistent with $XDG_DATA_HOME, and also consistent with existing conventions around ~/.local/bin and ~/.local/lib.

The XDG spec ain't the only naughty naughty boy here, either. Flatpak puts all of its application data in ~/.var/app, whereas it'd make a lot more sense in ~/.local/var/lib/flatpak/app. And of course, the subject of Boxxy (and, as others mentioned, xdg-ninja) is the countless apps contributing further to the chaos.

Of course, all this would stop being an issue entirely if Linux would just embrace union mounts like Plan 9 did and overlay everything onto /bin, /lib, /share, /etc, and so on. Hell, if I were the not-so-benevolent dictator for life of the Linux ecosystem I'd take the opportunity to rename all those weird UNIX™ vestiges, too, like /etc→/conf and /var→/data - but if we're gonna hang on to those vestiges, the least XDG could do is encourage consistency with them.

Maybe I just need to make my own distro and finally say goodbye to what little remains of my sanity.
ChatGPT does just fine with math. I wasn't joking...
So you'll take your arguments and go home, and not even try to convince me otherwise and potentially win me over with your candor and intellect and personality?

That seems like the problem with politics as a whole these days.
Incidentally, if you root your tablet you can just change the build.MODEL to "MyAir5" and everything will work on a third party tablet.
That account was automatically flagged for spam and then reinstated.

Even if it wasn't, censorship by an individual or a company is not a crime, are you confused by the first amendment which is a restriction on the government?

X or Musk are not the government.
Unfortunately, being a censorious dipshit is a thoroughly bipartisan pasttime.

Personally, I believe the Democrats to be less strident in their efforts to be censorious dipshits, though I have to admit that the Republicans may prove to be the safer option... by virtue of being unable to get anything, which would include destroying First Amendment rights, done.
I was wondering a while back if a tool like this existed. Good job!
> Reminds me how, in USA, it’s the only civilized nation I’ve been to where you must have a prescription to purchase contacts and glasses

Anecdotally this is far from true. Canada, Australia, the Netherlands, and the UK for example require a prescription for anything more complicated than reading glasses.

There are plenty of reasons why, mostly summed up by your comment about “whatever magnification you need” - eyeglasses for distance vision are infinitely more complex than “magnification” and if you’re buying anything other than reading glasses without a proper exam and matched lenses, you’re doing yourself harm.

Unless of course you are talking about reading glasses, in which case you’re also wrong, as you can get those for a couple of bucks pretty much anywhere in the US with no prescription.
Best way to use a URL shortener for my site
Have an MVP for a particular use case that we're building and we expect to have it all done by around the end of the year. One service that we provide can allow users to share something to others. The way we are generating the link to share right now generates very long urls since we are storing some images on Firebase and when sharing a combination of those we are combining those urls to create a unique sharing link. Is there some smarter way we can use to shorten the links here?

If not, and we end up using a url shortening service, is the best way to self host our own service (we currently use mongoDB for our application and can theoretically do it) or to use an existing service? If existing service, some recommendations would be helpful.
I mean... Brazil's a sovereign country, so whatever crime Brazil decides they did?

The law's about power, not rationality.
Oh! yes.. branding can be removed but there is an additional one-time fee for it. ($100)
Here's the test for experienced engineers to see if the LLM hype is bullshit or not -- use cursor with Claude Sonnet. Build an app in a programming language you don't know at all. Don't stop prompting until you build it.
The article doesn't mention OpenStack at all but apparently it's still going: https://www.theregister.com/2024/08/28/geico_vmware_openstac...

Gaia-X appears to have delivered nothing useful. Related newer rant: https://berthub.eu/articles/posts/gaia-x-is-an-expensive-dis...
Smoking also has a history stretching back hundreds or probably thousands of years. That doesn't make it a good idea.
> But there are both in-depth studies and anecdotal evidence that suggest hate speech has been growing under Mr Musk's tenure.

> Several fringe characters that were banned under the previous management have been reinstated.

> They include Andrew Anglin, founder of the neo-Nazi Daily Stormer website, and Liz Crokin, one of the biggest propagators of the QAnon conspiracy theory.

From that same hilarious article.
> Or is pizza somehow unique in being a food that wants to be kept warm?

This comes off as rude and dismissive. Do you really think all those people and companies involved in the multi-billion-dollar pizza industry for the past several decades are using specialized tools just because they're dumber-than-you?

> what makes them special compared to a bag with insulation to keep eg Chinese food warm?

The difference between them and a general insulated sack? I'm no sales-engineer, but perhaps:

1. Moisture vs insulation balance. Your mushroom-chicken can handle marinading in its own steam for quite a while without much ill-effect, but customers complain when their pizza arrives "soggy", so there needs to be some kind of venting that doesn't compromise the insulation too badly.

2. Form factor. Pizzas have a distinct shape, you can't just shove them into the same bags that'll take your disposable clamshell of chow mein. The insulating container needs to fit around the disposable cardboard one, and without slack which could allow pizzas to slide around enough to build up momentum and "slosh" the toppings to one side.

3. Stackability. whether inside one set of insulation or between multiple sets--at least if you want to deliver more than one pizza at a time.
TP-Link Breaks $100 Price Barrier with Its New Wi-Fi 7 Router
Agreed, a lot of this 'empathy' is largely naivete, 48% of New Yorkers aren't so poor as to be unable to pay for the bus. Most of them are anti-social or lacking in a sense of duty towards the commons, making the fare free would not make them suddenly feel a sense of duty, they'd just become even more brazen in abusing the infrastructure.
The Python steering committee also threw the kitchen sink of accusations at him. IMO it speaks to character when you throw arguments like an adversarial lawyer. Not the kind of person you want to be around for work or life.
The inspections themselves here are reasonably priced, but it’s still annoying to deal with the city because they operate in 1995. There’s no portal for scheduling inspections for homeowners, you have to call them. They don’t tell you when they will show up on the day they will perform them, so you have to be available at home from 7-17 ready to instantly answer the door at a moments notice the second they knock or you will miss them and have to reschedule

The pricing is reasonable enough - it’s cheap enough to actually be worthwhile to do several things yourself that normally you’d have to pay a contractor for. I did it when I ran some electrical conduit to my garage to add a few 120V receptacles in there.

My general rule of thumb is also I won’t touch gas. But also anything like plumbing that is INSIDE walls I usually am looking to have a professional handle as well. It’s harder to fix knucklehead DIY mistakes when they are covered up behind drywall.

It does make me want more plumbing setups like I’ve seen in Europe. When I lived in Sweden I loved for instance that a lot of bathroom plumbing is completely exposed, so DIY’ing plumbing work is actually pretty accessible. Here where you have to dig into the walls to get at it makes it much less appealing since not only do you have to be a a decent plumber you also have to be a decent drywall person as well.
Missing AfterStep from back in the day.
> If I go to a coach to help me with running faster their advice won’t be “completely wrong” — it will be “by and large” correct.

Nope. Unless they've been vetted, their advice is rarely better than random. And, even if they've been vetted unless they're biomechanicists, they often have these totally weird misconceptions about some specific thing.

See: baseball pitching. Practically everything about pitching below the major leagues was detrimental to pitchers (and even the major leagues had lots of misconceptions) until the scientists got involved.

What disguises this in sports is that consistency wins out over correctness until you reach the very, very highest levels. The problem is that it is almost impossible to adjust to "correct" after 10+ years of doing it wrong. So, what happens is that those doing it "correct" move on to the next layer while those doing it "incorrect" get left behind.
> On the right today is Idaho with their new book banning law prohibiting minors from accessing books with LGBTQ+ themes (regardless of whether there was any sex or not).

This is misleading. It's against anything pornographic being made accessible in schools / to people under 18 years old, LGBT or otherwise. "Homosexuality" is mentioned only once:

> 3. "Sexual conduct" means any act of masturbation, homosexuality, sexual intercourse, or physical contact with a person's clothed or unclothed genitals, pubic area, buttocks or, if such person be a female, the breast.

In a section that's 11 points long. Besides which, this whole section already existed, it was just amended recently and this part I quoted wasn't changed.
In line with the trends, as the grandparent said. People who claim tolerance are intolerant
What exactly does this have to do with the Plex media server program?
Here's a test for experienced engineers to see if the LLM hype is bs or not --

1. Use cursor with Claude Sonnet

2. Pick a programming language you don't know at all

3. Build an app in that language prompting only, don't stop prompting until you've run it successfully
(replying to myself)

I ran a quick, non-scientific Python script on my Macbook M2 using local Postgres and SQLite installs with no tuning.

It does 200 simple selects, after inserting random data, to match the article's "200 queries to build one web page".

(We're mostly worrying about real-world latency here, so I don't think the exact details of the simple queries matter. I ran it a few times to check that the values don't change drastically between runs.)

SQLite:
Query Times:
Min: 0.007 ms
Max: 0.031 ms
Mean: 0.007 ms
Median: 0.007 ms
Total for 200 queries: 1.126 ms

PostgreSQL:
Query Times:
Min: 0.023 ms
Max: 0.170 ms
Mean: 0.028 ms
Median: 0.026 ms
Total for 200 queries: 4.361 ms

(Again, this is very quick and non-optimised, so I wouldn't take the measured differences too seriously)

I've seen typical individual query latency of 4ms in the past when running DBs on separate machines, hence 200 queries would add almost an entire second to the page load.

But this is 4.3ms total, which sounds reasonable enough for most systems I've built.

A single non-trivial query required for page load could add more time than this entire latency overhead. So I'd probably pick DBs based on factors other than latency in most cases.
Genuine question: why does being productive matter on a off day? Isn't an off day ones body's way of telling that it's need something else not what the mind conjures up randomly or something that is instilled in the subconscious through cultural or personal values?
Poke: setting a hardware memory address directly from BASIC. Those were the days.
What highly rarefied air source are you pulling that number from?

The 7-day MetroCard (for unlimited rides) costs $34, which comes out to $4.85 per day, or $6.80 per working day -- closer to 40 min of work per day (after taxes).
Mind you these people are likely paying half their income on rent at that wage, and a very significant chunk of what's left just on food and other necessities.

In other words - 4x your estimate. (BTW if you work 40 hours per week, or even 25 per week you do not qualify for the subsidized fares program).

This is real money to them. If you don't understand this (or you do in principle, but can't be bothered to get your math ballpark correct) then you have no business chiding them for not pulling their weight.
Oh wow, that is crazy! That sounds awesome so please still write it up and I will link. myreal.name@gmail
How good is the on/off switch though?
There are dozens of us side-hides! Dozens!
Oh, and you just need one of these and a TTL to RS422 converter off aliexpress to replicate the interface:

https://www.aliexpress.com/item/1005005918675239.html

The connectors on the small RJ45 daughter board are JST-SH 1.0

The yellow lead puts out 4.2v to replicate a Li-Ion battery (as far as I can tell). You can ignore this.

Red is positive

Black is negative

Green is usb d+

Blue is usb d-
Are 48% of the ~1.4 million people who use NYC busses so poor as to be unable to afford to pay the bus fare?

https://new.mta.info/agency/new-york-city-transit/subway-bus...
There's an easy hack for the contact lens (and maybe glasses?) situation. There is a consumer protection law meant to ensure eye doctors can't stop you from using any retailer you want (otherwise they'd essentially make themselves your retailer), and it works like this:

You place an order with the retailer (online retailers typically allow you to simply type in your prescription values when adding lenses to your online cart; you don't need to show an official written prescription) and specify your doctor's name and phone number. Upon receiving your order, the retailer must call the doctor to see whether the doctor objects (invalid prescription). The retailer is to ship the order only if there is no objection (including no response at all) within 8 business hours. So just give the retailer the name and number of someone who won't immediately object, which is quite easy (e.g. a permanently closed office).

Of course, you need a refraction to know your prescription values. But once that's done, if your vision doesn't change over time, this allows you to ignore the expiration date of the prescription.
wish there was an open-source aircon, and heater, and microwave, and so on,
Skip is a locally installed and run dev tool. It is infinitely scalable! :)
In King County, buses lost -a lot- of riders when COVID appeared. And that ridership hasn't rebounded yet. At non-peak times, it's maybe 1/3. (And that's at 15 minute intervals ... a -lot less- frequent that New Yorkers expect [Youtube] ). So yeah, a high tolerance for freeriders should prevail below 1/2 loads.

Also there a lot of new drivers these days ... there's more than enough for them to learn and watch ... policing should be low priority. Kids (IIRC) are free-riding anyway.
Super fun read. Reminds me of the old software cracking days… totally appreciate you sharing it, even though i likely will never have one of those AC units.
I wrote loads of SQLs at the beginning of my career with focus on performance tuning and worked with ORMs much later - so it was the other way round for me. For some use cases, ORMs can indeed save a bunch of effort - if I have to do a straightforward join with a simple filter condition, it is orders of magnitude simpler to use the ORM. The caveat is to verify the SQL being executed (most frameworks provide features to log the SQL) to ensure that it is what is expected. However, if you are doing complex connection, direct SQL would be the best choice - it is deterministic and you can tune it perfectly for what you need.

As with most things, it is a balance.
I've been following PRQL for some time now since it first got good traction on HN and I like it a lot, but I'm really hoping this pipe syntax from Google takes off for a couple of reasons:

1. Similar to what you mention, while I think PRQL is pretty easy to learn if you know SQL, it still "feels" like a brand new language. This piped SQL syntax immediately felt awesome to me - it mapped how my brain likes to think about queries (essentially putting data through a chain of sieves and transforms), but all my knowledge of SQL felt like it just transferred over as-is.

2. I feel like I'm old enough now to know that the most critical thing for adoption of new technologies that are incremental improvements over existing technologies is to make the upgrade path as easy as possible. I shouldn't have to overhaul everything at once, but I just want to be able to take in small pieces a chunk at a time. While not 100% the same thing, if you look at the famously abysmal uptake of things like IPv6 and the pain it takes to use ES module-only distributions from NPM, the biggest pain point was these technologies made you do "all or nothing" migrations - they didn't have an easy, simple way to get from point A to point B. The thing I like about this piped SQL syntax is that in a large, existing code base I could easily just start adding this in new queries, but I wouldn't really feel the need to overhaul everything at once. With PRQL I'd feel a lot less enthusiastic about using that in existing projects where I'd have a mix of SQL and PRQL.
Note: algeria 1830s
https://baheyeldin.com/writings/culture/how-the-dutch-got-th...

Thanks for application of irony to a thread about iron laws! Led me to the “unnamed” Ping-Pong Lemma, a great counterexample!

Vespasian was, apparently, more inconsistent:
https://sci-hub.wf/10.2307/1192680

(Im guessing he was as aware as MAA of the burdens of office)

Hopefully we can return to the formalization of Nietzsche/Greco-Roman ethics/(New) systems of survival soon. State of my art, how to extend Boyd’s Ping-Pong Lemma* to Rao’s SoS (assuming it already works in JJ’s system)

Maybe the eternal Culture War is indeed the Russell one (Banks’ having his Culture win the Mandate of H) . Hey, JAW was concerned too, we are now on the same hunt as the Masters?

https://johnhorgan.org/cross-check/physicist-john-wheeler-an...

https://mindmatters.ai/2021/05/it-from-bit-what-did-john-arc...

*the same old, but generalizing boss to adversaries, also noting in passing parallelism of your justice-prudence to guardian/commerce, so temperance-fortitude maps to Blue/Red hypernormal/weirdo???
https://en.wikiquote.org/wiki/John_Boyd

Front page activity indicates that cpython is becoming hypernormal ;) (even if GvR as a concept remains a Wojak)
Thinkbuddy AI – Lifetime Access to GPT4,Claude,Gemini and More but for Mac Only