Artist: https://www.deviantart.com/jay-shell

Even if it's just an archived version, someone somewhere will find utility in IT or coding advice posted over a century ago.

Subwoofer lullaby from Minecraft: https://youtu.be/Gpd85y_iTxY

Please note that I'm not referring to nostalgia from having played Minecraft a long time ago. The song felt this way since I heard it the first time.

Here's another song that has a similar feeling to it https://youtu.be/usjnkZVshLc

Is there such a concept as 'liminal music'?

It's not exactly the same as frisson, I think, but it still makes me feel goosebumps sometimes

Just like wikipedia, but instead of articles it's questions.

Potentially allow for several answers, but the main goal would be to create the best answer using the same criteria we use for wiki articles.

This new version introduced a system so that your instance stops sending out content to other instances that are supposedly dead / offline.

Unfortunately for some reason there's false positives. When I checked comparing the results from a curl request vs the information in our Lemmy database I found over 350+ false positives.

In the DB there is a table called "instance" which has a column called "updated". If the date on that column is older than 3 days, your server will stop sending any content to those instances.

For some reason I had entries that were dated as last being alive in July, while actually they were always up. If an entry is incorrect, you can fix it by manually using an update statement and adding today's date. If your instance is not too large you can safely update all entries to today's date and check if everything works as expected from then on any new content created on your instances.

The dead instances won't have an impact unless your instance is larger and generates more content, thus it might be easier to simply update all entries and have Lemmy believe they're all alive if you start noticing wonky behavior and don't want to check one by one.

If you don't know how to access the database run this command where domaincom is your instance domain without the dot.

1. docker exec -it domaincom_postgres_1 busybox /bin/sh

2. psql -U

(The default user is 'lemmy') You could technically do this is one single step, but it's good to know the command to get shell access to the container itself if you didn't know how to.

This should give you access to a postgres CLI interface. Use \c to connect, \dt to list tables and \d+ tablename to list table definition. You can also run SQL queries from there.

Try with this query: SELECT * from instance to list all instances and their updated date.

You can use other SQL queries to get better results or correct false positives. Just be careful with what you execute since there's no undo.

Artist: Keefur (https://www.furaffinity.net/view/9723391/)

Inspired by: https://yiffit.net/post/452096

It's called hypnopompic hallucination.

Unlike with sleep paralysis, you can move and talk while still seeing it and it will last a few seconds up to a minute which can seem like an eternity.

It usually fades as soon as you turn on the light, but for some very few people it does not and persists even after turning on the light.

Here's an example of someone who often experiences these and has started recording themselves: https://youtu.be/bEMGZNvETMQ

Why YSK: because it's very scary and unsettling when it happens and since you can move you don't believe it's sleep paralysis and can't explain it. This might explain many of the "monster or spirit at the foot of my bed" sightings that we often hear mentioned in horror podcasts.

Hello,

My goal is to make specific edits to Lemmy's default frontend. The big problem I'm facing is that the UI is running inside a docker container and is also written using inferno which seems to be transpiled / compiled into non-user-friendly js files.

My assumption here is that I'd have to download the source, edit it, compile and then host my own container.

I was wondering if anyone has done this and if there are any tips, pointers or guides that could be shared.

Thank you!

Why YSK: after yesterday's security incident many instances have reset the session tokens which your browser remembers. This is causing issues.

You need to clear cache / cookies / app storage, etc... to eliminate any login problems or problems staying logged in.

I've seen many posts mentioning this already.

I want to allow certain trusted users the ability to take down my lemmy instance or reboot it or x, y, z actions in case things go wrong or there is a security incident.

Ideally I would want to have some sort of admin interface that's secure and tested and allow these users to have some sort of login and from there have the ability to execute certain actions that could correspond to a "break glass in case of emergency" scenario.

I've been pointed at https://www.portainer.io/ but they seem to have a steep price for the limited use-case that I would be giving it.

I know about some admin interfaces like webmin, but I don't know which one allow you to create very restricted users or just give users the ability to execute some limited pre-defined commands.

Thank you <3