Realtime connection to the database

I am creating a chat application, the database stores chat messages and should automatically show real time data to all the subscribers of the chat room. Is there any way to achieve the described functionality with drizzle and postgres?