GoToSocial | Mastodon Alternative

[yusf]

@murgero So if I drop the table it just gets recreated?

I was also considering trying install to domain.tld, then move it to a subdomain.

[murgero]

@yusf You can't move domain once it's installed unless you drop the database it uses (see that same config for the creds, db name, etc)

be aware this will erase any user data on the instance.

But yes - it will recreate database and tables.

[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.