Facebook   Twitter    YouTube    RSS Feed    Android App    iPhone and iPad App     BlackBerry App    
Subscribe to Newsletter



Results 1 to 11 of 11

Thread: Looking for a cheap online mySQL database

  1. #1
    Senior Member
    Join Date
    Dec 2009
    Location
    Durbanville, Cape Town
    Posts
    466

    Default Looking for a cheap online mySQL database

    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.

  2. #2
    Super Grandmaster Nod's Avatar
    Join Date
    Jul 2005
    Location
    Pretoria
    Posts
    6,912

    Default

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

  3. #3

    Default

    Just get a cheap hosting package with a free domain (actually, its a sub domain)
    Character is how you treat those that can do nothing for you.

  4. #4
    Senior Member
    Join Date
    Dec 2009
    Location
    Durbanville, Cape Town
    Posts
    466

    Default

    Quote Originally Posted by cbrunsdonza View Post
    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
    Last edited by Big Bean; 16-04-2012 at 04:08 PM.

  5. #5

    Default

    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.


  6. #6

    Default

    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 )

  7. #7

    Default

    "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?
    █► AllWorldIT ~ www.allworldit.com ~ International IT Solutions
    █► ISP / Hosting / Carrier Solutions , Wholesale ADSL & Hosting

  8. #8

    Default

    Quote Originally Posted by Big Bean View Post
    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.

  9. #9

    Default

    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
    I don't say much, but if I do say something, it pays to listen.

  10. #10

    Default

    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?

  11. #11
    Senior Member
    Join Date
    Dec 2009
    Location
    Durbanville, Cape Town
    Posts
    466

    Default

    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

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •