Leonardo Rifeli leonardorifeli

Deep Dive: PostgreSQL on AWS

When loading data

disable backups (backup_retention=0)
disable multi-AZ and autovacuum
pg_dump -Fc (compressed) and pg_restore -j (parallel)
Increase maintenance_work_mem

Deep Dive: PostgreSQL on AWS

When loading data

disable backups (backup_retention=0)
disable multi-AZ and autovacuum
pg_dump -Fc (compressed) and pg_restore -j (parallel)
Increase maintenance_work_mem

It's still a work in progress...

Intro

As William Durand was recently explaining in his SOS, he "didn't see any other interesting blog post about REST with Symfony recently unfortunately". After spending some long hours to implement an API strongly secured with oAuth, I thought it was time for me to purpose my simple explanation of how to do it.

Ok, you know the bundles

You might have already seen some good explanation of how to easily create a REST API with Symfony2. There are famous really good bundles a.k.a. :

	package main

	import (
	"log"

	"encoding/json"
	"fmt"
	"os"

	"math/rand"

	// the wizare functions
	var sendString = (function(rfb, force, sendDelay) {
	sendDelay = sendDelay \|\| 25;
	var _q = [];
	var _qStart = function() {
	var chr = _q.shift();
	if (chr) {
	rfb.sendKey(chr);
	setTimeout(_qStart, sendDelay);
	}

	var AWS = require('aws-sdk'),
	fs = require('fs');

	// For dev purposes only
	AWS.config.update({ accessKeyId: '...', secretAccessKey: '...' });

	// Read in the file, convert it to base64, store to S3
	fs.readFile('del.txt', function (err, data) {
	if (err) { throw err; }

	# (Re)create the index
	curl -X DELETE "http://localhost:9200/tagcloud"
	curl -X PUT "http://localhost:9200/tagcloud"-d '{
	"settings" : {
	"index" : {
	"number_of_shards" : 1,
	"number_of_replicas" : 0
	}
	}
	}'

	<?php
	include '../vendor/autoload.php';
	$classLoader = new \Doctrine\Common\ClassLoader('Entities', __DIR__);
	$classLoader->register();

	$classLoader = new \Doctrine\Common\ClassLoader('Proxies', __DIR__);
	$classLoader->register();

	// config
	$config = new \Doctrine\ORM\Configuration();

	#!/bin/bash

	sudo kextunload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport
	sudo kextload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport