goes looking for the issue

PostgresSQL has a limit of 65,535 parameters, so bulk inserts can fail with large datasets.

Hmm. I would believe that there are efficiency gains from doing one large insert rather than many small — like, there are probably optimizations one can take advantage of in rebuilding indexes — and it’d be nice for database users to have a way to leverage that.

On the other hand, I can also believe that DBMSes might hold locks while running a query, and permitting unbounded (or very large) size and complexity queries might create problems for concurrent users, as a lock might be held for a long time.

EDIT: Hmm. Lock granularity probably isn’t the issue:

https://stackoverflow.com/questions/758945/whats-the-fastest-way-to-do-a-bulk-insert-into-postgres

One way to speed things up is to explicitly perform multiple inserts or copy’s within a transaction (say 1000). Postgres’s default behavior is to commit after each statement, so by batching the commits, you can avoid some overhead. As the guide in Daniel’s answer says, you may have to disable autocommit for this to work. Also note the comment at the bottom that suggests increasing the size of the wal_buffers to 16 MB may also help.

is worth mentioning that the limit for how many inserts/copies you can add to the same transaction is likely much higher than anything you’ll attempt. You could add millions and millions of rows within the same transaction and not run into problems.

Might be concerns about how the query-processing code scales.

I can understand preferring scuba diving to doing interviews.

There’s room in the market for a huge number of regular games, but with live-service games, only a handful of winners can ever really succeed, creating an eye-watering risk profile for any new entrant into the market.

Ehhh. I mean, I agree with the general idea that there have been far too many live-service games chasing too few players, but I think that it’s probably possible to create lower-budget, niche-oriented live service games that appeal very strongly to a particular group rather than trying to get the whole world onboard.

That’s true of non-live-service games. I like some milsims, like Rule the Waves 3, that are just never going to become a mass market phenomenon. That’s fine, because that’s not what the publisher is aiming to do with the game, and has budgeted accordingly. They’re going after a particular group with specific interests.

But if you want to do that, that means that the interest in your niche by players has to be sufficient to overwhelm the fact that you aren’t going to have the playerbase and thus budget that a game with more general appeal would.

I doubt that it has anything to do with social preferences of anyone internal to payment processors. They won’t care.

Putting pressure on payment processors is a useful way to put pressure on any commercial service. The commercial service may operate in another country, but it needs the payment processor, and the payment processors don’t want to be ejected from countries. The payment processor can be a lever for laws passed elsewhere.

Consumer acceptability is key, acknowledges Mr Eiden. Most people don’t want to look like cyborgs: “We need to make our products actually look like existing eyewear.”

looks dubious

I can believe that most people want something that they consider stylish. However, I’m skeptical that most people specifically want something to look like existing stuff. Clothing has shifted a lot over the years and centuries; it’s not as if every person putting something on their body said “it has to look like the stuff that’s come before”, or present-day vision equipment would look like this:

Or this:

I’m assuming that you’re guessing “female”?

https://sexualityandthecity.com/2016/11/26/when-women-wanted-sex-much-more-than-men/

In the 1600s, a man named James Mattock was expelled from the First Church of Boston. His crime? It wasn’t using lewd language or smiling on the Sabbath or anything else that we might think the Puritans had disapproved of. Rather, James Mattock had refused to have sex with his wife for two years.

Looking at other sources, the expulsion was in 1640.

Oh, that’s interesting. Didn’t know about that.

I don’t think that there’s a way to list instances that a PieFed instance has defederated from, unlike Lemmy; while both have a list of instances at /instances, only Lemmy indicates which ones have been defederated from. It was a helpful tool to help me guess the sort of content an instance had.

Like:

https://lemmy.world/instances (under “Blocked Instances”)

https://piefed.world/instances

EDIT: It does show the last time that the instance sent data, and I guess you could sort of guess that if a large instance that probably has activity hasn’t sent data to the PieFed instance recently — like lemmygrad.ml and hexbear.net on piefed.world — then they’re probably defederated. But it doesn’t clearly indicate that this is the case, either.

ragingHungryPanda

And poop while I was doing it.

looks skeptical

Bamboo is pretty fibrous.

https://www.bostonmagazine.com/arts-entertainment/2016/10/18/puritans-and-sex-myth/

Debunking the Myth Surrounding Puritans and Sex

The Puritans weren’t prudish. In fact, they were passionate.

From the beginning, Puritans maintained sexual intercourse was necessary for procreation, but also asserted sex was an important way for couples to bond in a loving relationship.

“They talk about the duty to desire, that you’re supposed to engage in intercourse with your married partner and that this is good,” says Bremer. “There will actually be some people in early New England who are censured by the church because they have deprived their married partner of sex for three months or more and this is seen as bad.”

I don’t think the Puritans had any issue with pregnant people having sex.

Do you want the router to also be 10" rack-mountable? That seems like it’d be a big input into the hardware you get.

There’s a whole class of controllers, often called “fightsticks”, which have a full-size arcade-style joystick and a ton of buttons, to reproduce the feel of arcade fighting games.

https://www.reddit.com/r/fightsticks/

!fightsticks@lemmy.world (not very active)

https://www.amazon.com/Arcade-Sticks/s?k=Arcade+Sticks

Honestly, I feel like Morrowind is the title least in need of a remaster, as unlike later 3D titles, it has an open-source fan reimplementation of the engine, OpenMW, plus the fan updates of content.

searches for video of content

https://www.youtube.com/watch?v=qnvOy5Kw79Y

It looks like the OpenMW people are also working on a VR version.

“Fallout is the big one,” Middler claimed. “There are multiple Fallout projects in development, including, as far as I’m aware, that one that I’m sure you’re all wanting. It’s not far enough in along to say anything like ‘you’re going to be playing this game anytime soon’.”

Middler then joked, “Anyway, New Vegas 2, coming soon”. Is this the one we’re “all wanting”? Yes, but then also so is Fallout 3 Remastered, Fallout 5 and even a remake of Fallout 2. The fanbase is rabid, and hungry, and it’s been a long time since they’ve been fulfilled outside of Fallout 76 updates.

I mean, if Bethesda released all four of those, I’d buy all four.

I also don’t know what “Fallout 3 Remastered” entails, but if it means forward-porting the content to Starfield’s engine, that’d be pretty cool, though I do wonder how much effort will be required for mod-porting.

I love CDDA, but I don’t know if I’d call it light on a battery. It won’t hammer a GPU, but it actually does use a fair bit of CPU time for the simulation. Also, every time it redraws a frame, it does so via recomputing the world lighting and such, so it’s actually surprisingly heavyweight.

kagis

https://docs.luanti.org/for-players/controls/

Mobile devices (Android / iOS) #

Touchscreen

Display inventory: Press on-screen button in left lower corner

No; they’re similar games, but not protocol-compatible.

The Luanti client is a free download, though; Luanti is open-source.

There’s a similar, open-source game, Luanti (until recently, known as Minetest). It doesn’t have as many mods in 2025 as Minecraft does, but you might also enjoy it.

Elon Musk owns “only” 20% of Tesla

I don’t think it’s that high.

kagis

12.8%.

https://www.investopedia.com/articles/insights/052616/top-4-tesla-shareholders-tsla.asp

CEO Elon Musk is the largest shareholder, with 12.8% of the company’s equity as of Feb. 28, 2025.

Are you looking for specific values in some field in this table, or substrings in that field?

If specific values, I’d probably import the CSV file into a database with an column indexed on the value you care about.