Sid koomai

Opening and closing an SSH tunnel in a shell script the smart way

I recently had the following problem:

From an unattended shell script (called by Jenkins), run a command-line tool that accesses the MySQL database on another host.
That tool doesn't know that the database is on another host, plus the MySQL port on that host is firewalled and not accessible from other machines.

We didn't want to open the MySQL port to the network, but it's possible to SSH from the Jenkins machine to the MySQL machine. So, basically you would do something like

ssh -L 3306:localhost:3306 remotehost

Symfony Security Checker in Laravel

Artisan command for Sensiolabs Security Checker

Require this project in your composer.json file

"sensiolabs/security-checker": "2.x"

Add the following line to app/start/artisan.php:

PHP Developer Interview: What you should know

1. What’s the difference between " self " and " this " ?

Use $this to refer to the current object. Use self to refer to the current class. In other words, use $this->member for non-static members, use self::$member for static members.

Source: When to use self vs this -stackoverflow

Frontend Development

Attention: the list was moved to

https://github.com/dypsilon/frontend-dev-bookmarks

This page is not maintained anymore, please update your bookmarks.

Never Expose DB Results Directly

If you rename a field, then your users are fucked. Convert with a hardcoded array structure.
Most DB drivers [for PHP] will show integers as numeric strings and false as "0", so you want to typecast them.
Unless you're using an ORM with "hidden" functionality, people will see passwords, salts and all sorts of fancy codes. If you add one and forget to put it in your $hidden array then OOPS!

Use the URI sparingly, and correctly

Use the query string for paired params instead of /users/id/5/active/true. Your API does not need to be SEO optimised.
?format=xml is stupid, use an Accept: application/xml header. I added this to the CodeIgniter Rest Server once for lazy people, and now people think it's a thing. It's not.

Challenge: you need a flexible (swap in other repository implementations) way to display some kind of resource. Let's say, Posts. What does your folder structure look like?

Requirements:

Repository implements an interface
Must show at least one implementation of the interface (Eloquent version is fine)
The interface is injected into your PostsController.
Show where you register your IoC bindings
Show folder structure. Where are interfaces/repositories stored?

Mac web developer apps

This gist's comment stream is a collection of webdev apps for OS X. Feel free to add links to apps you like, just make sure you add some context to what it does — either from the creator's website or your own thoughts.

— Erik

	#!/usr/bin/env bash

	echo ">>> Starting Install Script"

	# Update
	sudo apt-get update

	# Install MySQL without prompt
	sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password root'
	sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password root'

	#!/bin/bash

	# This script creates a new project (or site) under /var/sites and creates
	# new virtual host for that site. With the options a site can also
	# install the latest version of Laravel directly.
	# This script was originally based on the following script by @Nek from
	# Coderwall: https://coderwall.com/p/cqoplg

	# Display the usage information of the command.
	create-project-usage() {

	/**
	* Converts a string to a "URL-safe" slug.
	* Allows for some customization with two optional parameters:
	*
	* @param {string} Delimiter used. If not specified, defaults to a dash "-"
	* @param {array} Adds to the list of non-alphanumeric characters which
	* will be converted to the delimiter. The default list includes:
	* ['–', '—', '―', '~', '\\', '/', '\|', '+', '\'', '‘', '’', ' ']
	*/
	if (!String.prototype.slugify) {