ayberkcal’s gists

ayberkcal / mysql-faster-imports.sh

Created November 29, 2020 02:19 — forked from OZZlE/mysql-faster-imports.sh

Linux Bash Script to toggle faster mysql db imports

	#!/usr/bin/env bash

	# USAGE: mysqlOptimizeForImports <- before importing
	# mysqlDefaultSettings <- to go back to normal

	# Based on https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster/83385#83385

	mysqlStateFile="$HOME/mysql.optimized.for.exports"
	mysqlConfigLocation="/etc/mysql/my.cnf" # <-- change to the correct for your system, should be for global mysql settings

ayberkcal / Türkiye'de Faaliyet Gösteren Bankalar

Created January 29, 2020 15:55

	Türkiye Cumhuriyeti Ziraat Bankası A.Ş.
	Türkiye Halk Bankası A.Ş.
	Türkiye Vakıflar Bankası T.A.O.
	Türkiye İş Bankası A.Ş.
	Yapı ve Kredi Bankası A.Ş.
	Türkiye Garanti Bankası A.Ş.
	ING Bank A.Ş.
	HSBC Bank A.Ş.
	QNB Finansbank A.Ş.
	Türk Ekonomi Bankası A.Ş.

ayberkcal / gist:e8957b0641e459e5ead5e397b195d79d

Created December 20, 2018 10:30

	{
	"permissions": {
	"canRead": true,
	"canWrite": true
	},
	"processGroupFlow": {
	"id": "7d458cb3-6730-3d24-36c5-495b9e6161ae",
	"uri": "http://10.20.20.45:8080/nifi-api/flow/process-groups/7d458cb3-6730-3d24-36c5-495b9e6161ae",
	"parentGroupId": "c02a1916-0167-1000-4d76-b989ded530b3",
	"breadcrumb": {

ayberkcal / gist:c641c798472e088eac71ed41ce53c8e8

Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435

Keeping a fork up to date

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

ayberkcal / gist:3c64fad26775758627696518c78699ca

Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435

Keeping a fork up to date

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream

ayberkcal / jobs.sql

Created July 27, 2014 19:20 — forked from hasantayyar/jobs.sql

	/*
	* source: https://github.com/onurdegerli/job-titles
	*/
	CREATE TABLE IF NOT EXISTS `job_title` (
	`job_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`parent_job_title_id` int(10) unsigned NOT NULL DEFAULT '0',
	`title_en` varchar(255) NOT NULL,
	`title_tr` varchar(255) NOT NULL,
	`url` varchar(255) NOT NULL,
	PRIMARY KEY (`job_title_id`)

ayberkcal / pk.sql

Created July 27, 2014 19:18 — forked from serdardalgic/pk.sql

This file has been truncated, but you can view the full file.

	/*
	Türkiye'nin il, ilçe , semt, mahalle, posta kodu veritabanı
	GÜNCEL : 19.04.2013
	Kaynak : PTT
	Oluşturan : http://www.twitter.com/tserpico

	*/
	DROP TABLE IF EXISTS `pk`;
	CREATE TABLE `pk` (

ayberkcal / name_gender.csv

Created July 27, 2014 19:10 — forked from muatik/name_gender.csv

ayberkcal / cities.json

Created July 27, 2014 19:05 — forked from muatik/cities.json

ayberkcal / word_country_data.sql

Created July 27, 2014 19:05 — forked from muatik/word_country_data.sql

	-- MySQL dump 10.13 Distrib 5.1.51, for pc-linux-gnu (i686)
	--
	-- Host: 127.0.0.1 Database: world
	-- ------------------------------------------------------
	-- Server version 5.1.51-debug-log

	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
	/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;

clbk ayberkcal