fierroformo

SchemaSpy is a neat tool to produce visual diagrams for most relational databases.

Here's how to use it to generate schema relationship diagrams for PostgreSQL databases:

1. Download the jar file from here (the current version is schemaSpy_5.0.0.jar)

2. Get the PostgreSQL JDBC driver (either the JDBC3 or JDBC4 jar file is fine)

3. Run the command against an existing database. For most databases, the schema (-s option) we are interested in is the public one:

fierroformo

# nuke the queue
redis-cli FLUSHALL

# nuke anything currently running
pkill -9 celeryd

fierroformo

# simple decorator for logging out django db queries
# just put it along with other decorators before view or 
# db-loading stuff. than go to your console and see whats going on.
# example:
#
# @log_db_queries
# @login_required
# def your_view(request, args...):
#     your stuff
def log_db_queries(f):