jjsaunier
commented
9 years ago Your feedback on "first hand usage" is very interesting. I took over the development of my side because it is not actively maintained (https://github.com/GeniusesOfSymfony/WebSocketBundle). And I have planed to improve the docs and your questions help to know what is must be improved :)
So, for your first question "What database schema would you suggest?" for your example 2 tables chat_messages and chat_room are enought where chat_message have many to one relationship to chat_room
chat_room:
name (human friendly, name of room)
canonical_name (system friendly, like a DSN)
chat_message:
user_id (fk 1 - n)
room_id (fk 1 - n)
created_at (datetime)
internal (bool, sended by internal bot ?, for your case it may be useless)
centent (textaera or varchar, content of your message) This is a very simple schema, adapt according to your needs ofc.
Second question How would I manage the "topics"? and also "how do I manage the name of the channel " :
In clank approach, you register a topic against a channel definition.
e.g :
Some channels definitions:
- chat/room-81111
- chat/room-12235
- chat2/room-25653
- chat3/room-14565
To handle chat/room-81111, chat/room-12235 channels, you must register your topic name as "chat" To handle chat2/room-25653 you must register your topic name as chat2 To handle chat3/room-14565 you must register your topic name as chat3
If your channel is dynamic, don't worries, chat/* will be catch by topic named "chat", so chat2/* by topic named chat2 etc ...
To manage users inside topic, you must refer at https://github.com/JDare/ClankBundle/blob/master/Resources/docs/SessionSetup.md ratchet will use cookie/session to auth your via the cookie to retrieve the user session.
Here the full example of how auth the user against symfony app https://github.com/GeniusesOfSymfony/WebSocketBundle/blob/master/Event/ClientEventListener.php#L60, my fork provide full built-in auth.
How secure this, I will not say "How" because that depend of your system, so if you use ACL, RBAC, or just simple security role provided by symfony, I think you mean "where". In onSubscribe, check your user have access to the topic $topic->getId() you can easily check by exploding via '/' and check the second argument (who is the chat room id).
If you don't have any permissions system and symfony ACL is familiar to you, you can swiftly implement ACL where room entity is the OID and the connected user is the SID.
And looks like $securityContext->isGranted(['VIEW, 'EDIT'], $roomEntity)
If you want your own simple system (I think it's more simple for your use case), you can create a third table like "chat_user_room_permission" where you list wich user can access on what channel.
gittix09
I'm trying to build a chat app on a website (private use only... just for learning purposes). However, after reading the bundle documentation (which is great) I found myself with many questions. Please refer to this StackOverflow question: http://stackoverflow.com/questions/28937843/symfon2-clankbundle-simple-private-and-group-chat-database-shcema-and-logi