yolao’s gists

yolao / nginx.conf

Created July 27, 2024 16:11 — forked from plentz/nginx.conf

Best nginx configuration for improved security(and performance)

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

voskobovich / gist:537b2000108e4781f70b

Last active November 25, 2024 18:36

List of most currency ISO code and symbol format in SQL.

	DROP TABLE currency;

	-- Create table variable
	CREATE TABLE currency (
	name VARCHAR(20),
	code VARCHAR(3),
	symbol VARCHAR(5)
	);

	ALTER TABLE currency CONVERT TO CHARACTER SET utf8;

brock / psql-with-gzip-cheatsheet.sh

Last active March 6, 2025 00:21

Exporting and Importing Postgres Databases using gzip

	# This is just a cheat sheet:

	# On production
	sudo -u postgres pg_dump database \| gzip -9 > database.sql.gz

	# On local
	scp -C production:~/database.sql.gz
	dropdb database && createdb database
	gunzip < database.sql.gz \| psql database

alfchee / NumeroALetras.js

Last active March 29, 2025 14:26

Código en JavaScript que convierte números a letras, bastante útil para formularios de documentos contables y similares


	/*************************************************************/
	// NumeroALetras
	// The MIT License (MIT)
	//
	// Copyright (c) 2015 Luis Alfredo Chee
	//
	// Permission is hereby granted, free of charge, to any person obtaining a copy
	// of this software and associated documentation files (the "Software"), to deal
	// in the Software without restriction, including without limitation the rights

martintreurnicht / ColorUtil

Created November 28, 2014 14:47

Lighten and darken colors in android

	public static int lighten(int color, double fraction) {
	int red = Color.red(color);
	int green = Color.green(color);
	int blue = Color.blue(color);
	red = lightenColor(red, fraction);
	green = lightenColor(green, fraction);
	blue = lightenColor(blue, fraction);
	int alpha = Color.alpha(color);
	return Color.argb(alpha, red, green, blue);
	}

plentz / nginx.conf

Last active March 28, 2025 17:48

Best nginx configuration for improved security(and performance)

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

browny / simple_socket_example.c

Last active March 2, 2025 13:18

simple socket example in C

bsalim / php speed up tips.html

Created January 3, 2013 09:09

63 Tips for speeding up PHP

	<html>
	<body>
	<p>Here are Webber’s points:</p>
	<ul>
	<li>If a method can be static, declare it static. Speed improvement is by a factor of 4.</li>
	<li>echo is faster than print.(<em>* compare with list from phplens by John Lim</em>)</li>
	<li>Use echo’s multiple parameters instead of string concatenation.</li>
	<li>Set the maxvalue for your for-loops before and not in the loop.</li>
	<li>Unset your variables to free memory, especially large arrays.</li>
	<li>Avoid magic like __get, __set, __autoload</li>

plasticbrain / gist:3887245

Created October 14, 2012 04:00

PHP: mime types (array format)

	<?php
	$mime_types = array(
	'.3dm' => 'x-world/x-3dmf',
	'.3dmf' => 'x-world/x-3dmf',
	'.a' => 'application/octet-stream',
	'.aab' => 'application/x-authorware-bin',
	'.aam' => 'application/x-authorware-map',
	'.aas' => 'application/x-authorware-seg',
	'.abc' => 'text/vnd.abc',
	'.acgi' => 'text/html',