Zsh option parsing examples (gist) Permalink
Everything I know about zparseopts I learned from this gist.
Posts by Tag
- Links 10
- psql 8
- zsh 6
- Minimal Mistakes 4
- macOS 4
- CLI 4
- note to self 3
- GitHub Pages 2
- Video 2
- git 2
- shell functions 2
- Jekyll Collections 1
- Jekyll 1
- regex 1
- schemas 1
- encoding 1
- PostgreSQL 1
- JSON 1
- pgtab 1
- Questionable practices 1
- SQL 1
- PL/pgSQL 1
- plpgsql 1
- Ruby 1
- Github Pages 1
- less 1
Links
Mastering zsh Permalink
A great resource for understanding how to configure zsh.
regex tester Permalink
Interactive regex tester
Minimal Mistakes - Notices Permalink
Minimal Mistakes Notices examples.
Missing Semester – Version Control (video) Permalink
This is a great introduction to git which helped me tremendously with a clear explanation of what’s going on under the hood.
MIT – Missing Semester IAP 2020 [video playlist] Permalink
“We’ll teach you how to master the command-line, use a powerful text editor, use fancy features of version control systems, and much more!” (videos)
Command Line Tutorial: Usage in Linux and macOS Permalink
“The essential command line tutorial for beginners. Learn how to navigate your computer with the CLI to modify files, update permissions and more.”
Quick-Start Guide - Minimal Mistakes Permalink
I’ll be returning to these docs often for a while.
psql
psql tip: set (or pset) options interactively
Tab completion provides builtin cheatsheets for psql settings.
psql tip: copy by sending output to the clipboard
Redirecting output is a very easy way to copy psql query output.
Dynamic SQL with PostgreSQL
How to execute dynamic SQL in a PostgreSQL procedure, demonstrated with psql queries and meta-commands.
psql: how to paste data into a table
\copy mytable from stdin + paste + \. + enter
Importing multiline JSON objects into PostgreSQL
Summary and examples of what I’ve learned about loading multiline JSON objects into postgres
Set Up PostgreSQL for Learning with Schemas
Use schemas to organize and work with multiple projects in a single database while learning PostgreSQL.
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...
zsh
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.
Minimal Mistakes
Build a blog site with a web browser
Step by step directions for building a blog website using a web browser and GitHub Pages
Minimal Mistakes - Notices Permalink
Minimal Mistakes Notices examples.
Jekyll - First Impressions
I’m impressed.
Quick-Start Guide - Minimal Mistakes Permalink
I’ll be returning to these docs often for a while.
macOS
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.
zsh Tip: run-help is extremely helpful
Configure zsh to use the run-help function, making it easer to access documentation.
Installing Jekyll on macOS Monterey
Here are a couple of errors I encountered and managed to solve while trying to install Jekyll with the builtin version of ruby on macOS Monterey.
CLI
Dig into zsh: How to Function (part 2)
Learn how to configure zsh to load functions from a directory using $fpath and autoload.
Dig into zsh: How to Function (part 1)
A hands-on exploration of writing a shell function in zsh.
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.
note to self
zsh: learning notes (pbnote function)
Learning zsh in public, pbnote function.
Loading JSON into Postgres (learning notes)
Lesson: load JSON as binary to avoid (strange) problems with escaped characters
Learning how to use Postgres procedures
Personal learning notes
GitHub Pages
Build a blog site with a web browser
Step by step directions for building a blog website using a web browser and GitHub Pages
Jekyll - First Impressions
I’m impressed.
Video
Missing Semester – Version Control (video) Permalink
This is a great introduction to git which helped me tremendously with a clear explanation of what’s going on under the hood.
MIT – Missing Semester IAP 2020 [video playlist] Permalink
“We’ll teach you how to master the command-line, use a powerful text editor, use fancy features of version control systems, and much more!” (videos)
git
Missing Semester – Version Control (video) Permalink
This is a great introduction to git which helped me tremendously with a clear explanation of what’s going on under the hood.
shell functions
Dig into zsh: How to Function (part 2)
Learn how to configure zsh to load functions from a directory using $fpath and autoload.
Dig into zsh: How to Function (part 1)
A hands-on exploration of writing a shell function in zsh.
Jekyll Collections
Jekyll - First Impressions
I’m impressed.
Jekyll
Build a blog site with a web browser
Step by step directions for building a blog website using a web browser and GitHub Pages
regex
Back to Top ↑schemas
Set Up PostgreSQL for Learning with Schemas
Use schemas to organize and work with multiple projects in a single database while learning PostgreSQL.
encoding
Tangled Up in Encoding
Fixing invalid byte sequences in UTF8 text with sed.
PostgreSQL
Tangled Up in Encoding
Fixing invalid byte sequences in UTF8 text with sed.
JSON
Importing multiline JSON objects into PostgreSQL
Summary and examples of what I’ve learned about loading multiline JSON objects into postgres
pgtab
Importing multiline JSON objects into PostgreSQL
Summary and examples of what I’ve learned about loading multiline JSON objects into postgres
Questionable practices
Self-concatenating table
Probably a terrible idea, but I couldn’t resist trying.
SQL
Postgres: a question of order
Is text created by generated_series always aggregated in numerical order?
PL/pgSQL
Dynamic SQL with PostgreSQL
How to execute dynamic SQL in a PostgreSQL procedure, demonstrated with psql queries and meta-commands.
plpgsql
PostgreSQL - scoping parameters in plpgsql
Scope plpgsql parameters with qualified names, e.g. my_function.my_param.
Ruby
Compiling Ruby 3 on macOS Ventura
These are the hoops I jumped through to build Ruby on Ventura. There might be other solutions.
Github Pages
Previewing github pages with jekyll 4
Getting Ruby 3/Jekyll 4 working with this site was an ordeal. I’m exhausted but delighted.
less
It’s Good to Know less
Knowing how to use the ubiquitous shell pager “less” is an essential command line skill.