drbrain: SQL query dependencies

Eric Hodel (

drbrain) wrote,
@ 2005-05-24 22:18:00

SQL query dependencies
I wrote a nifty little script with

zenspider to read through Rails' production logs and figure out which queries depend on which tables.

table/query dependency graph

Username:		Create an Account Forgot your login or password? Login w/ OpenID
Password:
	Remember Me
	English • Español • Deutsch • Русский…

	tursiae 2006-01-22 11:12 pm UTC (link)
	Any chance this script's been open sourced? There's not much out there in the way of SQL call graph generators. I'm writing my own to understand a system I'm developing.. and it's going to be either adapting a script out there, or digging through PostgreSQL's lexer to generate a dependency tree. (Reply to this) (Thread)

	drbrain 2006-01-23 06:26 am UTC (link)
	Yup! sql_dep_graph at the bottom of the page. (Reply to this) (Parent)