Czar Pino czarpino

Project moved due to excessive amount of unicorns. Repo https://git.io/adminpldt

Our community of amazing people. Managed by a cat. Backspace https://discord.gg/C43625u

Gist here will not be updated anymore Discussion here on Gist is still allowed but I strongly recommend going over to the repository or Discord chat

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

git archive --format=tar.gz -o /tmp/my-repo.tar.gz --prefix=my-repo/ master

More detailed version: https://til.simonwillison.net/git/git-archive

Debug your PHP in Docker with Intellij/PHPStorm and Xdebug

For your local dev, create a Dockerfile that is based on your production image and simply install xdebug into it. Exemple:

FROM php:5

RUN yes | pecl install xdebug \
&amp;&amp; echo "zend_extension=$(find /usr/local/lib/php/extensions/ -name xdebug.so)" &gt; /usr/local/etc/php/conf.d/xdebug.ini \

Deploying Sculpin Sites to GitHub Pages

I wanted to be able to use Sculpin to generate GitHub pages. Here's what I did...

Created a super awesome Sculpin site from the Sculpin Blog Skeleton
Make sure everything is under version control in my master branch (except things that shouldn't be. see the .gitignore)
Updated publish.sh:

#!/bin/bash

A simple JS event dispatcher that relies on a common key for the handler and data to dispatch actions.

var eventDispatcher = (function (eventDispatcher) {
    var eventHandlers = {};
    
    var eventDispatcher.register = function (key, handler) {
        eventHandlers[key] = handler;
    };

eventDispatcher.dispatch = function (data) {

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)

	# 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

	<?php

	/**
	* Duplicates a post & its meta and returns the new duplicated Post ID.
	*
	* @param int $post_id The Post ID you want to clone.
	* @return int The duplicated Post ID.
	*/
	function duplicate_post(int $post_id): int
	{

	// create an IAM Lambda role with access to dynamodb
	// Launch Lambda in the same region as your dynamodb region
	// (here: us-east-1)
	// dynamodb table with hash key = user and range key = datetime

	console.log('Loading event');
	var AWS = require('aws-sdk');
	var dynamodb = new AWS.DynamoDB({apiVersion: '2012-08-10'});

	exports.handler = function(event, context) {