Welcome to the resources section of my site. Here you will find a collection of tools, tips and projects I work on, or support as part of my free time developments. Most of them are Java based and a few are based on other languages. So, as this is a place where I put up a few things I do during my spare time at home, I will start by showing you a simple application I wrote to demonstrate how to use the superb open source database engine - SQLite.

SQLite
Stock Trade Ticker
MySql Connection problem

SQLite

SQLite is a very small database engine and because it's written in The C Programming Language, its lightning fast. The small footprint of the application makes it ideal for embedding in another application.

Talking about embedding, in our next article, we will look into how to develop an embeded application. If you are a fan of J2ME or you want to learn how to develop applications for mobile devices, why not check out my tutorial on J2ME development?


Stock Trade Ticker

In this section, I have included a sample Client/Server application I wrote for a friend to illustrate the act of developing a real-time Stock Trading Applications that you are likely to see in the financial institutions. Though most, if not all Trading applications, have more options and configuration settings, because this is a simple demo or prove of concept, it does not include all the bells and wistles you would expect to find in a full blown application. More... 
 private static final int PERIOD = 5000;     // repeat every 5 seconds
    private static final int RANDOM_NUMBER = 999;

    Socket socket; // the socket
    PrintWriter out; // the output and input streams
    BufferedReader in;

    static Vector vector; // current connections

    public static void main (String[] args)
    {
        ServerSocket ss = null;
        Socket s = null;
        vector = new Vector ();

		More...

MySql Connection problem

If you have struggled to connect to a remote mysql server that is running on a Unix/Linux server and have not been able to, you are not the only one. By default, Mysql server on Unix/Linux restricts access to connections made only from local host. Which means, if you have a web server on the same server as your database, you may not notice this restrictions as the two services are running on the same localhost.

However, to enable you to connect remotely using any language of your choice, you would need to have a root access to the server and configure just a single line in the 'my.cnf' as found on Ubuntu Linux. 
Follow these steps carefully with a root permission:
In the mysql configuration file (/etc/mysql/my.cnf) comment the line (63): look for a line that contains 
'bind-address = 127.0.0.1' and disable it by adding a hash in front like so:
#bind-address = 127.0.0.1

restart mysql (/etc/init.d/mysql restart)

Now, you are ready to connect remotely

more to come