Category

Programming Guides

8 posts in this category.

• July 2, 2014 / 1 min read

  Installing Software on Ubuntu Server 14.04

  Install Oracle Java 7 on Ubuntu: sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java7-set-default Install Glashfish 4 on Ubuntu: #Download Glassfish 4 wget download.java.n...

  How To'sProgramming Guides

  

• April 17, 2014 / 1 min read

  Ignore Foreign Key Constraints During Truncate or Drop

  If you are trying to drop/delete or empty/truncate a mysql table and you keep getting an error that you are violating a foreign key constraint, you may want to temporarily ignore that constraint. The code below demons...

  How To'sProgramming Guides

  

• April 1, 2014 / 1 min read

  Create new MySQL user and allow them to connect from any IP

  If you are getting the error: user is not allowed to connect to this MySQL serverConnection closed by foreign host Or : Access denied for user 'root'@'somehost.com' (using password: YES)) Then you probably have not cr...

  Programming Guides

  

• March 28, 2014 / 1 min read

  MySQL See all columns and tables that foreign key to a table or column

  If you're trying to understand how an existing database has been setup it can be very useful to see all of the tables/columns that foreign key into some other table/column. use INFORMATION_SCHEMA; select TABLE_NAME,CO...

  Programming Guides

  

• March 24, 2014 / 1 min read

  Ruby MySQL Transaction Example

  Here is a simple tutorial showing how to implement transactions in Ruby with MySQL. The code uses The MySQL2 Gem. We are showing the insert of 2 records into the customers table of a database. If either insert fails,...

  Programming Guides

  

• March 23, 2014 / 1 min read

  Setup a new GIT repository

  Here is a quick reminder of how to setup a new git repository on your git server and check it out on your client machine. On The Server cd /opt/git mkdir newproject.git cd newproject.git git --bare init On the Client...

  Programming Guides

  

• January 26, 2010 / 1 min read

  C++ Execute Shell Command

  How to execute a shell command from within c++ code

  Programming Guides

• January 26, 2010 / 1 min read / 1 comments

  C++ Convert String to Char Array

  C++ Convert String to Char Array | Convert a string to an array of characters

  Programming Guides