GoToSocial | Mastodon Alternative

[robi]

Sounds like there could be a DB script action created that would be a bit more fine grained in modifying just the wanted (sub)domain references, instead of a whole DB drop.

Eventually becoming a migration script.

[murgero]

@robi Is that something upstream? Cause I can't find that.

[robi]

@murgero no, it was a suggestion, since so many people want TLD based Masto IDs yet still want to run the server on a subdomain.

[yusf]

So I can enter a terminal in the GTS container, access and drop its db from there?

[murgero]

@yusf you should be able to yes

[yusf]

@murgero It's not clear to me how to do that. I tried

ALTER DATABASE mydb CONNECTION LIMIT 0;
and

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'mydb';

but I only managed to lock myself out before being able to
DROP DATABASE mydb;

How should I drop the database? No matter what I try I get

ERROR: cannot drop the currently open database`

[murgero]

@yusf That's more a question for psql community. sadly IDK lol

[yusf]

imo this app is great for when not wanting the full resource hog that is the Mastodon package. @girish / @nebulon, are you interested in packaging?

[robi]

@yusf if you help get things started and moving forward packaging, others can contribute, then @girish will be able to add it to the app store for testing.

Otherwise the larger number of upvotes for other apps will likely take precedence.

[murgero]

@robi This app is packaged and tested working on my server, repo is ready - all it needs is tests which I cannot do right now but maybe this weekend or next.

[doodlemania2]

@murgero care to share?

[murgero]

@doodlemania2 Repo is in the original post

[archos]

If there was a Gotosocial on Cloudron it would be great. Minimal on resources and for individuals, it's definitely a better choice than Mastodon.

[archos]

What do you think, does nobody really want Gotosocial in Cloudron? I understand there are already three fediverse apps in the app store, but for individuals, gotosocial is much better than the big Mastodon.

[jdaviescoates]

@archos I think the more the merrier, but I'd rather see other fediverse apps in completely different categories that we haven't got covered at all yet, things like Mobilizon and Lemmy.

[murgero]

@archos my package on cloudron's gitlab server is federation ready afaik. But I haven't updated it in a long while, if you update it, it can be installed via cloudron CLI and be used just fine

[archos]

@murgero Thank you for your reply. I don't know if it would be beyond me.