I don't know how I missed this when it came out: https://en.wikipedia.org/wiki/Stoner_Cats

Stoner Cats is a cartoon that stars Mila Kunis, Ashton Kutcher and Chris Rock as cats that use medical marijuana.[1] The show also stars Jane Fonda, Seth MacFarlane, and Vitalik Buterin with guests Dax Shepard, Gary Vaynerchuk, and Michael Bublé. The producers were fined by the US Securities and Exchange Commission because they sold unregistered NFTs as a means towards a pass to view the show

I'm routinely running into an issue where if I haven't used the app in a while (a few hours), it hangs trying to connect. I then force restart and it's fine.

I was running onto this on the play store version but I'm on 0.7.0-1 now and still seeing it regularly.

Known issue? Or any suggestions on how to debug?

If you're still going down there for lunch / shopping, even more reasons to stop.

OTTAWA — OTTAWA - Elections Canada says more than 68 per cent of eligible voters cast a ballot in the federal election -- more than 19.5 million people.

While this election was widely expected to see increased turnout, it did not surpass the record set in March 1958, when 79.4 per cent of eligible Canadians voted.

But the nearly 68.7 per cent turnout was the best since the 1993 federal election, which saw 69.6 per cent of eligible voters cast a ballot.

Elections Canada says early estimates indicate 11 million people voted at their polling station or in their long-term care facility on election day.

The agency says nearly 7.3 million Canadians voted at advance polls while 1.2 million voted by special ballot.

Elections Canada does not gather demographics data so it’s not clear which groups turned out to vote, but it says postelection surveys can show which groups faced barriers to voting and what can be done to address them in future elections.

The Liberal party ended the election with 43.7 per cent of the total vote and 169 seats, while the Conservative party secured 41.3 per cent of the vote and 144 seats.

The Bloc Quebecois and the NDP both took 6.3 per cent of the vote, and will hold 22 and seven seats, respectively.

cross-posted from: https://lemmy.ca/post/40761824

Sorry everyone I know how much you love the attention she gives you, but I've implemented some quick and dirty filtering for private messaging.

We now have the ability to automatically mark PM's as deleted or read, depending on content inside of them. If we accidentally filter something you legitimately wanted (ie, not Nicole) please let me know.

If any other instances would like to implement this, here's the code. Note that you'll need to set your hostname at the top here for some reason I haven't exactly identified.

SET lemmy.protocol_and_hostname = 'https://lemmy.ca/';

CREATE TABLE private_message_filters (
    id SERIAL PRIMARY KEY,
    phrase TEXT NOT NULL,
    behavior VARCHAR(10) NOT NULL CHECK (behavior IN ('delete', 'mark_read'))
);

CREATE OR REPLACE FUNCTION filter_private_messages()
RETURNS trigger AS $$
DECLARE
    banned_phrase_record private_message_filters%ROWTYPE;
BEGIN
    FOR banned_phrase_record IN 
        SELECT * FROM private_message_filters
    LOOP
        IF LOWER(TRIM(NEW.content)) ILIKE '%' || LOWER(TRIM(banned_phrase_record.phrase)) || '%' THEN
            IF banned_phrase_record.behavior = 'delete' THEN
                NEW.deleted := true;
                RETURN NEW;
            ELSIF banned_phrase_record.behavior = 'mark_read' THEN
                NEW.read := true;
                RETURN NEW;
            END IF;
        END IF;
    END LOOP;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER trg_filter_private_messages
AFTER INSERT ON private_message
FOR EACH ROW
EXECUTE FUNCTION filter_private_messages();

To add filter words:

insert into private_message_filters (behavior, phrase) values ('delete', 'spamtestdelete');
insert into private_message_filters (behavior, phrase) values ('mark_read', 'spamtestread');

If you want to quickly disable / enable filtering while testing:

ALTER TABLE private_message DISABLE TRIGGER trg_filter_private_messages;
ALTER TABLE private_message ENABLE TRIGGER trg_filter_private_messages;

I'll leave it up to you to figure out what phrases to filter on. MAKE SURE YOU TEST. If there's an error, private messaging could break completely. You should not get an error message from the UI while sending a message with a banned word.

Edit: I like flamingos-cant's solution here better: https://lemmy.ca/post/40761824/15209462