SPAWK – SQL Powered AWK

@load "spawk" BEGIN { spawk_sesami["dbuser"] = "chat" spawk_sesami["dbpassword"] = "xxx" spawk_sesami["dbname"] = "chat" } { spawk_submit("SELECT `login`, `name` FROM `user` WHERE `login` LIKE " spawk_escape($0)) while (spawk_fetchrow(user)) process_user(user) } function process_user(user, relation) { print user[0] spawk_submit("SELECT `related`, `relationship` FROM `relation` WHERE `user` = " spawk_escape(user[1])) while (spawk_fetchrow(relation)) print "\t" relation[0] }