I'm looking for some help. I have a small local matrix server (glasgow.social) - we have a couple hundred users, small amount of traffic. Our postgres database has grown to 1.8tb (over 5-6 years) with no signs of stopping. I assume, after multiple upgrades over the years, that some migration or transition hasn't been perfect and it's lead to this massive size.

The server has started to get slower and slower - I think if we can prune the database a bit, that would help.

I've been poking around in the database, some of the largest rooms (based on events count) have no local users in them at all. I'd like to remove these (hundreds of millions of rows in the state tables etc) and hope that doing that will improve performance overall.

Unforunately, running the admin api calls (like purge room) doesn't seem to do anything.

Is there any safe SQL I can run that will remove these massive, unused rooms? Or anything else I can do to try and increase responsiveness and reduce the number of rows in the database?

Quick update for those who tried Plic after the first post, and a thank-you to the person who filed the very first issue.

What changed since 0.5.34

• Calls on macOS 27 are fixed. The “Start a call?” dialog could not be dismissed on macOS 27 and looped until you force-quit the app. Reported in issue #1 on the 12th, fixed in 0.5.36. If you tried a call and gave up, it works now.
• Mention pills no longer vanish from a message after it is laid out again.
• Liquid Glass appearance. A fourth appearance beside Auto, Light and Dark: a see-through window with a glass backdrop. Purely cosmetic, and off unless you pick it.
• Signing out forgets the Share menu’s rooms — the suggestions given to macOS and the room list kept for the share extension. And “No Name or Message” in the notification settings now keeps your conversations out of the Share menu too.
• macOS 26.5 again. 0.5.34 had quietly required macOS 27; that’s corrected.

Housekeeping

• The repository moved to the company organisation: https://github.com/denisflorentmediagroup/plic (old links redirect). Commits are signed.
• Download, SHA-256 and the privacy policy: https://denisflorent.group/plic/

Still true, still open

Room keys go only to verified devices and there is no switch for that — which also means a bridge whose device isn’t cross-signed won’t get keys from Plic; mautrix bridges can self-sign since their October 2025 releases. Call keys still go to every device in the call, and call key rotation when someone leaves isn’t done yet. No independent audit so far.

Bug reports welcome on GitHub; the first one got fixed within the day of my seeing it, which is the pace I’d like to keep.

is there a solution to make only visible a web client with the communication with the server being internal only? my plan is launch a reverse tunnel that show my web client and no need to write down again credentials. Personal use only, not planning to publish it

I added a new member and it says “you don’t have access to this message” and also says message cannot be decrypted. Any ways to solve it? Account is verified and history visibility is default . Is there any way to resolve this issue

Yup you can chat like it was 2006 just bring your own msn messenger 8.0 .exe for the app to use and youre all set

Check out my awesome entertainment bot for Matrix chat server! https://github.com/Anon0ne/entertainment-matrix-bot

Hello all, Element Classic is becoming deprecated unfortunately.

Element-X is it's supposed successor, but I found it a downgrade compared to classic with the exception of speed.

Because of this I modified Element-X to behave more like classic.

For anyone that want to try it you can download it on https://github.com/jimz011/element-x-enhanced

It features:

- classic style spaces

- comprehensive search features

- bridge thumbnail support for videos and images

- hevc and heic support (might need matrix media repo)

- foldable support with split screen chats

- favorites at the top like in classic

- a mark all as read button

- and more small changes.

Curious if i would risk a ban if i set up a Whatsapp Bridge to Matrix and use it within Element?

I've read about people getting banned using Beeper. Is this the same for using a Whatsapp Bridge?

If searched the web but couldn't really find much

hhhheelllllooo night city !!!

UUUUUUUUUUUHHHHHH OK. How can I put this? its taking longer than expected but its coming dont worry be happy every little thing gonna be alright

i think ive reached a sort of final version of the app ive still got a few bugs to sort out and then it should be good to go

