Jorge belenaj

See also:

Service	Type	Storage	Limitations
Amazon DynamoDB	⚠️ Proprietary NoSQL	25 GB	⚠️ Payment method required
Amazon RDS	⚠️ Proprietary RDBMS		⚠️ Only free for 1 year
Azure SQL Database	MS SQL Server		⚠️ Only free for 1 year
👉 Clever Cloud	PostgreSQL, MySQL, MongoDB, Redis	256 MB (PostgreSQL)	Max 5 connections (PostgreSQL)

This is the process I used to put redshift user defined functions into dbt.

Created a subdirectory: macros/udfs/
Created a file for each udf, e.g. macros/udfs/f_future_date.sql.

{% macro f_future_date() %}
CREATE OR REPLACE FUNCTION {{target.schema}}.f_future_date()
RETURNS TIMESTAMP
IMMUTABLE AS $$
SELECT '2100-01-01'::TIMESTAMP;

Point Domain to Amazon Web Services (AWS) EC2 Instance

Open the Amazon Route 53 console at https://console.aws.amazon.com/route53/.
If you are new to Amazon Route 53, you see a welcome page; choose Get Started Now for DNS Management. Otherwise, choose Hosted Zones in the navigation pane.
Choose Create Hosted Zone.
For Domain Name, type your domain name.
Choose Create.
Click the Hosted Zone, edit record set.
In the value, add ec2-54-152-134-146.compute-1.amazonaws.com.
Change your DNS file to point to the IPv4 address (This would be in something like GoDaddy).

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime and ffmpeg.

Forked from https://gist.github.com/dergachev/4627207. Updated to use a palette to improve quality and skip gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

	#!/usr/bin/env python
	"""
	Fast duplicate file finder.
	Usage: duplicates.py <folder> [<folder>...]

	Based on https://stackoverflow.com/a/36113168/300783
	Modified for Python3 with some small code improvements.
	"""
	import os
	import sys

	#!/bin/bash
	#
	# By Zibri (2019)
	# Modified by @rokibhasansagar
	#
	# Usage: gitclean git-repo-url
	#
	gitclean ()
	{
	git clone "$1" workDir && {


	# https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection

	# requires pycryptodome lib (pip install pycryptodome)

	import sys
	import base64
	import os
	import json
	from Crypto.Cipher import AES

	import boto3
	from PIL import Image
	from io import BytesIO
	import os

	class S3ImagesInvalidExtension(Exception):
	pass

	class S3ImagesUploadFailed(Exception):
	pass

	import boto3
	import datetime
	import json
	from requests_aws4auth import AWS4Auth
	import requests

	boto3.setup_default_session(region_name='us-east-1')
	identity = boto3.client('cognito-identity', region_name='us-east-1')

	account_id='XXXXXXXXXXXXXXX'

	node {
	echo 'Results included as an inline comment exactly how they are returned as of Jenkins 2.121, with $BUILD_NUMBER = 1'
	echo 'No quotes, pipeline command in single quotes'
	sh 'echo $BUILD_NUMBER' // 1
	echo 'Double quotes are silently dropped'
	sh 'echo "$BUILD_NUMBER"' // 1
	echo 'Even escaped with a single backslash they are dropped'
	sh 'echo \"$BUILD_NUMBER\"' // 1
	echo 'Using two backslashes, the quotes are preserved'
	sh 'echo \\"$BUILD_NUMBER\\"' // "1"