Oh I had to zoom in before I got hit. Hell no.

Oh yeah, apologies for the above comment. C# is definitely a good option, especially if you use windows and love messing around with the OS

I'm not sure I fully agree with that approach for most people since C++ resources and tools seem to not be the user friendliest but then again if it worked for you that is amazing.

Try "the Odin project", which has an amazingly active community.

But before you try too much, once you've learned to set up any programming tools, just use them to have fun. Find a way in which you can use programming in relation to your hobbies.

With JavaScript you can manipulate any webpage you see or create your own interactive webapp. Even if it's just a few ugly buttons and text fields, you could make an app that calculates good builds for a videogame you like, for example.

If you want to interact with a windows operating system you can't go wrong with C# using visual studio. This will literally allow you to manipulate files, folders or automate anything you want from the operating system.

Try to find something that is fun and just enjoy yourself with small apps before you try to go too fast.

Thanks! Of course you can feel some minor temperature change when pulling back the foreskin, but that's just the contrast. No idea if the base temperature feeling is different.

I wouldn't know. I can't compare.

Thank you <3 There's no rush, although I'm pretty excited about the potential!

Right now the blur is controlled via css. Disableblur is a theme that is set by default and which incorporates the css classes that override the default behavior. The problem is that blur is enabled again when a user chooses a different theme.

What I was thinking of doing was having a script that would fetch your preference from local storage and then dynamically change CSS. I agree to keep it light, but there's a lot of potential. Doing things serverside is possible, but I'd have to learn how to compile and dockerize from source, which might be complicated because the site is written in inferno and would also break future updates.

They're suing for not allowing the sale of refurbished articles, which was contrary to the agreement signed by the people who sold the refurbished articles.

Panem et circenses to calm the masses and also to improve search results for the term 'reddit'.

What I do is create a new live snapshot before doing any changes to the server. I don't use digitalocean, but I think their snapshots cost 6 cents per GB/month, and are only charged like that if you retain them the whole month.

If everything goes well after a change and you delete the snapshot a day or two later (or after the next backup), it's basically free or very cheap. I think it's just a minimum of $0.01 per snapshot.

Yes, let me logging to my server and try to retrieve the exact query I used. BRB

Edit: here it is, the table is actually called activity

DELETE FROM activity where published < '2023-06-27'; Just make sure to change the date to whatever you need. Leaving two weeks is more than enough to detect and refuse duplicates.

In order to get access to the database you should probably be able to run docker exec -it midwestsocial_postgres_1 busybox /bin/sh. And then access postgres with psql -U username, the default username is 'lemmy'.

Then connect to the database with \c lemmy

You can list tables with \dt and view definitions for each table with \d+ tablename. For example \d+ activity.

You can get some sample data from the table with select * from activity LIMIT 10; You'll see that the activity table holds activitypub logs and should be cleared out regularly as mentioned by dessalines in this post: https://github.com/LemmyNet/lemmy/issues/1133

Important

After deleting the entries (which could take some minutes depending on how much data it holds) you will not see a difference in the filesystem. The database keeps that freed up space for itself but you should see backups being much lighter and of course, the file system itself will stop growing so fare until it has reached the previous levels.

If you want to free up that space to the filesystem you need to do a "vacuum full" but that will require downtime and could take several minutes depending on the space that was used up and the space that is still free. It could take up to an hour. I haven't done this myself since backups have gone down in size and I don't need extra free space in the filesystem as long as I stop the database from growing out of control again.

Test:

Edit, by the way, good choice in loading only e621 sources. A potential vulnerability could have come from loading images from external non-trusted sources, but from checking the code and decoding the bookmarklet encoding everything checks out! Good work <3

Did you find a solution. The above comment with the database query should work. You can access the docker container where the database is running with docker exec -it instancedomain_postgres_1 busybox /bin/sh and then run psql -U databaseuser which by default is 'lemmy'.

Check docker ps to know the exact name of the postgres container which in your case likely is lemmytalungorg_postgres_1

I can imagine this being a problem for low effort youtube kid shows, like the ones that caused the whole elsagate controversy.

Thank you for sharing your art with us ^^. It is always a special moment when artists post their OC art on Yiffit.

Hello! Thank you a lot for this ^^

I'll give it a try in a moment. But before I do, can I propose something to you?

I noticed that I'm able to insert an arbitrary html header into lemmy-ui as part of the environment variables. This could include a

<script src="">

I have already started working on a script that creates a "unblur nsfw content" setting in the user's settings and stores the value in the browser's localstorage. This is just an example of the type of customization that could be done.

If you ever come up with any interesting "user scripts" for the lemmy ui, I might be able to include them into the site itself. I'm using greasemonkey for the development since it loads automatically every time you open a page and you can also do url filtering, but the idea is to insert the end scripts into the page itself (after publishing them for peer review).

So, if you ever come up with an interesting script idea, feel free to let me know or send me the result. You might also be interested in this lemmy communty: !plugins@sh.itjust.works

Yes, that might actually be the activitypub table in the database. You can safely delete older entries, like from two weeks ago or older. Otherwise it just keeps growing with the logs of all activitypub objects that the server has sent out received.

I don't think there's an easy way to "replay" them. But in theory, you should be able to take the entries in that table related to midwest social from any other instance and start broadcasting them anew. The remote instances will reject them because to them they are duplicates, but you would be able to recover lost content.

Now I realize this is far more complex, but in theory it should be possible to create a tool that does this specifically for these scenarios.

I'm sorry this happened to you :(

Anyway us other instances can help? We still have copies of the content (except for images).

We should also have the activitypub objects that we've received cached in our database.

Edit: it seems that my instance fetches the latest posts instead of using its cache when loading a midwest community. But still, we should have some content in the activitypub table.