Simple network visualisation

vis.py

import MySQLdb

db = MySQLdb.connect(host="localhost", port=3306, user="user", passwd="passwd", db="db")

cursor = db.cursor()
cursor.execute("SELECT id, referrer_id FROM users")

print "graph referrers {"
for row in cursor.fetchall():
    print "%s -- %s" % (row[0], row[1])

print "}"