Featured Article

Indie Graphics Builder #2 (Create Sprites for Your Game)

Kickstarter project i am suporting, if you are developing a game and you are in need of same graphic sets this is what you need! Ready to develop your game?  My friends and I bring you the “The Indie Graphics Builder.”  For way less then the price you’d pay an artist to make graphics for […]

Featured Article

Make money showing ads in your android app

Selling your application is only one of the possibilities to gain money with your android application. The other way, which works fine for any app which got many downloads is to show publicity and get paid either for impressions of these or for clicks your user do on them. Most of the advertisement provider will […]

ListView with checkboxes inside

This example will show howto use checkboxes inside a ListView. First we will create the activity which contain the listview. It extends ListActivity so we only need to set the main layout and create the adapter for the ListView. public class CheckboxListActivity extends ListActivity {   @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState);   setContentView(R.layout.activity_checkbox); […]

Autoclose dialog after some time

Example of an dialog in android using the class DialogFragment which will close itself after aproximate three seconds. Basicly is just a DialogFragment which starts a thread when it is shown which will sleep for the three seconds and then close the dialog again. public class AutocloseDialog extends DialogFragment { @Override public View onCreateView(LayoutInflater inflater, […]

AsyncTask for Image download

If you have an ImageView which will has to display an image which has to be downloaded first it is best practise to download the image in a seperate Task. The following AsyncTask will download an image from an given URL and assign it to a existing ImageView.   package com.example;   import java.io.InputStream; import […]

Kill running process

Howto kill a process in Mysql If you have a “hanging” process in MySQL and want to kill it, you use show processlist to identify the process you want to kill get get the id. Then a simple kill ID will do the job. mysql> show processlist; +—–+——+———–+———+———+——-+——-+——————+ | Id | User | Host | […]

Compare two MySQL databases

If you need to compare the structure or maybe even the content of two MySQL databases you will need a tool which will help you with this not too straight task. Here is an overview of some application which will help you succeeding the work. Percona Toolkit  Has several database comparison and syncing tools among […]

Connect to MySQL with Perl using DBI

Example of a connection to MySQL with Perl using DBI #! /usr/bin/perl -w # # Example code to connect to MySQL, create a table, fill it with some data and select it again. # # To install DBI using cpan: # # perl -MCPAN -e shell # cpan> install DBI # cpan> install DBD::mysql # […]


If you have to store big texts in MySQL you have to choose in between using a big VARCHAR column and the TEXT type. So what are the differences between using for example a VARCHAR(2000) and TEXT? The difference between TEXT and the VARCHAR type is how MySQL is storing the data. TEXT (and BLOB) […]

Quick Status in MySQL

To get a briest status overview of your MySQL server, you can use the command \\n, it will give you a fast idea of the version you are running, the most important settings and an overview of the amount of running queries. mysql> \s ————– mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (i686) using readline […]

Getting XML and HTML output.

Many people use MySQL in the console to execute a simple command, but did you know that MySQL can format the result of the query directly to XML or html? The option -X will output the query result as XML -H can be used to generate a HTML table containing the data. $ mysql -X […]