Post AVok3aGpz0AtthwqpM by benjaoming@social.data.coop
 (DIR) More posts by benjaoming@social.data.coop
 (DIR) Post #AVok3YGPRcdzfnjTsm by benjaoming@social.data.coop
       2023-05-17T16:51:18Z
       
       0 likes, 0 repeats
       
       Very awesome 🕶️ @valberg wrote up a super blog post about using the new StreamingHttpResponse in #Django 4.2, combined with async psycopg3 and #postgresql's  "LISTEN/NOTIFY" to have async real time events!This feels like the start of something big!https://valberg.dk/django-sse-postgresql-listen-notify.htmlCC: @carlton
       
 (DIR) Post #AVok3ZRR473fKHtnhw by paulox@fosstodon.org
       2023-05-18T11:19:53Z
       
       0 likes, 0 repeats
       
       @benjaoming @valberg @carlton @psycopg This seems to me a great use case for Django 4.2 and Psycopg 3.1 👍
       
 (DIR) Post #AVok3aGpz0AtthwqpM by benjaoming@social.data.coop
       2023-05-18T05:39:28Z
       
       0 likes, 0 repeats
       
       @valberg @carlton I just thought of a name for the app... ChatPsycopg.Or ChatPsycopg 3!It's somehow very catchy and familiar... I wonder why :)
       
 (DIR) Post #AVok3aW54KMsez51aS by paulox@fosstodon.org
       2023-05-19T15:45:46Z
       
       0 likes, 0 repeats
       
       @benjaoming @valberg @carlton @psycopg Interesting comments about the article in @lobsters https://lobste.rs/s/qyler8/writing_chat_application_django_4_2_usingCC @simon
       
 (DIR) Post #AVok3bE2QtWurJe86S by simon@fedi.simonwillison.net
       2023-05-19T15:47:24Z
       
       0 likes, 0 repeats
       
       @paulox @benjaoming @valberg @carlton @psycopg @lobsters just blogged that too https://simonwillison.net/2023/May/19/chat-application-in-django/
       
 (DIR) Post #AVokFCOAbHqrIwusDY by paulox@fosstodon.org
       2023-05-19T15:49:03Z
       
       0 likes, 0 repeats
       
       @simon @benjaoming @valberg @carlton @psycopg @lobsters I'm happy that sharing the article on #lobster had a positive impact 🙂
       
 (DIR) Post #AVotAPgAev7GfC83fc by valberg@social.data.coop
       2023-05-19T17:29:54Z
       
       0 likes, 0 repeats
       
       @simon @paulox @benjaoming @carlton @psycopg Yeah, a friend also mentioned that it might be too much with a postgrea connection per user. But I think for small-ish scale it doesn't matter. I also want to try to load test it somehow using either locust or siege.Would be nice if we could have a connection per "LISTEN" call - especially if we can get it working without more infrastructure.
       
 (DIR) Post #AVp5WOdkOyUzGHFCnQ by simon@fedi.simonwillison.net
       2023-05-19T19:46:07Z
       
       0 likes, 0 repeats
       
       @valberg @paulox @benjaoming @carlton @psycopg I bet for many applications one connection per user will scale just fine - and if you need to go beyond that hooking up to a Redis instance for the broadcast bit wouldn't be a huge amount of extra work
       
 (DIR) Post #AVp63rY9w7xQTpaXfU by carlton@fosstodon.org
       2023-05-19T19:51:10Z
       
       0 likes, 0 repeats
       
       @simon @valberg @paulox @benjaoming @psycopg … and that’s more or less the pattern Channels gives you with the channel layers.