Daniel Pereira danielpereirabp

Change your database RDS instance security group to allow your machine to access it.
- Add your ip to the security group to acces the instance via Postgres.
Make a copy of the database using pg_dump
- $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
- you will be asked for postgressql password.
- a dump file(.sql) will be created
Restore that dump file to your local database.
- but you might need to drop the database and create it first
- $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>

the database is restored

Handy helpers for controlling visibility of elements until Vue has compiled.

Use like:

<div v-cloak>
  <h1>
    <span class="v-cloak--inline">Loading...</span> <!-- Only displayed before compiling -->
    <span class="v-cloak--hidden">{{ post.title }}</span> <!-- Hidden until compiling is finished -->

To connect to MSSQL using PHP 5.6 we'll need to use PDO's DBLIB (PDO_DBLIB) http://php.net/manual/en/ref.pdo-dblib.php and FreeTDS http://www.freetds.org/

This quick tutorial is using Ubuntu Server 14.04

First, make sure you're up to date on all of your packages.

sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade

I'm using PHP 5.6.9 (https://launchpad.net/~ondrej/+archive/ubuntu/php5-5.6)

	{
	"New php class": {
	"prefix": "cla",
	"body": [
	"<?php",
	"",
	"namespace ${1:namespace};",
	"",
	"class ${2}",
	"{",

	#!/bin/bash

	# limpeza de arquivos inuteis no sistema
	# Criado por Wellington P. Gonçalves (Wellington Geek)
	# email: [email protected], [email protected]
	# Para executar o script basta localizar a pasta e digitar chmod +x clear.sh

	echo "Limpando a lixeira"
	sudo rm -rf /home/$USER/.local/share/Trash/files/*
	echo ""

	Vue.directive('radio', {
	twoWay: true,
	bind: function() {
	var self = this;
	var btns = $(self.el).find('.btn');
	btns.each(function() {
	$(this).on('click', function() {
	var v = $(this).find('input').get(0).value
	self.set(v);
	})

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	(function () {
	'use strict';

	angular
	.module('app')
	.config(['$httpProvider', function ($httpProvider) {
	$httpProvider.interceptors.push('busyInterceptor');
	}])
	.factory('busyInterceptor', busyInterceptor);

	# Load DSL and set up stages
	require 'capistrano/setup'

	# Include default deployment tasks
	require 'capistrano/deploy'
	require 'capistrano/composer'
	require 'capistrano/symfony'

	# Let us consider the following typical mysql backup script:
	mysqldump --routines --no-data -h $mysqlHost -P $mysqlPort -u $mysqlUser -p$mysqlPassword $database

	# It succeeds but stderr will get:
	# Warning: Using a password on the command line interface can be insecure.
	# You can fix this with the below hack:
	credentialsFile=/mysql-credentials.cnf
	echo "[client]" > $credentialsFile
	echo "user=$mysqlUser" >> $credentialsFile
	echo "password=$mysqlPassword" >> $credentialsFile