Saturday, September 11, 2010

Interesting Postgresql Feature...

I found something new today, Postgres supports asynchronous notifications between different database sessions! What does this mean?

try this in a psql window;
listen SomethingHappens;

then in another window;
notify SomethingHappens;

Now go back to the first psql session... It's like a mini pub sub system built into your favourite database!

http://www.postgresql.org/docs/8.4/static/sql-notify.html
Posted by at
Labels:

1 comment:

Ben Sizer said...

We use this for our MMO tech. It's handy for letting zone servers get notified of someone logging in when a login server writes to the DB to store this. It beats direct communication between the servers because you know the data is going to be consistent at the time you get the notification.

Tuesday, September 14, 2010

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Giant, Python Powered Robots.
    These are the robots I've been working on for the last 12 months. They each weigh about 11 tonnes and have a 17 meter reach. The control...
  • WIP: Generic Node Graph Editor Framework
    This hard-to-see screenshot is a Generic Node Graph Editing framework I'm building. I'm hoping it can be used for any kind of node...
  • Unity3D WheelCollider and motorTorque.
    So, you've created a car prefab using WheelCollider components, and now you can apply a motorTorque to make the whole thing move along. ...
  • I made a Server Program in Go.
    MiddleMan: A Pub/Sub and Request/Response server in Go. This is my first Go project. It is a rewrite of an existing Python server, based o...
  • Spatial Hashing
    Often, when building a game, you need to test if objects are colliding. The objects could be spaceships, rocks, mouse pointers, laser beams....
  • US Corporate Pillages Local Talent, Exploits Gov, Flees Back Home.
    I've just read a newspaper article (courtesy of Kranzky ) from WA Business News documenting the malfeasance, gross negligence and misc...
  • GGJ Perth in trouble...
    Unfortunately I've not secured a venue for the GGJ. With 9 days left, things are not looking hopeful. It could be that GGJ Perth will no...
  • Scalability of Stackless, Fibra and Kamaelia
    After my last post, I decided to benchmark the scaling properties of Stackless, Kamaelia, Fibra using the same hackysack algorithm. Left axi...
  • Planet Shader #2
    Possibly slightly more correct lighting. The rim light is now only applied in the direction of the sun, rather than being purely based on vi...
  • Unity3D 3.0 Planet Shader
    Update: This is another planet shader, with more physical fidelity. Shader "Planet" { Properties { _MainTex ("Diff...