Skip to content

Instantly share code, notes, and snippets.

@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 / 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 / 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 / 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 / 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