I wouldn't know. I can't compare.
Wander
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.
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.
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 type of header linking to a javascript file of our choice which I could host myself so that there's no problems with same-origin policies.
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
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.