Skip to content

Instantly share code, notes, and snippets.

View yassine-khachlek's full-sized avatar

Yassine Khachlek yassine-khachlek

10 followers · 21 following
View GitHub Profile
@yassine-khachlek
yassine-khachlek / PostgreSQL_timestamp_type_precision_limit.txt
Last active January 22, 2023 20:09
CREATE TABLE mytable (id SERIAL PRIMARY KEY, created_at TIMESTAMP(9) WITH TIME ZONE NOT NULL DEFAULT NOW());
WARNING: TIMESTAMP(9) WITH TIME ZONE precision reduced to maximum allowed, 6
LINE 3: created_at TIMESTAMP(9) WITH TIME ZONE NOT NULL DEFAULT ...
^
WARNING: TIMESTAMP(9) WITH TIME ZONE precision reduced to maximum allowed, 6
CREATE TABLE
Query returned successfully in 42 msec.
@yassine-khachlek
yassine-khachlek / WOEID.json
Created January 7, 2023 21:02
WOEID
[
{
"name": "Worldwide",
"placeType": {
"code": 19,
"name": "Supername"
},
"url": "http:\/\/where.yahooapis.com\/v1\/place\/1",
"parentid": 0,
"country": "",
@yassine-khachlek
yassine-khachlek / Obtain a wildcard certificate using Let's Encrypt's new ACMEv2 server
Last active February 17, 2020 20:08
Certbot
Obtain a wildcard certificate using Let's Encrypt's new ACMEv2 server
certbot -d *.example.com --preferred-challenges=dns --manual certonly
@yassine-khachlek
yassine-khachlek / gist:7dc8a54697f57f37c55e4961429d80eb
Created October 19, 2018 22:25
docker
docker update --restart=no
@yassine-khachlek
yassine-khachlek / nginx.conf
Created October 11, 2018 05:21
/etc/nginx/conf.d
server {
listen 80;
server_name example.com;
return 301 $scheme://www.example.com$request_uri;
}
server {
listen 80 default_server;
server_name *.example.com;
...
@yassine-khachlek
yassine-khachlek / .htaccess
Created October 10, 2018 17:28
.htaccess
RewriteEngine On
RewriteCond %{HTTP_HOST} ^[^.]+\.[^.]+$
RewriteRule ^(.*)$ https://www.%{HTTP_HOST}/$1 [L,R=301]
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
@yassine-khachlek
yassine-khachlek / Laravel MySQL INSERT ON DUPLICATE KEY UPDATE.md
Last active October 7, 2018 10:22 
$query = "INSERT INTO table_name (" . implode(',', $columns) . ") VALUES " 
. implode(
    ',',
    array_map(function($data) {
        return "(" . implode(",", array_fill(0, count($data) , '?')) . ")";
    }, $datas)
)
. " ON DUPLICATE KEY UPDATE "
. implode(
@yassine-khachlek
yassine-khachlek / Flatten a multidimensional array
Last active July 30, 2016 19:47
function flatten_multidimensional_array($array, $parentKey = NULL, $output = NULL )
{
$parentKey = isset($parentKey) ? $parentKey.'_' : '';
$output = isset($output) ? $output : array();
foreach ($array as $key => $value)
{
switch (gettype($value))
{
case "string":
@yassine-khachlek
yassine-khachlek / gist:adaac618edf00188b2d3
Created March 11, 2016 14:15 — forked from sumardi/gist:3936651
Laravel nginx config
server {
listen 80;
server_name example.com;
access_log /var/log/nginx/example.com.access.log;
error_log /var/log/nginx/example.com.error.log;
root /var/www/example.com;
index index.php;
@yassine-khachlek
yassine-khachlek / cpu.js
Last active September 27, 2015 15:31
var os = require('os');
function loadAvgCpus(){
var cpus = os.cpus();
var total=0;
var idle =0;
for (var i = 0; i<cpus.length ; i++) {