Looking for a cheap online mySQL database

[Big Bean]

Hey

I am looking for a cheap mySQL database that I can use to hook up my java program to (i.e. it needs to allow for remote connection). I need one that is either situated in SA or EU (to minimize latency). It is going to be using very little traffic and data but latency is key. Does anyone know of a good site where I can get one.

[Nod]

Found via google: http://www.mysqlforfree.com/

[cbrunsdonza]

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

[Big Bean]

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

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

[rward]

Try amazon web servers.

I think they might have a free db promotion going now.
http://aws.amazon.com/rds/

Amazon RDS 60 Day Free Trial : http://aws.amazon.com/rds/free-trial/

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.

[Anthro]

I can provide you with a EU or SA based MYSQL capable site (not using atm) PM me if you are interested - its free after all )

[nkawit]

"cheap" is very broad, I could give you 1Gb of MySQL db for $0.50 .... but it may take 30 seconds for a query, what exactly do you need and whats your budget?

[deweyzeph]

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

You're not making any sense about the JDBC connection. JDBC runs on whatever platform your client app is running, so it's irrelevant whether or the host that's running the MySQL database supports JDBC or not.

[graviti]

I think he's implying without being aware that he's implying that the MySQL listens on port 3306, but is probably not listening on the external IP. Most hosts usually only allow tcp connections to 3306 using localhost only. If so he needs a service that allows external connections to MySQL with a low latency. This sounds like either a dodgy project or one where you should spend the dosh and get your own server setup for more custom setups. Not that I'm saying there aren't providers out there who supply what he wants

[AnthIste]

Look I have no idea what your project entails here, but do you really need an external JDBC connection? What about a request/response model where the database access is just handled server-side?

[Big Bean]

Hey guys, I do not have any malicious intentions with my program.
On a very basic level I want to connect as follows and do queries and updates etc. but obviously object orientated.
I do not have a wide range of knowledge of mySQL so if you can direct me to a better way of connecting to the mySQL database then let me know.
Here is a very very basic connection and query that I use for testing:

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