Skip to content

Instantly share code, notes, and snippets.

View ayberkcal's full-sized avatar

clbk ayberkcal

19 followers · 50 following
View GitHub Profile
@ayberkcal
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
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
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
ayberkcal / gist:c641c798472e088eac71ed41ce53c8e8
Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@ayberkcal
ayberkcal / gist:3c64fad26775758627696518c78699ca
Created March 3, 2017 07:18 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
@ayberkcal
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
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` (
`mahalle_id` bigint(10) NOT NULL AUTO_INCREMENT,
@ayberkcal
ayberkcal / name_gender.csv
Created July 27, 2014 19:10 — forked from muatik/name_gender.csv
Aad M
Aadam M
Aaden M
Aadje F
Aadu M
Aaf ?F
Aafke ?
Aafkea F
Aafko M
Aage M
@ayberkcal
ayberkcal / cities.json
Created July 27, 2014 19:05 — forked from muatik/cities.json
[
{
"city": "Oranjestad",
"code": "AW"
},
{
"city": "Kabul",
"code": "AF"
},
{
@ayberkcal
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 */;