Charles P paxinla

## README.md

      
              3 files
            
          
              13 forks
            
          
              4 comments
            
          
              84 stars
            
          
                quiver
                / README.md
            
            
              Last active
              July 19, 2024 07:38
            
              
                Who says PostgreSQL can't Pub/Sub like Redis?
              
          
    Pub/Sub pattern with PostgreSQL's LISTEN/NOTIFY command

This is a simple chat-like program using pub-sub pattern, backed by PostgreSQL's LISTEN/NOTIFY command.
Publish

publish message to foo channel from  user nickname.
$ python pub.py foo nickname
PUBLISH to channel #foo


## listen_sqla.py
import select
import datetime

import psycopg2
import psycopg2.extensions

from sqlalchemy import create_engine, text

engine = create_engine("postgresql+psycopg2://vagrant@/postgres")
	import select
	import datetime

	import psycopg2
	import psycopg2.extensions

	from sqlalchemy import create_engine, text

	engine = create_engine("postgresql+psycopg2://vagrant@/postgres")