January 10, 2013

can i use SQL to create a database for my mobile app?

Q. can i use SQL server 2005 to create and manage a database of games scores for a mobile phone game application that i am using Adobe Flash MX Professional to build?
well i want to keep track of high scores, save and update them. can i use a simple text file to do that? and if yes how?

A. SQL Server would work fine for this application - with the understanding this is a distributed client / server application. Having said that - if you do decide to build this in Flash I feel compelled to tell you that:

1) You will have better luck building this application in Adobe Flex rather than Adobe Flash because Flex is geared more towards business applications (Input/Process/Output) like this

2) Flash only runs on a few phones running the Android O.S. and will NEVER run on or be ported to the iPhone. Macintosh has made this very clear. I do not know what Microsoft has plans for - I imagine if they don't already, they will eventually support it on thier smart phone.

UPDATE: LOL - The database WOULD NOT / CAN NOT run on the mobile device. They don't make databases for mobile phones...

@Jim: While I am sure somebody will try to do this (not with MySQL, more likely HSQLDB) - what is the point. Who is going to connect to it? The whole point of a database of that nature is to distribute the data to other clients. Not to mention the disk space of a minimum of 180 mb w/o data, memory (20 mb of RAM at idle) not to mention CPU cycles to crunch data. Mobile phones connect to data primarily through web services via a web server that connects to a database server. The phone only needs to know how to query the data and display the results. Simple SOAP calls and XML responses are needed. The database is on the other end of the spectrum.

Earnest: The paradigm for this type of application is this.

1) Build a database to maintain scores and your clients accessing these scores
2) Build a service that will retrieve these scores by whatever filter you wish to use
3) Build a mobile phone app to poll the service based on your filter and to read and display the scores via your presentation layer.

You will need a hosting provider - I highly suggest you consider learning coldfusion as it is the easiest language to learn with a lower than normal learning curve. Likewise - coldfusion will create your web services for you automatically via CFC's It's a good beginner project - I would encourage you to look into it.

My experience: 15 years software architecture and engineering, seasoned professional in Java, .Net and ColdFusion to name a few. Good luck :-)

Lastly - If all you are doing is saving the score from a game you created on the phone. No, you cannot write to the phone. Flash is not allowed to write to the system for security reasons. Adobe AIR can though - but it won't run on a phone either


What program can I used to convert GIF to FLASH?
Q. I need to convert a gif to swf format to use it in a profile, I have mac what program can I used to do this? thank you. If you could do it for me that would be great as well :D

http://i531.photobucket.com/albums/dd359/Linny_Cat/Gaia/RinoaGIFtest.gif

That's the gif its a little big, looking for best quality.

A. Hewbo Video Converter can help you convert gif to swf on MAC, An easiest way to convert all videos to AVI, DivX AVI, XviD AVI, 3GP, 3G2, MP4, WMV, MKV, TS, FLV, SWF, MOV, GIF, MP3, MP2, OGG, WMA, WAV, AAC, AC3, AU, MMF, M4A, or used on iPhone, iPod, iPad, Apple TV, Android devices, PSP, PS3, XBOX360, ZUNE, Nokia, BlackBerry, Sony Ericsson, Motorola, LG, Samsung, Blu-ray disc, NTSC DVD, PAL DVD, and more.
http://www.hewbo.com/


How do I pick out a tablet?
Q. Ok, I am a student using one for school. I have $180, and I am thinking about getting a nook and turning it into a tablet.

Is there any older tablets for the same price or less that could do more? thanks!

A. Superpad 10.2" Tablet PC keeps you connected and entertained everywhere you go! The touch screen Superpad Google Android comes with a built in webcam for video chat, Wifi, and numerous cable ports, including two micro SD slots which support up to 32GB (16gb per slot, sold separately), two USB sockets (for key board/mouse/USB flash disk), an audio jack, one HDMI socket, one RJ45 socket (Ethernet) for super-fast wired internet connection.


how to put a phones sd card into a computer?
Q. im trying to put videos on my computer from my phone there doesn't seem to be a slot for it. im very confused. my phone is an android 2 and my laptop is hp pavilion entertainment PC i don't know if this helps, but it has aa intel duo core 2 processor and windows vista

A. Most computers will not have an SD card port on them. Some do, and some don't.

You can get something like this:

http://www.google.com/products/catalog?q=SD+card+USB+adapter&oe=utf-8&rls=org.mozilla:en-US:official&client=firefox-a&um=1&ie=UTF-8&cid=16260389861761486420&sa=X&ei=EFfCTcvIE6TfiAKk86iqAw&ved=0CE0Q8gIwAQ#

to connect an SD card through a USB port into your computer, or also, your Android probably has a Micro-USB port on it. A micro-USB cable has one end shaped like a normal rectangular USB and the other like a trapezoid, like one of the three to left of this image:

http://en.wikipedia.org/wiki/File:Usb_connectors.JPG

The micro-USB port might be behind a flap on your phone. You can get the cables for like a dollar online or in a store like Fry's Electronics -- if you pay more than a few bucks you're getting ripped off (Make sure there's a port first! Since I have no idea if all Androids have them [They should] the newer ones do for sure). Then just plug the cable from your phone into your computer. Your Phone may have even come with one. Your phone may need to be on for this process.

Then your computer should say it detects removable media, just like a flash drive. And you should be able to go into 'my computer' and find the removable storage disk. and the pictures should be in a folder in there.





Powered by Yahoo! Answers

No comments:

Post a Comment