🌊

Sebastian Duque Gutierrez sebastiandg7

🌊

I breathe underwater and I write code in my surface intervals.

sebastiandg7 / insert_all_countries.sql

Created October 25, 2017 19:20

Insert all countries to databse (name and code).

	USE `database`;

	CREATE TABLE `country` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(45) NOT NULL,
	`code` VARCHAR(45) NOT NULL,
	PRIMARY KEY (`id`)
	)

	INSERT INTO `country` (`id`, `name`, `code`) VALUES (null, 'Afghanistan','AF');

sebastiandg7 / insert_all_timezones.sql

Last active October 16, 2018 17:50

Insert all timezones to database (name and UTC offset).


	USE `database`;

	CREATE TABLE `timezone` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(45) NOT NULL,
	`offset` VARCHAR(10) NOT NULL,
	`raw_offset` INT NOT NULL,
	PRIMARY KEY (`id`)
	)

sebastiandg7 / Postman.desktop

Created December 5, 2017 02:15 — forked from aviskase/Postman.desktop

Install Postman

	[Desktop Entry]
	Encoding=UTF-8
	Name=Postman
	Exec=postman
	Icon=/opt/Postman/resources/app/assets/icon.png
	Terminal=false
	Type=Application
	Categories=Development;

sebastiandg7 / OpenVPN-Dockerfile

Created January 24, 2018 02:03

Dockerfile for the creation of an OpenVPN container

	FROM ubuntu:16.04

	# VARS

	ENV KEY_COUNTRY CO
	ENV KEY_PROVINCE VALLE
	ENV KEY_CITY CALI
	ENV KEY_ORG MyOrganization
	ENV KEY_EMAIL [email protected]
	ENV KEY_OU Community

sebastiandg7 / script.service.ts

Created June 21, 2018 20:27

Angular: dynamically load local or URL hosted JS scripts

	import { Injectable } from "@angular/core";
	import { ScriptStore } from "./script.store";

	declare var document: any;

	@Injectable()
	export class ScriptService {

	private scripts: any = {};

sebastiandg7 / postman-deb.sh

Created July 12, 2018 17:10 — forked from SanderTheDragon/postman-deb.sh

A shellscript to create a Postman .deb file, for simple installation on Debian-based Linux distro's. Also creates a .desktop file.

	#!/bin/sh

	script=`basename "$0"`

	if [ $# -gt 0 ] && [ "$1" = "-e" ]; then
	e="-e"
	fi

	echo "Removing old Postman tarballs"
	rm -f $(ls Postman*.tar.gz)

sebastiandg7 / cockroach-cluster-docker-compose.yml

Last active August 15, 2018 14:30

CockroachDB cluster with two datacenters simulation using docker compose

	# CockroachDB cluster with two datacenters simulation using docker compose

	version: '2'

	networks:
	shared-roachnet:
	driver: bridge
	dc0-roachnet:
	driver: bridge
	dc1-roachnet:

sebastiandg7 / delete_duplicates.bash

Created August 30, 2018 17:46

Delete duplicated files in linux

sebastiandg7 / npm

Last active January 15, 2019 23:58

npm script fix for Windows shared node installation with WSL

	#!/bin/sh
	(set -o igncr) 2>/dev/null && set -o igncr; # cygwin encoding fix

	basedir=`dirname "$0"`

	case `uname` in
	CYGWIN) basedir=`cygpath -w "$basedir"`;;
	esac

	if grep -iq 'Microsoft\\|WSL' /proc/version; then

sebastiandg7 / ei.cfg

Last active April 11, 2025 08:44

Config file to place in sources/ei.cfg inside Windows Installation USB to avoid automatic Windows version detection