Using Binary Log with Appwrite

If I can remember correctly appwrite uses mariaDB as the underlying database. If so could I use mariaDB’s binary log to see database operations from appwrite?

on self-hosted, sure

It doesn’t work on the cloud managed side?

of course you won't have access to that

Why? All it is the raw data that’s going into the database. The only thing I can think is that every user shares the same database and so I can see their data. Is that the reason?

Because cloud is a managed service

what's your use case?

I created this real time query engine that uses a database’s write ahead log. I tried it on the self host and it works. I know supabase gives you the connection string for the underlying database on their cloud offerings. Does app write do the same or is that hidden too

Realtime query engine? If you want realtime, see https://appwrite.io/docs/apis/realtime.

No, we don't expose a connection string because Appwrite is an abstraction over the underlying technology and you're supposed to use Appwrite via the exposed SDKs and APIs

The real time in appwrite for the database is very limited. You can only listen for certain things. And you can’t filter such as with a join.

All I’m trying to do is see if appwrite was a candidate for my query engine. Since it uses mariaDB. Self host works, but since yall don’t expose anything on the cloud then it will not work.