Set Up PostgreSQL for Learning with Schemas
Use schemas to organize and work with multiple projects in a single database while learning PostgreSQL.
PostgreSQL Stan
postgres fanatic
command line aficionado
macOS/darwin (Unix) user
Blog
Recent Posts
PostgreSQL - Grant Yourself Limited Superpowers
Using roles in PostgreSQL, it’s easy to give yourself superuser privileges that can be invoked when needed, somewhat similar to using the sudo command on a U...
Install PostgreSQL from source on macOS Permalink
A step-by-step guide for installing PostgreSQL from source on macOS.
Compiling from source on macOS
General directions for installing software from source on macOS.
Random shell (zsh) history stuff
Some things about shell (zsh) history I don’t want to forget.
Terminal (zsh) shortcuts on macOS
List of useful zsh shortcuts which are enabled by default in the Terminal on macOS.
zsh Shell History - Options
I read the docs so you don’t have to.
zsh Tip: run-help is extremely helpful
Configure zsh to use the run-help function, making it easer to access documentation.
Mastering zsh Permalink
A great resource for understanding how to configure zsh.
regex tester Permalink
Interactive regex tester
Build a blog site with a web browser
Step by step directions for building a blog website using a web browser and GitHub Pages