til there's a debugger in pgadmin3. will very much come in handy i'm sure. thanks. but i don't agree with this >also what people call business logic often mea

til there's a debugger in pgadmin3. will very much come in handy i'm sure. thanks. but i don't agree with this >also what people call business logic often means fetching data from the db, processing it in some way and returning it. This is what views are for, they are definitions, so there's nothing to test there, except performance maybe. i see business logic as things that connect disparate parts of the domain. not all of my business is in my db. a lot of it is somewhere else, in someone else's db, accessible only through their api. like i said in my op: unless you want to hack postgres (or whatever rdbms) into a full-fledged general use dev environment you're not going to be able to marshal all of these disparate resources.