joshellington

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

rgreenjr

-- 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%' 

mobilemind

# 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

Kartones

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)

alt-grr

<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/"/>

hhcordero

Dockerized JMeter - A Distributed Load Testing Workflow

Supported Cloud Providers:

• Amazon (https://aws.amazon.com/free/)
• DigitalOcean (https://www.digitalocean.com/join/)

Images used:

• JMeter Server (https://hub.docker.com/r/hhcordero/docker-jmeter-server) aka "Slave"
• JMeter Client Non-gui (https://hub.docker.com/r/hhcordero/docker-jmeter-client) aka "Master"

maxcnunes

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://')

benlinton

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.

laterbreh

var app = express();
app.io = require('socket.io')();

var routes = require('./routes/index')(app.io);

app.use('/', routes);

kyledcline

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.