Looking for a cheap online mySQL database

cbrunsdonza said:

Just get a cheap hosting package with a free domain (actually, its a sub domain)

Click to expand...

Amazon RDS free trial (Per Month):
750 hours of Amazon RDS Small Single-AZ Instance usage – enough hours to run continuously each month
20 GB of database storage
10 million I/Os
20 GB of backup storage for your automated database backups and any user-initiated DB Snapshots
The free trial applies to MySQL Single-AZ deployments and the Oracle “Bring-Your-Own-License (BYOL)” licensing model. In addition to these services, the AWS Management Console is available at no charge to help you build and manage your Database Instances on Amazon RDS.

Click to expand...

Big Bean said:

None of the free web hosting allow me a JDBC connection

also I have signed up for that site already but I never recieve a mail with my details (I checked spam folder).

I am currently using db4free.net but it is very slow

Click to expand...

import java.sql.*;
import javax.sql.*;
import java.io.*;
public class jdbcdemo{
public static void main(String args[]){
String dbtime;
String dbUrl = "jdbc:mysql://db4free.net:3306/reserve";
String dbClass = "com.mysql.jdbc.Driver";
String query = "SELECT Date FROM public_sightings WHERE DATE >= DATE_SUB(NOW(), INTERVAL 3 DAY) AND Date <= NOW() AND isModerated = true";
String user = "**";
String pw = "**";

try {

Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection (dbUrl,user,pw);
long startTime = 0;
long stopTime = 0;
startTime = System.currentTimeMillis();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
dbtime = "" + rs.getTimestamp("Date");
System.out.println(dbtime);

stopTime = System.currentTimeMillis();
System.out.println("Delay:" + (stopTime-startTime));

con.close();
} //end try
catch(ClassNotFoundException e) {
e.printStackTrace();
}

catch(SQLException e) {
e.printStackTrace();
}
} //end main
} //end class

Click to expand...