Skip to content

Instantly share code, notes, and snippets.

@emrahoruc
emrahoruc / Change-PostgreSQL-Data-Directory.md
Last active January 22, 2025 10:57
Change PostgreSQL Data Directory

1. Locate Current Data Directory
Find the current data directory (default: /var/lib/pgsql/13/data):

sudo -u postgres psql -c "SHOW data_directory;"

2. Stop PostgreSQL Service

sudo systemctl stop postgresql-13

3. Move Data to the New Location

@emrahoruc
emrahoruc / grafana_backup.sh
Last active December 30, 2024 18:28
Backup Script for Grafana Configuration and Data
#!/bin/bash
# Backup file name and location
BACKUP_DIR="/path/to/backup"
BACKUP_FILE="$BACKUP_DIR/grafana_backup_$(date +%Y%m%d_%H%M%S).zip"
# Files and directories to be backed up
GRAPHANA_DB="/var/lib/grafana/grafana.db"
GRAFANA_CONF="/etc/grafana/grafana.ini"
GRAFANA_PLUGINS="/var/lib/grafana/plugins"
@emrahoruc
emrahoruc / slow-download.php
Created December 21, 2022 14:28
Limit download speed using PHP
<?php
// source https://stackoverflow.com/a/12245044/3254912
set_time_limit(0);
$file = array();
$file['name'] = 'image.JPG';
$file['size'] = filesize($file['name']);
@emrahoruc
emrahoruc / HttpServer.cs
Created November 11, 2022 13:53 — forked from define-private-public/HttpServer.cs
A Simple HTTP server in C#
// Filename: HttpServer.cs
// Author: Benjamin N. Summerton <define-private-public>
// License: Unlicense (http://unlicense.org/)
using System;
using System.IO;
using System.Text;
using System.Net;
using System.Threading.Tasks;
@emrahoruc
emrahoruc / EPSG.md
Last active October 10, 2022 15:54
EPSG 3857 and 4326
  • EPSG:4326 is in degrees - 3D sphere
    Bounds:
    -180.0 -90.0
    180.0 90.0

  • EPSG:3857 is in metres - 2D projection
    Bounds:
    -20037508.34 -20048966.1
    20037508.34 20048966.1

@emrahoruc
emrahoruc / google-chrome-updater.sh
Created September 2, 2022 15:32
Google Chrome Updater (Ubuntu)
#!/bin/bash
sudo apt-get update
sudo apt-get --only-upgrade install google-chrome-stable
@emrahoruc
emrahoruc / launch.json
Created March 30, 2022 10:29
PHP 7.4 + Xdebug 3.1 + Vscode
{
// Use IntelliSense to learn about possible attributes.
// Hover to view descriptions of existing attributes.
// For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
"version": "0.2.0",
"configurations": [
{
"name": "Listen for Xdebug",
"type": "php",
"request": "launch",
@emrahoruc
emrahoruc / config.php
Created January 27, 2022 00:21
Codeigniter 3.011 base_url detection
<?php
# Source: https://codeigniter.com/userguide3/installation/upgrade_303.html
$config['base_url'] = ['domain1.tld', 'domain2.tld'];
if (in_array($_SERVER['HTTP_HOST'], $config['base_url'], true)) {
$domain = $_SERVER['HTTP_HOST'];
} else {
$domain = $config['base_url'][0];
}
@emrahoruc
emrahoruc / public test videos.txt
Last active November 22, 2021 06:59 — forked from jsturgis/gist:3b19447b304616f18657
public test videos
var mediaJSON = { "categories" : [ { "name" : "Movies",
"videos" : [
{ "description" : "Big Buck Bunny tells the story of a giant rabbit with a heart bigger than himself. When one sunny day three rodents rudely harass him, something snaps... and the rabbit ain't no bunny anymore! In the typical cartoon tradition he prepares the nasty rodents a comical revenge.\n\nLicensed under the Creative Commons Attribution license\nhttp://www.bigbuckbunny.org",
"sources" : [ "http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/BigBuckBunny.mp4" ],
"subtitle" : "By Blender Foundation",
"thumb" : "images/BigBuckBunny.jpg",
"title" : "Big Buck Bunny"
},
{ "description" : "The first Blender Open Movie from 2006",
"sources" : [ "http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/ElephantsDream.mp4" ],
@emrahoruc
emrahoruc / Coolphpobfuscator.java
Created April 6, 2021 15:58 — forked from MasterEx/Coolphpobfuscator.java
A PHP code obfuscator implemented in java as a proof of concept
package coolphpobfuscator;
import java.io.File;
import java.io.FileNotFoundException;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.Scanner;