What is Hackers' Pub?

Hackers' Pub is a place for software engineers to share their knowledge and experience with each other. It's also an ActivityPub-enabled social network, so you can follow your favorite hackers in the fediverse and get their latest posts in your feed.

How to performantly bulk remove dormant users from a forum?

zipit @zipit@community.nodebb.org

<p>Hey everyone,</p> <p>I am trying to clean out our forum from dormant and spam users. We have roughly 60000 accounts (sic!) of which about 56000 are spam accounts with no posts at all.</p> <p>I have written a small Python script which reaches into our MongoDB database and identifies 'invalid' accounts over a handful criteria such as the user having no posts, URLs in the profile of the user and more. And I can quite accurately sort out spam from legit accounts. The problem is when I just delete these documents and their directly related documents (e.g., for <code>user:100</code> also <code>user:100:emails</code>, <code>user:100:settings</code>, ...) in the Mongo database, then I end up with an at first glance first glance functional NodeBB instance. But secondary data has not been updated as NodeBB does not seem to be very atomic. The users list on the dummy-forum now has for example countless empty pages, as the users are gone but something has not been updated which feeds that user list. I already rebuilt the forum, but this did not change anything.</p> <p>I also had a look at the WriteAPI. I did not (yet) get the bulk user account deletion to work, but when I use the endpoint <code>/api/v3/users/{uid}</code>, my script ends up like this: <code>Processing users: 1%| 320/56329 [11:13&lt;32:23:18, 2.08s/user]</code> I.e., it takes NodeBB about 2 seconds to delete a single user account. And in total this is then more than a day of processing time. I cannot be the first one with this problem, right? I did not find any solutions to this problem. I also found <code>/nodebb/src/api/users.js:processDeletion</code> and the lower level <code>nodebb/src/user/delete.js:User.deleteAccount</code>, but there is no clear path for me which database documents I have to delete and update.</p> <p>Cheers,<br /> zipit</p>

Read more →
0
0
0
0
0
0
0
0
0

:blobcatbongokeyboard: Jeju.Social 서버를 마스토돈 버전 4.4.1로 업그레이드했습니다. 특히 모바일에서 브라우저 환경이 많이 개선되었습니다. 모바일 앱에 문제가 있거나 혼란스럽다면 웹 브라우저 버전을 사용해 보세요.

:blobcatbongokeyboard: I upgraded the Jeju.Social server to Mastodon version 4.4.1. The browser experience has improved a lot, especially on mobile. If you're having trouble with your mobile app or are confused, give the web browser version a try.

0
0
1

"A decade ago, our own Ryan McCaffrey gave Alien: Isolation a 5.9 in his review, noting that, among other things, its genuine scares were “diluted by repetition and padding.” He wasn’t alone in that reaction, and other major review outlets gave it similar scores for similar reasons. Today, on its 10th anniversary, I’m here to (once again) respectfully dissent and offer a different perspective: I love Alien: Isolation. It is one of my favourite games of all time. And, even after all these years, it remains a singular, terrifying triumph." HARD AGREE. Loved this game so much. A masterpiece in its genre without a doubt. ign.com/articles/in-defence-of

0
1
0
0
0
0
0
0
0
1
0
0

One more time for the people in the back: every conversation about "AI" should begin and end with its environmental impacts:

"We tend to think of the cloud as something invisible - floating above us in the digital ether. But the reality is very physical.

The cloud lives in over 10,000 data centres around the world, most of them located in the US, followed by the UK and Germany.

Many centres use evaporative cooling systems, where water absorbs heat and evaporates - similar to how sweat wicks away heat from our bodies. On hot days, a single facility can use millions of gallons.

One study estimates that AI-driven data centres could consume 1.7 trillion gallons of water globally by 2027."

bbc.com/news/articles/cy8gy7lv

0
0
0
1
0
0
0
0
0
0
1
0
1
0
0
0
1
1

"Benchmarked against real-world case records published each week in the New England Journal of Medicine, we show that the Microsoft AI Diagnostic Orchestrator (MAI-DxO) correctly diagnoses up to 85% of NEJM case proceedings, a rate more than four times higher than a group of experienced physicians. MAI-DxO also gets to the correct diagnosis more cost-effectively than physicians."
microsoft.ai/new/the-path-to-m

How the Microsoft AI Diagnostic Orchestrator (MAI-DxO) worksHow the Microsoft AI Diagnostic Orchestrator (MAI-DxO) compares to other AI
0
0

Do any of you really like pictures of electron microscopes? On my last live stream, I took over 350 of them! Check them all out my new site bellow↓

I built a static site generator that took the pictures I captured and edited during the livestream and compiled them into galleries on the static site. You can download full-resolution originals, all images CC-BY-SA, so feel free to use them.

imagestream.nanographs.io/albu

Photo of Zeiss Merlin electron microscope with a Zeiss Sigma electron microscope in the background. The column covers are removed, and there is some colored lighting. Picture of Zeiss Merlin electron microscope from the front with a TV in the background with the Nanograph logo on it. Picture of Zeiss Mirrors on an electron microscope upper column with panels removed and some aesthetic bright white lighting. Photo of Zeiss Merlin electron microscope with some purple lighting. Upper column section panels removed.

Recording this much information about the microscope on stream was a ton of fun, and I look forward to doing more of it. I pretty much only got through the upper column section. There's still a ton more of the microscope to be exploring on future streams as I inspect it and get ready to bring it online.

Picture of the column focusing on the alignment hardware. Macro picture of resistors on an Optics interface board. Macro picture of a PCB Flex Optics Interface Board. Picture of the overall optics interface board on the column.
0

このアカウントのFF内には関係ない愚痴

ちょーーっとだけブーメランな気もするけど愚痴るね
手を差し伸べてそれを無視されたこっちの身にもなってほしいな、と

全部無視して死にたい死にたいってSNSにフォロ限で書き込んで、一体お前は何がしたいの?何が求めてるの?になってる

1
0
0
0
0
0