Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2014
    Posts
    6

    looking for directions, thanks...

    Hi all,
    Looking for correct forum, if this isn't it.
    Following is my situation;

    I've got a home desktop with windows 8.1.
    I've got the android mit/google app inventor going on the desktop.
    I've got an external web based server space with a domain name & admin priv's.
    I've edited a file on the server with filezilla program.

    I am looking to put a simple database on the server that the android would
    access and trade a piece of information with, like one of those stock
    quote android apps.

    I am having trouble finding a way to write and access a database on the server.
    I've tried downloading the sqLite, firefox sqLite manager, the MS 2014 server manager system, and probably a couple of others.

    I feel like an idiot because I haven't been successful on any of these, so
    I keep trying to find a different simpler program. For example; latelly I've been trying to get the MS 2014 server management system installed and up and running, but
    can't seem to grasp how to get the whole thing synchronized and running. Besides, it seems like a
    huge huge system and maybe above and beyond my immediate needs.

    Therefore, If someone with more experience can direct me about how
    I should go about writing and maintaining a simple database on the server
    that can be accessed for info by an android. Or if so, which forum is best
    for that system.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    they are separate copmponents
    an android application can connect to a remote server through may different ways. possibly the easiest to set up is going to be to post data to a web script, and have that script actually insert the data into the db. but you wouold need to take into account user issues with security.

    ...it could be something as simple as a PHP script called say postdata
    http://www.pelican.com/postdata.php?...3=alphabetsoup

    there are other more direct ways of interfading an android app with a remote server.. but you will porbably need to read up on webistes focussign on android development as opposed to database development
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2014
    Posts
    6
    Thanks so much for the reply!

    I should have mentioned that the android device doesn't make any changes
    to the database. It only submits a word to the server, which looks the word
    up on the database, and trades that word for another word in the database
    depending on the submitted word.

    The database consisting of the list of words on the server is only filled and edited by someone with special privileges, not the app itself.

    I've already programmed the app on the android that accesses a website
    server with a database to trade stock symbols for current value, but
    now I need the app to access my database on the server space I have on the web, instead of a financial data website.

    I will eventually have to worry about how to access the database by the android, but first I need a database to access, or so I figure, if you agree.

    Therefore I would like to ask you all what would be the easiest way to
    get a simple database on the web based server???? Should I make one
    on my desktop and transfer it to the server by ftp or something? Or, should
    I go ahead and figure out how to write a database on the server from my desktop???

    Eventually I will have to have a method to maintain the database on the
    server, but for now I could get by just by having a simple database on the
    server to learn how to access it by the android.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    essentailly you need an ISP that will provide database hosting. to a ertain extent havign identified an ISP that may well dictate your approach to the android app interface.#

    your limiting factor is going to be how the android app talks to the remore DB, rather than which db. and becuase itws an Adnroid application then findiing the correct solution is probably best on an Android forum as opposed to a database forum. There are so mnay technologies and ways of manipulating data that its almost certain that any db provided by any ISP will do the job. but you need to fidn a mechanism that works favourably in Android. it coudl be that you end up using XML, it coudl be REST or anyone of the other alphabet soup concotions favoured by the systems world

    https://www.google.co.uk/webhp?sourc...ote+db&spell=1

    if you design your db properly form first go then there shouldnt' really need to be a maintenance task if all you are doing is submittign a word and gettign in return a synonym back. If you do need to do maintenance then personally Id do it as a separate task to the android app. heck you coudl do it as a web page/app hosted on the remote machine and access it thriugh a web client.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Aug 2014
    Posts
    6
    Hi, and thanks for the reply!

    In fact, I probably agree that accessing through a web page is probably
    the way to go,.... ..,,,,,,,.....if only I knew how to do it!
    I've heard that same thing from the friend that gave me the server space.

    Does the SSMS build and maintain a DB on a web page?
    Eventually, the DB would have to be updated continually.

    I got the SSMS up and running, and even made a simple DB,
    but I'm sure it resides on my desktop drive. I just need to find
    a way to get a DB onto the server space. Many help web sites seem
    to offer help about what to do on the server, but I can't find the
    way to connect to the server with the SSMS or whatever.

    I mean, ..should I use something like telnet or putty or something
    to connect, and then go from there? Or will SSMS connect by itself???

    Thanks !!!!!!!!!!!
    Last edited by pelican; 08-22-14 at 22:56.

  6. #6
    Join Date
    Aug 2014
    Posts
    6
    I am sure my web server will provide database hosting,
    but I don't know how it is done. Maybe you can help?

    I do not want to edit or create a DB with an android device,
    I want to create and edit with a desktop, for now anyway.
    I only want the DB to be accessed by an android device for
    a simple trade.

    For now I would be satisfied getting any DB on the server
    by any means whatsoever. I will worry about the DB being
    accessed by the android later.

    Maybe my naivite' makes my descriptions oblique to what
    I am trying to do. I apologize if that is the case.

  7. #7
    Join Date
    Aug 2014
    Posts
    6
    I am sure my web server will provide database hosting,
    but I don't know how it is done. Maybe you can help?

    I do not want to edit or create a DB with an android device,
    I want to create and edit with a desktop, for now anyway.
    I only want the DB to be accessed by an android device for
    a simple trade.

    For now I would be satisfied getting any DB on the server
    by any means whatsoever. I will worry about the DB being
    accessed by the android later.

    Maybe my naivite' makes my descriptions oblique to what
    I am trying to relate. I apologize if that is the case.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    they are separate elements
    you buy space on a webserver from an ISP
    they create the db, user account and so on
    using their tools you create the db structure, probably you'd be using MySQL as the db and PHP MyAdmin as the tool to create the tables

    you then create your connection tot eh db, I don't know what you are proposing to use, but you need somethign to allow your android client to connect to the db, as said before thats probably best explored from an android perspective. there is sufficient android documentation out there to tell you how or even what to do. bear in mind if this is a commercial application then you may also want to address the Apple IOS world... and if so you need to think very very carefully about the two (and if you add WIndows 8 mobile 3) different approaches

    for developemnt puproses create a local instance of the server you want to use. the make of server makes little difference at this stage, but could have an impact if this application is a multi thousand concurrent user. right now probably MySQL is as good as any, heck SQLite may be good enough.

    so download the server of choice (if you are going down the MySQL route then download one of the XAMPP installations, it will save a shed load of grief

    design your db, if you prefer GUI's use soemthign lkike mySQL workbench (if you are usign MySQL server), or HeidiSQL or SQL Architect

    refien the design, upload it / transfer it to the db server

    check permissions

    then interface with your android code.

    SSMS (im assui9mg you mena SQL server management) is an administration tool that manages SQL server installations, it is not in itself a db server. just as workbench is a management tool, it is not a db server. from where you are right now I'd say installing XAMPP and using MySQL is sensible route
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Aug 2014
    Posts
    6
    Looks like a lot of good information there.
    I will work through it and contact my server provider friend
    and report back. Thanks.

Tags for this Thread

Posting Permissions

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