pdot 1.0.0: Exploring Databases Visually, Part III

In what I can't say isn't a tradition at this point, we're in an odd-numbered year so there's news on the pdot front! Get it here!

The biggest change (and the reason for the big 1-0-0) is simplifying usage: rather than requiring a shell function to plug the graph body into a template for interactive use, pdot now outputs the entire digraph or flowchart markup. The old behavior is still available with the --body flag, but the new default means it's a lot easier to get started -- pdot postgres_air fks | dot -Tpng | wezterm imgcat and go. You only need scripting to do the pipelining for you, or to customize the graph's appearance.

Other notable updates along the way:

  • PGHOST, PGDATABASE, PGUSER, and PGPASSWORD environment variables are honored
  • new policies graph, and many improvements to others especially triggers and function refs
  • usable as a Rust library!

Late last year I also presented at PGConf.EU in Athens, should you be interested.