Skip to content

Instantly share code, notes, and snippets.

View serkaniyigun's full-sized avatar

Serkan İyigün serkaniyigun

View GitHub Profile
@serkaniyigun
serkaniyigun / gist:0662799aeceb3861f879827ca6f4e8a0
Created April 29, 2019 08:11
Rails Project PostgreSQL to MySQL
Step 1
Make a backup copy of your data
For Rails 3, install the YAML DB gem: https://github.com/ludicast/yaml_db
For Rails 2.x install the YAML DB plugin:
@serkaniyigun
serkaniyigun / postgres-cheatsheet.md
Created January 10, 2018 10:35 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Keybase proof

I hereby claim:

  • I am serkaniyigun on github.
  • I am srkn (https://keybase.io/srkn) on keybase.
  • I have a public key ASDc_XAnxVp1T9G6Z05JIK9WcJ--AxnJ7a62_U77p7Sedgo

To claim this, I am signing this object:

@serkaniyigun
serkaniyigun / tor browser arch linux
Created September 27, 2015 17:11
tor browser arch linux aur pgp key error
curl "https://pgp.mit.edu/pks/lookup?op=get&search=0x2E1AC68ED40814E0" -o - | gpg --import

Mac OS X 10.10 Yosemite

Custom recipe to get OS X 10.10 Yosemite running from scratch, setup applications and developer environment. I use this gist to keep track of the important software and steps required to have a functioning system after a semi-annual fresh install. On average, I reinstall each computer from scratch every 6 months, and I do not perform upgrades between distros.

This keeps the system performing at top speeds, clean of trojans, spyware, and ensures that I maintain good organizational practices for my content and backups. I highly recommend this.

You are encouraged to fork this and modify it to your heart's content to match your own needs.

Install Software

iTerm2

http://www.iterm2.com/#/section/downloads

Get the iTerm color settings

https://raw.github.com/altercation/solarized/master/iterm2-colors-solarized/Solarized%20Dark.itermcolors

Apply them in iTerm through iTerm -> preferences -> profiles -> -> colors -> load presets -> import. You can create a different profile, other than Default if you wish to do so.

@serkaniyigun
serkaniyigun / gist:10506125
Created April 11, 2014 22:17
curl ca cert
export CURL_CA_BUNDLE=/path/to/ca-bundle.crt
@serkaniyigun
serkaniyigun / gist:9649920
Created March 19, 2014 19:55
qmail clear queue
#!/bin/bash
echo "Stopping Qmail - MinisterAlan"
/etc/init.d/qmail stop
echo "Clearing the Mail Queue"
cd /var/qmail/queue/info
@serkaniyigun
serkaniyigun / gist:9649880
Created March 19, 2014 19:53
linux find large files
must be root
for i in G M K; do du -ah | grep [0-9]$i | sort -nr -k 1; done | head -n 11
@serkaniyigun
serkaniyigun / memorycoin-qt-patch
Last active January 2, 2016 21:29
memorycoin-qt-patch
diff --git a/memorycoin-qt.pro b/memorycoin-qt.pro
index d938c07..e1dd4ec 100644
--- a/memorycoin-qt.pro
+++ b/memorycoin-qt.pro
@@ -353,7 +353,7 @@ isEmpty(BOOST_THREAD_LIB_SUFFIX) {
}
isEmpty(BDB_LIB_PATH) {
- macx:BDB_LIB_PATH = /opt/local/lib/db48
+ macx:BDB_LIB_PATH = /usr/local/opt/berkeley-db4/lib