Knight coder

Object is Beautiful

[shobhitjain]

Find out table size in mysql

SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Table size in MB" FROM information_schema.TABLES WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME";

[shobhitjain]

[shobhitjain]

forbidden : you don't have the access to / on this server

Change Order deny,allow, Allow from all to 

Require all granted on apache-2.4

[shobhitjain]

mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

Quick Workaround is:

put @ before mysql_connect to remove the warning

@mysql_connect('localhost','root','');

but as the warning is telling you, use mysqli or PDO since the mysql extension will be removed in the future.

[shobhitjain]

Switching Xcode from Xcode 2.app to Xcode.app

sudo xcode-select --switch /Applications/Xcode.app/Contents/Developer

or any Xcode version you want to switch then check if switch is successful or not by:-

xcode-select -print-path

[shobhitjain]

Set omni completion popup menu color

:highlight Pmenu guibg=brown gui=bold

In console Vim, you might want a command like this:

:highlight Pmenu ctermbg=238 gui=bold

To see how different color schemes look, try (see view all colors):

:runtime syntax/colortest.vim

Or Just put this line in .vimrc as

"highlight Pmenu ctermbg=238"

[shobhitjain]

Open IOS app directly in Itunes from browser

Prepare url like  itmss://itunes.apple.com/app/yourapp-name/idappID.

so that it will open app in the itunes. I have checked it on FF/Chrome/IE

[shobhitjain]

Extract data between Brackets MySql

Data Between Angular Brackets

SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"<") + 1), '>', 1)

Data Between Square Brackets

SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"[") + 1), ']', 1)

[shobhitjain]

ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

It seems like that 255 is the limitation on your system. so for quick workaround just change the values greater than 255 to either 255 or less than 255 . It should work

[shobhitjain]

How to expose localhost urls to world

Go to https://ngrok.com/download

Download this opensource software and unzip it

Open the terminal and type ngrok 80

It should show output like below

ngrok Tunnel Status online Version 1.3/1.3 Forwarding http://3a4bfceb.ngrok.com -> 127.0.0.1:80 Forwarding https://3a4bfceb.ngrok.com -> 127.0.0.1:80 Web Interface http://127.0.0.1:4040 # Conn 0 Avg Conn Time 0.00ms

Now access http://3a4bfceb.ngrok.com from anywhere

You can also specify domain name like ngrok --subdomain shobhit 80 and access urls like shobhit.ngrok.com

[shobhitjain]

This is a open-source Python implemented code which helps in resizing , scaling , face detection ,applying filters for images . it works very well .

[shobhitjain]

installing setuptools python on mac or ubuntu

 Open Terminal

 Download setuptools script to desktop

Navigate to script location or give full path like /Users/shobhit/Desktop/ezsetup.py

python ezsetup.py

It will install python setuptools on your system

If you need to install this separately then use virtualenv

[shobhitjain]

Run redis as daemon automatically in mac os on boot

Redis will now automatically be started after every boot. You can manually start it without rebooting with:

Add these to bash_profile

alias redisstart=’sudo launchctl start io.redis.redis-server’

alias redisstop=’sudo launchctl stop io.redis.redis-server’

[shobhitjain]

WHAT IS YOUR EARLIEST HUMAN MEMORY?

My Engagement :)

[shobhitjain]

Your top 100 Unix Commands

history | sed "s/^[0-9 ]*//" | sed "s/ *| */\n/g" | awk '{print $1}' | sort | uniq -c | sort -rn | head -n 100 > commands.txt