Skip to content

Instantly share code, notes, and snippets.

Avatar

Jefe Johnson jeffjohnson9046

View GitHub Profile
@giannisp
giannisp / gist:ebaca117ac9e44231421f04e7796d5ca
Last active Jan 12, 2021
Upgrade PostgreSQL 9.6.5 to 10.0 using Homebrew (macOS)
View gist:ebaca117ac9e44231421f04e7796d5ca
After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work.
The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."
Database files have to be updated before starting the server, here are the steps that had to be followed:
# need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default
brew unlink postgresql
brew install postgresql@9.6
brew unlink postgresql@9.6
brew link postgresql
@kyledcline
kyledcline / postgres-best-practices.md
Last active Feb 13, 2021
Postgres Best Practices
View postgres-best-practices.md

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.

@benlinton
benlinton / multiple_mysql_versions_for_development.md
Last active Feb 3, 2021
Multiple MySQL Versions with Homebrew
View multiple_mysql_versions_for_development.md

Multiple MySQL Versions for Development

Options included below:

  • Using Docker docker-compose
  • Using Homebrew brew

Using Docker (recommended)

This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service.

@maxcnunes
maxcnunes / curl-get-status-code-and-response-body.sh
Created Nov 24, 2015
Curl - Get status code and response body
View curl-get-status-code-and-response-body.sh
URL="http://stackoverflow.com/"
# store the whole response with the status at the and
HTTP_RESPONSE=$(curl --silent --write-out "HTTPSTATUS:%{http_code}" -X POST $URL)
# extract the body
HTTP_BODY=$(echo $HTTP_RESPONSE | sed -e 's/HTTPSTATUS\:.*//g')
# extract the status
HTTP_STATUS=$(echo $HTTP_RESPONSE | tr -d '\n' | sed -e 's/.*HTTPSTATUS://')
@hhcordero
hhcordero / 1_Dockerised_JMeter.md
Last active Feb 25, 2021
Dockerized JMeter - A Distributed Load Testing Workflow
View 1_Dockerised_JMeter.md
@kuc
kuc / build.xml
Created Jul 21, 2014
Download Maven dependencies using Ant
View build.xml
<project name="lib" default="download-libs" xmlns:artifact="urn:maven-artifact-ant">
<property name="maven.ant.tasks.version" value="2.1.3"/>
<property name="maven.ant.tasks.jar" value="maven-ant-tasks-${maven.ant.tasks.version}.jar"/>
<property name="maven.ant.tasks.mirror"
value="http://ftp.ps.pl/pub/apache/maven/ant-tasks/${maven.ant.tasks.version}/binaries/"/>
<target name="download-libs" depends="-init-maven-task">
<artifact:dependencies pathId="dependencies.classpath">
<remoteRepository id="maven-central" url="http://repo1.maven.org/maven2/"/>
@Kartones
Kartones / postgres-cheatsheet.md
Last active Mar 8, 2021
PostgreSQL command line cheatsheet
View postgres-cheatsheet.md

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)
@mobilemind
mobilemind / git-tag-delete-local-and-remote.sh
Last active Mar 5, 2021
how to delete a git tag locally and remote
View git-tag-delete-local-and-remote.sh
# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active Mar 7, 2021
Useful PostgreSQL Queries and Commands
View postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@joshellington
joshellington / sftp-ubuntu.md
Created Mar 28, 2012
Basic tutorial for creating a SFTP-only user on Ubuntu 9.04 and greater
View sftp-ubuntu.md

Adding SFTP-only user to Ubuntu Server

To add a SFTP-only user, you'll need to make sure your SSH config settings are correct, add a new user/group and set permissions for your new user. For step-by-step directions, see below. Omit sudo if you're logged in as root.

Directions

  1. Edit /etc/ssh/sshd_config and make sure to add the following at the end of the file:

     Match group filetransfer
     	ChrootDirectory %h