Skip to content

Instantly share code, notes, and snippets.

View noize-e's full-sized avatar

noiz-e noize-e

5 followers · 10 following
View GitHub Profile
@noize-e
noize-e / postgres-cheatsheet.md
Created December 9, 2022 08:51 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@noize-e
noize-e / Install update WordPress puglins directly.md
Created September 20, 2021 02:23 — forked from dianjuar/Install update WordPress puglins directly.md
Install update WordPress plugins without providing ftp access

Install WordPress plugins directly (without FTP)

Ref Stack Overflow Comment

Put this on your wp-config.php

/* That's all, stop editing! Happy blogging. */
define('FS_METHOD', 'direct');
@noize-e
noize-e / curl reference
Created January 31, 2020 03:55 — forked from afair/curl reference.md
Curl command reference with options sorted by category for easier usage than that man page.
==========================================
CURL COMMAND
==========================================
Format curl [options] [URL...]
Quick Ref:
curl -X POST http://example.com/ <= Method option and URL (Options come before or after URL)
-H "Authorization: <data>" <= Add HTTP Header (like Authorization)