He’s not being run out of the project… yet. This is not a good direction, though. This comes across as the first link that’ll show up in a github gist of “What happened to Python?” in a few years. Hopefully not and it’s all just an automod mixup, but after the Tim Peters btfo, I know what I’d put my money on.
At this point if I feel like getting fancy with Pandas, I’d reach for Polars first. My experience with it so far has been great
I couldn’t view this with Firefox or Gnome. ImageMagick to the rescue, though:
convert https://pub-be81109990da4727bc7cd35aa531e6b2.r2.dev/weofihweiof.jpg meme.jpg
They’d have to have a democracy in order for it to be called a democracy
There’s various well-known tracking parameters that can be stripped, like UTM parameters. Stripping all query parameters would break a lot of sites, like anything in the vein of http://example.com/site.php?id=123
I’m too lazy to convert that by hand, but here’s what chatgpt converted that to for SQL, for the sake of discussion:
SELECT
a.id,
a.artist_name -- or whatever the name column is in the 'artists' table
FROM artists a
JOIN albums al ON a.id = al.artist_id
JOIN nominations n ON al.id = n.album_id -- assuming nominations are for albums
WHERE al.release_date BETWEEN '1990-01-01' AND '1999-12-31'
AND n.award = 'MTV' -- assuming there's a column that specifies the award name
AND n.won = FALSE
GROUP BY a.id, a.artist_name -- or whatever the name column is in the 'artists' table
ORDER BY COUNT(DISTINCT n.id) DESC, a.artist_name -- ordering by the number of nominations, then by artist name
LIMIT 10;
I like Django’s ORM just fine, but that SQL isn’t too bad (it’s also slightly different than your version though, but works fine as an example). I also like PyPika sometimes for building queries when I’m not using Django or SQLAlchemy, and here’s that version:
q = (
Query
.from_(artists)
.join(albums).on(artists.id == albums.artist_id)
.join(nominations).on(albums.id == nominations.album_id)
.select(artists.id, artists.artist_name) # assuming the column is named artist_name
.where(albums.release_date.between('1990-01-01', '1999-12-31'))
.where(nominations.award == 'MTV')
.where(nominations.won == False)
.groupby(artists.id, artists.artist_name)
.orderby(fn.Count(nominations.id).desc(), artists.artist_name)
.limit(10)
)
I think PyPika answers your concerns about
What if one method wants the result of that but only wants the artists’ names, but another one wanted additional or other fields?
It’s just regular Python code, same as the Django ORM.
I’m pretty excited about PRQL. If anything has a shot at replacing SQL, it’s something like this (taken from their FAQ):
PRQL is open. It’s not designed for a specific database. PRQL will always be fully open-source. There will never be a commercial product.
There’s a long road ahead of it to get serious about replacing SQL. Many places won’t touch it until there’s an ANSI standard and all that. But something built with those goals in mind actually might just do it.
I don’t think you really have a choice TBH. Trying to do something like that sounds like a world of pain, and a bunch of unidiomatic code. If you can’t actually support 4 to 10 languages, maybe you should cut back on which ones you support?
One interesting thing you could try if you really don’t want to cut back is to try having using an LLM to take your officially supported code and transliterate it to other languages. I haven’t tried it at this scale yet, but LLMs are generally pretty good at tasks like that. I suspect that would work better than whatever templating approach you’ve used before.
If neither of those approaches works, everything speaks C FFI, and Rust is a modern language that would work well for presenting a C FFI that the other languages can use. You’re probably not hot on the idea of rewriting your Go tests into another language, but I think that’s your only real option then.
Have you used either of them before and have opinions on them vs HA?
For mobile with fastmail, I use fairemail. Works great with it, and provides a nice merged view with my non-fastmail work emails.
Damn, that’s a great list. Most of what I’d recommend is in there, here’s a few more:
This site is specific to AWS, but you might find it helpful:
Looks like it got bought out by someone, so might be enshittified, but it’s worked nicely for me in the past.
Security is a gradient that depends on your threat model, etc, but unless you’re being targeted by a nation-state or something that should be plenty secure
I unfortunately can’t really offer much advice here. I configured Wireguard on my phone by essentially copy/pasting the configuration from my laptop and changing the values as necessary like the public key and client IP address. Turned it on, it activated VPN mode in Android and everything started working.
I guess make sure you haven’t mixed up your public/private keys, your server knows about the new device (and is restarted), and your phone is using the right IP address as basic troubleshooting steps.
I suppose there’s authority, consensus and tradition too
Those aren’t sources of knowledge. They can be a proxy for knowledge obtained through the scientific method. Crucially, you can fact-check them yourself, using the scientific method.
How did that authoritative source get their knowledge? If it wasn’t through the scientific method, then it’s not knowledge. So you can proxy your knowledge through someone else you trust that did the legwork of going through the scientific process, but that’s not another way of obtaining knowledge, it’s just the scientific process with extra steps.
Personal experience can also result in knowledge, through the use of the scientific method. You can drop an apple and see that it falls. That’s the observation part of the scientific method. You can go further and try to figure out why that happens, by using the scientific method yourself based on your personal observations of the apple.
There really isn’t another way. It’s the scientific method all the way down.
Yeah, you’ll also need to configure your server to whitelist your phone, and then everything should just work. And yeah, you should be able to just use the default deb package on bullseye.
Yeah, when you configure it, you essentially say “all traffic to 1.2.3.0/24 should go through this wireguard connection”. Then, your OS automagically knows “oh, this connection to 1.2.3.4 should go through Wireguard, and I’ll handle it like so”. You don’t have to configure any applications specifically, their network connections just get routed appropriately by your OS.
Wireguard might work well here. You’ll have to set it up on each device you want to have access your server, but I’m guessing that syncing only involves a handful of devices, which wouldn’t be bad.
Sorry, I should clarify I mean first chronologically, not in importance. As in, “here were the warning signs”. Also I’ll concede that this won’t be first chronologically either, it’ll be Guido stepping down as BDFL, and then the Tim Peters thing, then things like this.
To be fair, the comment had been moderated for like 4 days, and was only restored recently after people noticed. Hopefully somebody realized that it wasn’t a good look.