Skip to content

Instantly share code, notes, and snippets.

View mertcelen's full-sized avatar

Mert ÇELEN mertcelen

View GitHub Profile
@abdullahoguk
abdullahoguk / il.csv
Last active October 8, 2025 06:59
Türkiye'deki İllerin Enlem Boylam Bilgileri (JSON ve CSV) Kaynak: https://gist.github.com/ismailbaskin/2492196
plaka il_adi lat lon northeast_lat northeast_lon southwest_lat southwest_lon
1 ADANA 37.00000000 35.32133330 37.07200400 35.46199500 36.93552300 35.17470600
2 ADIYAMAN 37.76416670 38.27616670 37.82566700 38.33546500 37.71708600 38.18818800
3 AFYONKARAHİSAR 38.76376000 30.54034000 38.80210500 30.61116700 38.71428900 30.44232000
4 AĞRI 39.72166670 43.05666670 39.74860500 43.08524100 39.68814400 43.00177800
5 AMASYA 40.65000000 35.83333330 40.67283400 35.85632100 40.63691100 35.78909100
6 ANKARA 39.92077000 32.85411000 40.10098100 33.02486600 39.72282100 32.49909700
7 ANTALYA 36.88414000 30.70563000 36.97517800 30.84095300 36.78586600 30.51609500
8 ARTVİN 41.18333330 41.81666670 41.20707800 41.85479900 41.15541500 41.77736100
9 AYDIN 37.84440000 27.84580000 37.87099700 27.88535500 37.81957300 27.79052200
@seanthegeek
seanthegeek / installpwshdeps.sh
Last active October 25, 2019 03:43
Installs missing dependencies from Debian 9 (stretch) for Powershell on Debian 10 (buster) and higher (including Kali Linux)
#!/bin/bash
# Installs missing dependencies from Debian 9 (stretch) for Powershell on Debian 10 (buster) and higher (including Kali Linux)
mkdir /tmp/pwshtmp
cd /tmp/pwshtmp
wget http://http.us.debian.org/debian/pool/main/i/icu/libicu57_57.1-6+deb9u3_amd64.deb
wget http://http.us.debian.org/debian/pool/main/i/icu/icu-devtools_57.1-6+deb9u3_amd64.deb
wget http://http.us.debian.org/debian/pool/main/u/ust/liblttng-ust0_2.9.0-2+deb9u1_amd64.deb
wget http://http.us.debian.org/debian/pool/main/libu/liburcu/liburcu4_0.9.3-1_amd64.deb
@beledouxdenis
beledouxdenis / dell-vostro-5481-noisy-fan.md
Last active February 25, 2020 10:16
Dell Vostro 5481 Ubuntu Noisy fans solution

Make sure to disable secure boot in bios, otherwise /usr/local/bin/dell-bios-fan-control 0 will return a segfault.

cd /tmp
git clone https://github.com/TomFreudenberg/dell-bios-fan-control
cd dell-bios-fan-control
make
sudo cp dell-bios-fan-control /usr/local/bin/
sudo apt install i8kutils
sudo mkdir /etc/systemd/system/i8kmon.service.d
echo "[Service]
@estorgio
estorgio / Mounting VirtualBox shared folders on Ubuntu Server 16.04 LTS.md
Last active September 27, 2025 02:50
Mounting VirtualBox shared folders on Ubuntu Server 16.04 LTS

Update 28 July 2019: An updated version of this guide for Ubuntu Server 18.04 LTS is now available. Feel free to check it out.

Update 23 May 2020: This guide is ALREADY OUTDATED and might no longer work with new versions of Ubuntu and VirtualBox. Please consider switching to the updated guide instead. I will no longer respond to the replies to this gist. Thank you.

Mounting VirtualBox shared folders on Ubuntu Server 16.04 LTS

This guide will walk you through steps on how to setup a VirtualBox shared folder inside your Ubuntu Server guest. Tested on Ubuntu Server 16.04.3 LTS (Xenial Xerus)

@mul14
mul14 / 00_etc-hosts.md
Last active November 18, 2025 07:42
/etc/hosts for Vimeo, Reddit, Imgur, GitHub, DigitalOcean, dll

Unblock Steam, Vimeo, Reddit, Imgur, GitHub, DigitalOcean, NPM, PayPal, dll

Saya support Internet Positif untuk memblokir porn, situs judi, dan hal-hal ilegal lainnya. Tapi pemerintah dan ISP sangat konyol karena tidak mengizinkan akses ke Vimeo, Reddit, Imgur, Netflix--yang mana bukanlah situs dengan konten utama ilegal.

Linux / BSD / macOS

Tambahkan list di bawah ke /etc/hosts.

Windows

@bzerangue
bzerangue / macs-on-active-directory.md
Last active August 6, 2025 19:23
Binding and Unbinding to Active Directory from Mac OS via Command Line

Binding and Unbinding to Active Directory from Mac OS via Command Line

  • Open the Terminal Application
  • Type in sudo -i and type in your Mac Administrator account password. sudo gives you root level or administrator level privileges.

To View current Active Directory Settings

dsconfigad -show

To Unbind a Computer from an Active Directory Domain

@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active December 5, 2025 09:56
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'