
PostgreSQL psql console commands
Connecting for the first time sudo -u postgres psql Set the password \password postgres Logging in psql -h localhost -p <port no> -U <username> <database name> Commands list \h help on SQL commands \? help on psql com...
Configure Gmail SMTP in Bootstrap _initAutoload() $config = array('ssl' => 'ssl', 'auth' => 'login', 'port' => 465, 'username' => 'YOUR USERNAME', 'password' => ...
Install the rbenv and Ruby dependencies sudo apt-get install git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties l...
Download Ruby and install Check ruby installation: ruby -e "puts 1+1" -> 2 irb - for interactive ruby commands Download devkit for corresponding ruby version and extract to c:\devkit Browse to c:\devkit and run this: ruby dk.rb init type...
SELECT name, birthday, MONTH(NOW()), DAY(birthday), DAY(NOW()), DAY(NOW())+7 FROM test WHERE MONTH(birthday) = MONTH(NOW()) AND DAY(birthday) BETWEEN DAY(NOW()) AND DAY(NOW())+7
The solution is to keep count of the number of times the function is called to execute AJAX request and on failed requests recall the function. The retryLimit can be modified to the number to times the AJAX function is called. function callback()...
Forgot mysql server password? Are you looking at this page because you cannot access the mysql server installed on your pc/server when you were trying to see if it works well? Or do you receive error messages like the following? : ERROR 1045: Ac...
Development Install Ruby Install DevKit (http://rubyinstaller.org/downloads/) gem install capistrano --no-ri --no-rdoc Deployment Machine Update the software sources list And upgrade the dated applications: aptitude update aptitud...
To run server.js, the socket.io file Install nodejs globally. install npm globally go to your project folder and install npm modules npm install connect npm install socket.io Make sure the port your're using is open in the iptables, if not...