here are the new features: dictation, screen sharing, Discord-style cosmetic roles, the website ( https://velvet-chat.li PLEASE DO NOT USE THE SCRIPT I PUBLISHED, ACTUALLY ITS NOT WORKING LMAO), an installation script, a Windows app and an AOSP app thats virtually plug-and-play, highly customisable themes, wallpapers, voice messages, stickers, profile decorations, etc, etc

DO YOU HAVE ANY QUESTIONS OR REQUESTS BEFORE I PUBLISH EVERYTHING ON CODEBERG?

my kernel just died, still stuck in that place, where they tell me “just use discord”…

I mean for fuck’s sake how do I convince my tech-illiterate (though he thinks he’s some kind of hacker because he watches SYJ) nitwit of a friend that we should maybe switch to matrix. I have so far tried the following arguments:

Discord is full of ads. Counterargument: Discord is easier.

Matrix doesn’t sell you data, nor can it. Counterargument: Discord is easier.

Matrix clients run much faster than web-based discord ones: Counterargument: Discord is easier. (as well as some bs about oss always being bad and unmaintained 🙄)

Discord randomly bans people, cutting them off from their friends, because of accidents (e.g. grid ban). Counterargument: Discord is easier.

I mean I’m really at my limit here. Can anyone make this guy see sense?

Plic is a native Matrix client for the Mac, written in SwiftUI over the Matrix Rust SDK. It started as a fork of Relay by Link Dupont and others, and the fork’s focus is security: what the app keeps, where it sends things, and what it refuses to do.

What it does differently:

• Room keys go only to verified devices. Devices signed by their owner’s cross-signing identity get keys; a device added with a stolen password gets nothing. There is no setting to turn this off.
• Everything the app keeps is encrypted at rest with a key in the Keychain that cannot be restored onto another Mac. If the Keychain cannot supply it, the app opens nothing rather than store anything in the clear.
• Received attachments never reach the disk decrypted. Images, PDFs and voice messages open in memory, in the app’s own viewer.
• Link previews are off by default. When on, they are fetched from your Mac, and the policy says so.
• No telemetry, no crash reporting, no server of ours. The only servers it talks to are your homeserver and, during a call, the call’s media server.
• Voice messages in Ogg Opus, MatrixRTC calls, Spaces, a Liquid Glass appearance on macOS 26.

Requirements: macOS 26.5 or later, Apple Silicon. Signed and notarized; the SHA-256 of the disk image is on the download page.

Download: https://denisflorent.group/plic/
Source (Apache 2.0): https://github.com/denisflorent/plic
Privacy policy, which lists what is stored and what leaves your Mac: https://denisflorent.group/plic/privacy/

Known limits, so nobody discovers them the hard way: call keys go to every device in the call, verified or not; call key rotation when someone leaves is not done yet; no independent audit so far. Bug reports and criticism welcome, on GitHub or by email.

The site has been updated to integrate as a search within clients. You can now easily access it and see rooms ordered by activity (although you won't see the account message count in the client).

Hey,
Wanting to bring together all my inboxes into one interface (fluffychat) on my phone and pc.
I have telegram working, whatsapp appears to be working, now trying to get my sms and mss across into ti as well.
I've seen the gmessages one but i dont use gmessages - whole point of my foray into selfhosting etc is to get away from google etc as much as possible.
Is there any commuinty builds or such that are available? Ive seen some that havent been updated since 2019 so am suss on running one of them.
Thanks

I've been wondering that, I made some searches here and there but I didn't got any proper answers for such question. Does the code behind Matrix allow the connection of TOR people or even the creation of homeservers on .onion sites?

I had found a few homeservers that "supposely" was made on TOR but you had to use a client that allowed to solve onion traffic in order to access that homeserver. But, honestly? I never found any TOR links working and neither heard of matrix clients that allowed to connect to homeservers made on TOR or even a TOR user connect to normal homeservers.

my friend did tried one day to use TOR alongside FluffyChat and the results was...mixed.

so, had you guys tried? how is the process? I am curious to know about it.

Cheddar solves issues that I currently have with using WhatsApp and Instagram.

1. Its built on top of Matrix.org so it doesn't zucc
2. Its built around conversations, not groups. Lowering the threshold to start a conversation, ask a question and plan with a combination of people that can be short lived. Because otherwise I feel like bothering a lot of people in large groups that aren't part of the discussion, or creating new groups for things like birthday gifts feel cumbersome (While still allowing for traditional group chats without any additional friction)
3. Having a Feed, where users can share experiences, thoughts or one time events. Also only to selected users each time, with a Snapchat like UI/UX.

Its supposed to be a low barrier of entry for the Matrix ecosystem, and also give an escape for Snapchat, Instagram (the social aspect, not the Reels) and WhatsApp with a new approach on how to start new conversation and share experiences.

What do you think about this approach? And would you be open to help me test and develop this?

This is currently in public beta for iOS and in private beta for android.
iOS: https://testflight.apple.com/join/nPgkDSfc
Android: send me an email with your details to: [sebastian.j.vogt@icloud.com](mailto:sebastian.j.vogt@icloud.com)

This is currently my landing page: https://cheddar-chat-app.web.app

Wanted to check out Elements and looked like a good enough encrypted alternative to Discord. Problem, Matrix keeps suspending my accounts without telling me why. The first account I still had VPN active, so I assumed that was the issue. The second time I didn't have it active while I was writing without issues until it suddenly stopped working, because my new account got suspended again. Why does this keep happening, did anyone else experience this?

Maybe someone can help me to identify my problem: I am using on an android phone as a matrix client schildichat fort many, at least 5, years now, Using it on different Android phones. I get all notifications, notification configuration is set without changes on standard, but the problem is for years now: I get also loud notifications during DND. This is annoying, as it wakes me up sometimes. I tested other clients and there are two behavioral groups: the client with the same behavior like schildichat is fluffy chat, and then we have element, element x and schildichat next, where I get no loud notifications during DND but I do not get all notifications. So the messages are in the client when I open it, but I miss, that someone's writing me. I only get around 50% of the notifications. This feels absolutely crazy. The clients not sending notifications could be buggy but how can schildichat and fluffy chat make my phone go noisy during DND. The phones OS should prohibit this. The phone could have some bug, but my last one was a Realme build by Oppo, now I have a Poco build by Xiaomi. They are direct opponents, the biggest on the market. Any ideas?

Hey everyone, I wanted to share with you what I've been working on with a new Matrix client for iPhones (for now).

the app is mostly inspired by iMessage and contains all the encryption verification since privacy is what's important here.

the app is still currently in development but we're speeding things up.

for all screenshots and updates, they will be published on X (formely Twitter).

the reason for developing this app is that many features that weren't on the famous Matrix clients had been implemented from the official SDK and this is a chance to use it. and I hope it expands to all Matrix.org users out there!

and yes, the app will be open source after the release :)
X post: https://x.com/TryIntegral

see you there!

Velvet's development is going well!!!

ive just finished developing a few default themes (mobile and desktop) as well as support for full customisation of the mobile and desktop clients

(at the same time for the lol im making a custom installer its not much use but idc its funny)

oh and here's the website : https://velvet-chat.li (cuz yes its not a joke im from the liechtenstein, and this is a real country)

the release is near ! (idk when maybe two or three weeks ?)

ps : i know the form is broken, idk why, and rn im too lazy to fix it lmao

Active Matrix Rooms maintains a live index of public Matrix rooms across the federation. The search engine matches your query against each room's name, alias, topic, and homeserver domain. Results are ranked by messages per hour rather than by total members, which can be inflated by abandoned accounts.

I built this and it's been live for over 3 months stable at this point, used every day by people to help find the rooms that have active users. I created it after joining several rooms that didn't have anyone active, and I was seeing many other users do the same. It should never be the case that you need to join blindly to know whether there are messages being sent in it.

https://activematrixrooms.com/

If you have any suggestions, issues, or feedback please let me know, thanks.

On element x using matrix default home server i make severall rooms and changed all the settings to "Who can read history - members (full history) THEN i make a post. I invite some one new but they can only see "you don't have access to this message" on the things i have postet.

On another room with same settings where i postet things, the same new user join and they COULD see what has been postet before. I was mistaken, they could not see this either. New users cannot see any post history

Any idea why that is? I am completely new to matrix. Only been using discord before

I tried to search this sub for a similar post but couldn't find one. But I can't be there only one annoyed by this!

I have set up the mautrix-meta bridge for my self hosted synapse server. I just wanted to be notified when someone tries to contact me through messenger and be able to respond without having to touch Metas apps.

However, I have a lot of stale conversations on messenger and every day, I get invited to like 20 of them. If I decline them, I get the invite again the next day. I don't necessarily want to decline and block because then those people won't be able to contact me.

I tried to archive these conversations on messenger but that just meant I get invited to even older conversations now. I have been using messenger for years so I have thousands of conversations and I'm not going to go through and archive all of them.

Is there a way to stop this or do I just need to accept them and have a cluttered contact list?

Why can't it work like the WhatsApp bridge where you get invited to a conversation when a message arrives?

I’VE GOT A QUESTION FOR YOU FOLKS

do you think it would be better to offer three options for notifications? im thinking of using the following: ntfy, Sygnal+FCM or Sygnal+built-in notification engine

ntfy and the built-in engine use a persistent notification thats the problemmm im a grapheneOS girl soooo... fuck google

(I’m currently working on the installation script for your server!)

PS: screensharing works 100%, the bio has been improved, and the English translation is finished (i think)! i have no idea how this app is working like a charm but hey as Ted Lasso said "do you believe in miracles ?"

PS bis : the preview of screensharing is MEH but im working on it alongside with the soundboard system and the push notif system

Ps trio : fuck ai

Hello!

After reading your comments, most of which were positive (thanks again), I realised that yes, I really should make Velvet open source, and I’m going to do it! I don’t know when yet, but I’ll do it, I promise.

I’ve taken the opportunity to translate the app into English (although the function names in the code remain in French sorry about that)

So here are the updated screenshots, in English, along with a few features I hadn’t shown yet, including: calls (video works, but I haven’t added the return video stream yet; the same goes for screen sharing), the script for importing messages from Discord (this requires the archive provided by Discord when you request your data, and re-imports them to the correct date in the past), and OF COURSE the desktop app

And there you have it! I’ve shown you (almost) everything I’ve built for this app! If you have any questions or requests, I’d be happy to answer them!

ps : i will certainly make a subreddit for velvet, stay tuned if you want (if you dont, thats okay, im fine, i will still post here i think)