Skip to content

Instantly share code, notes, and snippets.

View 11me's full-sized avatar
👋
Hi!

limerc 11me

👋
Hi!
View GitHub Profile
@11me
11me / postgres-best-practices.md
Created June 26, 2023 09:41 — forked from kyledcline/postgres-best-practices.md
Postgres Best Practices

PSQL CLI Client

Psql is a fully-fledged CLI client for Postgres, but most people are unaware of its many advanced features.

~/.psqlrc can be edited to persist any behavior or configuration settings you want between psql sessions. It behaves just like ~/.bashrc or ~/.vimrc, sourced at psql launch. See More out of psql for some interesting configurations.

If you have a long query to write and rewrite, you can use \e to edit your query in an editor.

Use \watch at the end of a query in order to automatically re-run the query every few seconds - great for monitoring while making changes elsewhere in your application architecture.

@11me
11me / bash-colors.md
Created June 12, 2021 19:08 — forked from Prakasaka/bash-colors.md
The entire table of ANSI color codes.

Regular Colors

Value Color
\e[0;30m Black
\e[0;31m Red
\e[0;32m Green
\e[0;33m Yellow
\e[0;34m Blue
\e[0;35m Purple