Hi! If you need reliable canadian hosting for lemmy.ca let me know. I am a co-founder of a Canadian Cloud and I will be happy to provide the infra for free. We are happy to help canada going out of American Corporation. If you are interested, let me know!
No, I want to start exposing a grafana instance but for now I'm keeping this internal since it hits our live postgres.
The query if you want it is:
SELECT
DATE(published AT TIME ZONE 'UTC') AS date,
COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.ca')) AS lemmy_ca,
COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'sh.itjust.works')) AS sh_itjust_works,
COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.world')) AS lemmy_world,
COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'lemmy.dbzer0.com')) AS dbzer0,
COUNT(*) FILTER (WHERE instance_id IN (SELECT id FROM instance WHERE domain = 'jlai.lu')) AS jlai_lu,
count(*) as all_lemmy
FROM person
GROUP BY 1
ORDER BY 1;
Or here's your instance overlayed with us to provide a comparison:
There's some Facebook 'buy Canadian' groups with over half a million people in - this server occasionally comes up there too when people are looking for Canadian hosted discussion sites to ditch big American tech like reddit or Facebook groups.
Doesn't the new server support at least 10x-100x the current capacity? I think it was a huge machine compared to the old one. I guess storage is separate.
That’s a lot of potential wiggle room. 92k to 920k potential registered users while currently LW has 174k, that’s one crazy hardware upgrade. The servers will become cheaper to run in the future as we put to use our economies of scale.
Do we? Because this feels to me like a ruling class problem. Labour class is a lot less affected, and our efforts are mostly helping the exact same set of oligarchs who are working both sides of the border.
former r/onguardforthee fan here ... I've been on Lemmy.ca now for over a year ... happy to see others are hopping on board and jumping off the burning train wreck
ADDITION TO MY ORIGINAL .... one thing we current users of Lemmy should point out to any new users that are joining Lemmy either here at Lemmy.ca or any other fediverse instance is to REMIND EVERYONE TO DONATE TO AND SUPPORT THE INSTANCE THEY ARE ON. It's great that all this stuff is free for us to use but there are people here who work to develop, maintain and upgrade the source software and there are groups of people who maintain and manage the instances that we all use. We can't expect all these people to work for free. Many of them may not mind working for free and they might even enjoy it but there will come times when they either can't do it any more or they just run out of money, resources and time and energy to manage things as they grow more and more popular. No one complains when things are working but everyone will scream and shout as soon as their instance fails for one reason or another. Everyone or as many people as possible should find a bit of money to support their instance or the developers. Even if everyone gave a dollar, that would add up to thousands. If we keep these instances and the people that work and maintain all this well funded then we can all be safe and secure from any corporate rot that might creep into our communities.
There isn’t room for multiple social media in my life and i will try with only Lemmy for a few months. I did came from r/BuyCanadian with curiosity more than the US boycott in mind. I plead guilty!
Likewise, but I still go to reddit via searches if the other results aren't helping me out. At this point it's more an act of desperation than desire, though.
Its a great time to join. I think many of us have been lurkers in reddit and now with the tides of change we need to also make Lemmy active, especially the Canadian sites
after seeing a thread on r/buycanadian saying “petition to rename the Americano, a Canadiano”
I knew the next step was to head over here & make an account lol
If you're talking coffee, Australia calls that a long black, though some are trying to import "americano" to mean "like a long black, but add the coffee before the water"
Ooo, there's a Canadian Rexit happening? Cool! I keep my Reddit usage much more focused on niche hobby communities now, and there's zero talk of Reddit politics on those yet, sadly.
I challenge every newbies to create 1-3 posts over the first 72 h here : what do you enjoy in social media usually? It doesn’t have to be perfectly new if it’s new on Lemmy: your favourite Reddit group isn’t represented here or silent for a while : show us a glimpse of what you like and see how much engagement you receive.
Feddit.uk are also using a nice opencollective funding model, so it seems like these projects are nicely decentivised against a rogue admin selling the domain or selling the actual server
Is there a problem using an email alias to sign up? I applied more than a week ago. I recognize it’s a lot of work but I was wondering if I had been accidentally been binned as a bot.