[Q] Databases and Android Development - Online Courses, Schools, and Other External Resour

I was wondering if anyone had good resources on some more advanced topics in Android development, like database integration. I'm well-versed in Java and I have several ideas for Android apps, but they require either a SQlite DB on the phone or a database hosted on a server that the phone can connect to. Are there tutorials out there for these types of app/web servers? (buzz words I'm probably using incorrectly.) Or tutorials on database design for native android apps?

For sqlite db, thenewboston has some good videos in YouTube; for Web based sql server, there's s guide in Java for Android Programming subforum which you can check out, you can also read my implementation of db use @Github...
Any further question, would be glad to help...
Sent from my GT-S5830M using Tapatalk 2

Interesting Post
Thanks for sharing, really interesting information in this post, i would like to know more about,

rsromano said:
Are there tutorials out there for these types of app/web servers? (buzz words I'm probably using incorrectly.) Or tutorials on database design for native android apps?
Click to expand...
Click to collapse
Funny story, I just wrote a guide about connecting to a database. hope this is what you're looking for!

Related

[Q] learning how to develop apps

i want to start making apps for android but dont know where to stat i have the sdk on my desktop but thats about it. If someone could please help me or push me in the next step please do so.
Just go to the dev guide on the Android website to start making your first Hello World app. As for language, Android (I could be wrong) uses Java. Again, I could be wrong.
Sent from my GT-I9000M using XDA App
Indeed, Android uses Java. I'd suggest learning it before attempting to program for Android or else you'll feel like it's gonna be too difficult. There's plenty of books on Java, and some powerful Google searching will lead you to step-by-step guides to learning Java.
Also, go through the Android Dev Center for a lot of information. There's plenty of guides there on things like 'how to design your app to flow with the overall android feel' and 'designing icons to fit general android homescreen look'.
You're gonna want to download Eclipse for Java Programming. It's a free Java development environment much like Dreamweaver and Visual Studio are for web development.
Oh, and PLAN! Like any good development project, your project will not get anywhere if you don't know where to start and when to end it.
Plan first. Then plan the planned elements. Java is object-based programming, and just like building a house each object needs to be solid or else it'll crumble to pieces.
Same here. Thx for the advice.
elindemann said:
Indeed, Android uses Java. I'd suggest learning it before attempting to program for Android or else you'll feel like it's gonna be too difficult. There's plenty of books on Java, and some powerful Google searching will lead you to step-by-step guides to learning Java.
Also, go through the Android Dev Center for a lot of information. There's plenty of guides there on things like 'how to design your app to flow with the overall android feel' and 'designing icons to fit general android homescreen look'.
You're gonna want to download Eclipse for Java Programming. It's a free Java development environment much like Dreamweaver and Visual Studio are for web development.
Oh, and PLAN! Like any good development project, your project will not get anywhere if you don't know where to start and when to end it.
Plan first. Then plan the planned elements. Java is object-based programming, and just like building a house each object needs to be solid or else it'll crumble to pieces.
Click to expand...
Click to collapse
Actually, you're doing things the hard HARD ...HARD way....
if you want to develop apps for android, Titanium Mobile (appcelerator.com) is the best way to go. It takes far less time to learn JavaScript , CSS and HTML then it does to learn pure JAVA, and then learn to implement Android's API.
There are a few things that Titanium Mobile can't do, but they are always working on it to make it better. And of course - it's free
I've made a few apps using it. Including an HTML eBook reader, Chinese Flashcard App, and a Simple Chat Client.
Their JavaScript API takes a bit to get used to, but after that, you can easily spit out a simple app in about a day or so.
I have a web-app Template that lets me dump a Web-app (html/css/js) into a project, and spits out a nice new shiny Android app ready for the market.... I also wrote code that lets you access the Menu Button on android too. So it's not like using PhoneGap where it's just a Browser session with an icon on your phone.
PM me if you're interested, and i'll show you everything i learned about Titanium Mobile so far (i'm still learning actually). Or if you want an app done, i can do it for you... free if it's easy enough
DaoMingJin said:
Actually, you're doing things the hard HARD ...HARD way....
if you want to develop apps for android, Titanium Mobile (appcelerator.com) is the best way to go. It takes far less time to learn JavaScript , CSS and HTML then it does to learn pure JAVA, and then learn to implement Android's API.
There are a few things that Titanium Mobile can't do, but they are always working on it to make it better. And of course - it's free
I've made a few apps using it. Including an HTML eBook reader, Chinese Flashcard App, and a Simple Chat Client.
Their JavaScript API takes a bit to get used to, but after that, you can easily spit out a simple app in about a day or so.
I have a web-app Template that lets me dump a Web-app (html/css/js) into a project, and spits out a nice new shiny Android app ready for the market.... I also wrote code that lets you access the Menu Button on android too. So it's not like using PhoneGap where it's just a Browser session with an icon on your phone.
PM me if you're interested, and i'll show you everything i learned about Titanium Mobile so far (i'm still learning actually). Or if you want an app done, i can do it for you... free if it's easy enough
Click to expand...
Click to collapse
Wow, I'm very interested. I might check it out.
sent from my pimp hero running Froyo CM6 and the XDA app
If you know the C or C++ language you could try out MoSync, depends what you like, some programmers like the level of control and speed you get from C++. If your content with simpler apps then maybe phonegap or appcellerator for you.
I guess that when mobile apps get more sophisticated javascript programs will be just as complex as C++ programs.
Thats my view, but then I like C++ better.
/Tony
MoSyncTony said:
If you know the C or C++ language you could try out MoSync, depends what you like, some programmers like the level of control and speed you get from C++. If your content with simpler apps then maybe phonegap or appcellerator for you.
I guess that when mobile apps get more sophisticated javascript programs will be just as complex as C++ programs.
Thats my view, but then I like C++ better.
/Tony
Click to expand...
Click to collapse
It really depends on how much control and you really need. If you're going to write games, then you do need speed that C++ and the Native Application Development API on android can give you. If you're writing a social networking app, the speed of C++ would really be an overkill.
As far as i've read, PhoneGap still has a lot of issues. And the build process is a bit more complicated than on Titanium Mobile.
If you're just using the regular Android API to write apps, i don't notice a lot of difference in speed execution between writing it in pure Java, or using Titanium mobile (using native code and UI elements - i don't mean putting everything into a WebView).
The current app that i'm writing now i don't think can be written using Titanium Mobile or PhoneGap (unless i added some native functions and did my own fork of PhoneGap).
More or less, i'm writing an App for Android and JRE/Linux systems that will allow me to enumerate, and access USB status bits, and USB data frames of a given USB device, and then allowing that USB device to be accessed through a TCP or UDP connection.
I might be able to do this with Titanium Mobile, but i don't think i can. As the only files you're allowed to access are on the SD card, application data directory, and temp directory.... i think there's one other place you're allowed to access too, but i never used it. However later today i might just try to see if i can access the /Dev/DSP01 (aka sound card) on an android device. If i can, i think i could write it using titanium mobile. I'm already halfway done with this app in pure java, so i wouldn't actually rewrite it in Titanium Mobile now.
DaoMingJin said:
if you want to develop apps for android, Titanium Mobile (appcelerator.com) is the best way to go.
Click to expand...
Click to collapse
Thanx mate!
If you looking a book or something to teach you the basics Beginning Java Programming for Dummies and Android Application Development in 24 Hours are good reads.
I'd rather not fill the forum with more threads so I'm just going to ask my question here. What is the best way to read the android dev guide on the device itself? Just going to the site directly? Ideally I'd like a pdf or something designed to be read on a small screen. The site can have formatting issues when read on a small screen.
Sent from my SPH-D700 using XDA App
I've been developing for a long time (nearly 30 years), and whenever I need to learn a new language I start with the Sams range, "Teach yourself whatever language in X days/hours". They're pretty good and this is available for Kindle, which is great if you use the Amazon Kindle app...
http://www.amazon.co.uk/Teach-Yours...1_fkmr2_2?ie=UTF8&qid=1287485537&sr=8-2-fkmr2
It obviously costs, but I really do rate those books as brilliant starting points. The rest is google and friends on here.
Hope this helps - good luck mate.
Personally, I've been coding in Java for what... four years now? I'm feeling dwarfed here by johncmolyneux but honestly, the best way to learn is to not use an IDE like Eclipse, but to use something that you have to hand-code everything yourself, such as Geany! You learn fairly quickly after writing a few applications.
If you are thinking "titanium", "mosync" or "phone gap" it is worth doing a bit of background research. There are several extremely powerful tools out there that can help you build cross platform apps - these are among the top ones.
bit more discussion about this here: http://forum.xda-developers.com/showthread.php?p=16703287#post16703287
There are a few useful reports comparing them - check out ours by googling "triballabs cross platform"
The Google App Inventor makes it pretty easy to create your own Android apps. Best part is you don't need to learn any programming languages. You won't be creating anything too complicated like a video game for example, but it's a good start nonetheless.
http://appinventor.googlelabs.com/about/
If you want to learn the basics of Java, then please check out a book called as "Head First Java". They really explain the basics with the help of real life examples to make things much simpler so that people understand.
Beginner app projects
I'm also just getting started with app development. Something I've been looking for is a beginner app project. Wish I could find a walkthrough of a simple app like a game of Hangman or something like that. I've been through the android developer training web site and got some good info but some things I'm still a little stuck on. Id Love to see an actual app (rather than just a mock up of some fields and buttons) and then a slightly dumbed down explanation of the code. Might be a lot to ask but man it would be great!

So Lost

So I am trying to develop an app for my conventions. I have never coded before in my life outside of a basic java class 7 years ago and have a bit of help but not anything android useful.
My buddy is an IT guy and is doing our sql server and VB layout for Windows based systems.
I want to be able to query the SQL server from my android devices an Asus Transformer TF101 and Galaxy S2 Sprint. I also want it to be able to modify entries in the database. It will be used to manage volunteer schedules. I want have updates to the database pushed to my phone.
The things I need to be able to query is Name, phone number, shift time for the current day, punch times for that day, and total logged time for the week.
I have read a few guides on here all with high ratings and have been lost with it all. Having no experience in coding I am trying to find a way to learn this but really prefer to have someone sit down and give me the basics. Best way for me to learn is watching and participating.
Any help would be appreciated.
Questions or Problems Should Not Be Posted in the Development Forum
Please Post in the Correct Forums
Moving to Q&A
Vladimir Kulyukin is an associate professor at Utah State University and he teaches Android programming among other things. Search Google for the terms "Vladimir Kulyukin" + "android programming" and you will get his blog with links to all his videos. I cannot post the links here as I am a newbie and not allowed to post links.
If your IT guy is making your SQL server directly accessible from the internet, fire him.
What you need is for him to prepare an API, a REST one perhaps. For REST APIs, you just use the HTTP client library that comes with Android.

[Q] Application Development Help

Hi
I'm new to android dev and I'm trying to make an application for internal use among people in the company and partners. Its a very simple app, and I think I can cover most of the coding, but what I can't is connection to a remote mysql database. Its used to verify login credentials and edit certain columns (without it, app is useless).
From what I understand, its suppose to work like this: SQL > PHP > APP where the app pulls info from a php script located on the remote server. My issue with this is Java, which I'm very new to. I'm looking for someone to guide me through making that first bridge (I tend to make more, where I can pull sql data from app to show some stats or whatever)
Thank you
Loldawg said:
Hi
I'm new to android dev and I'm trying to make an application for internal use among people in the company and partners. Its a very simple app, and I think I can cover most of the coding, but what I can't is connection to a remote mysql database. Its used to verify login credentials and edit certain columns (without it, app is useless).
From what I understand, its suppose to work like this: SQL > PHP > APP where the app pulls info from a php script located on the remote server. My issue with this is Java, which I'm very new to. I'm looking for someone to guide me through making that first bridge (I tend to make more, where I can pull sql data from app to show some stats or whatever)
Thank you
Click to expand...
Click to collapse
If you're into web development and performance is not an issue, then you can try the webview instead of coding natively. At that time, you'll be using more html, javascript, jquery in which you may be more familiar with.
wcypierre said:
If you're into web development and performance is not an issue, then you can try the webview instead of coding natively. At that time, you'll be using more html, javascript, jquery in which you may be more familiar with.
Click to expand...
Click to collapse
Hi, thank for the swift reply =) I thought about it, but I'd like to make it right the first time. It would be nice to make the data available so I can do whatever with it. I did find a tutorial including examples and code on how to connect to sql and pull information, I'm just having a hard time actually implementing it into eclipse.. No idea where to type it in and stuff lol

Free Online Mobile Development Courses (Java, Android, etc.)

Here are links to several free online courses designed to help you learn mobile development. Reply here if you know of any good ones that I missed. If you have comments or experiences to share about any of these, please start a new thread to discuss.
“Computer Science 164: Mobile Software Engineering” is a Harvard University course using Javascript, HTML5, Objective-C, and PHP, and to teach you how to build mobile web apps (along with some native iOS development). The online course includes all video lectures, study sessions, slides, source code, etc. This is the follow-up to another Harvard class available online: “CS 50 – Introduction to Computer Science”.
“Computer Science E-76: Building Mobile Applications”, a Harvard University Extension course, covers Android and iOS, including writing native apps for Android using Eclipse and the Android SDK. Lecture 2 is a Java primer and lectures 3 – 6 cover aspects of Android development.
Google’s Android development training course includes ten modules covering everything from graphics and animation to security and monetization.
“Introduction to Programming in Java” is an MIT OpenCourseware class offering lecture notes and downloads of java programming assignments. You can see a full list of free MIT online comp sci courses here.
“Android Application Development” was taught at CalPoly in Summer 2010. Not as complete as some of the Harvard courses, the site offers basic instruction on building basic apps.
Neither Udacity or Coursera has a mobile-specific course yet, but both include amazing classes on web application development.
Codeacademy offers several courses on web and application (non-mobile) development. Topics include PHP, jQuery, JavaScript, Python, and Ruby.
"The Java Tutorials" on Oracle's site are about general Java development and are not Android-specific.
XDA’s “How to Build an Android App” series by Adam Outler.
Treehouse Library beginner courses teach you how to build simple apps.
For Android App development, I would strongly advise:
The New Boston - Android Tutorials
For Java basics:
The New Boston - Java Tutorials
The tutorials are done by Bucky and Travis and these guys are very good. They take you through the learning step by step.
Also. When you come across problems, the main Android Developers site is very good, but I've also found Stack Overflow very helpful.
I started using the tutorials with no Android or Java knowledge at all and I've used what I have learned to make a couple of basic soundboards so far and other bits and pieces, but what they teach you gives you the potential for a lot more.
You can see the apps I've made Here (Google Play) and Here.
This one's good for both C and C++
http://www.cprogramming.com/
And this one for C, pretty well explained and my favourite
http://www.howstuffworks.com/c.htm
How can I watch those Harvard lectures, they seems to be locked, are they free
Found this putzing around the internet at work. Very engaging lectures, never talks in monotone, and explains things in a simple to understand format.
From Stanford, almost all the material is provided (lectures, handouts, assignments, exams, etc), and all the videos are downloadable through iTunes or YouTube.
Not android specific, but gives a solid groundwork on the Java platform.
Best of all... FREE
http://see.stanford.edu/see/courseinfo.aspx?coll=824a47e1-135f-4508-a5aa-866adcae1111
I'm currently following Google’s Android development training course and came here looking for an ebook of these pages. I want to read these on my phone while I travel.
Does anyone know of such an ebook on Google books or any other 3rd party website?
Also, a tool that can convert these webpages into a static ebook will also do. I just need them to be available for offline reading.
Thank You
Guys try Barbara hecker on YouTube .excellent latest university level courses on android. Total 15 hours I guess.
Sent from my Nexus 7 using Tapatalk 4 Beta
Kaiyes said:
Guys try Barbara hecker on YouTube .excellent latest university level courses on android. Total 15 hours I guess.
Sent from my Nexus 7 using Tapatalk 4 Beta
Click to expand...
Click to collapse
+1 for Barbara Hecker's ITU lecture series all posted on YouTube. Its about 25 1hr lectures in Android Development all posted within the last few months so very current. Easily the best Android learning tool I've found so far on the web.
The new boston video series is good but way too out of date (2009). Android has come a long way in 3 years.
Ya that's the most recent I could find. The proprietary screen casts like Lynda.com, tutsplus, video2brain and others are also worth looking into. I certainly learned a lot from them. Also, its worth looking into phonegap. It let's us use javascript-css-html to create apps for all platform like iOS, android, blackberry and so on.
Sent from my Nexus 7 using Tapatalk 4 Beta
please share links for
Minimum skills / sources required before writing android apps
Understanding android operating system
how to code some easiest android applications to boost confidence amongst new persons.
Thanks
Use jquery mobile and phonegap. You can make apps within 1 hour or even less. Just get some video tutorial from youtube or lynda.com or someplace similiar. There are a ton of them. Youtube jquery mobile , phonegap.
Sent from my Nexus 7 using Tapatalk 4 Beta
Kaiyes said:
Use jquery mobile and phonegap. You can make apps within 1 hour or even less. Just get some video tutorial from youtube or lynda.com or someplace similiar. There are a ton of them. Youtube jquery mobile , phonegap.
Sent from my Nexus 7 using Tapatalk 4 Beta
Click to expand...
Click to collapse
is it important to understand how operating system works ?
Kaiyes said:
Use jquery mobile and phonegap. You can make apps within 1 hour or even less. Just get some video tutorial from youtube or lynda.com or someplace similiar. There are a ton of them. Youtube jquery mobile , phonegap.
Sent from my Nexus 7 using Tapatalk 4 Beta
Click to expand...
Click to collapse
that fine for basic apps but if you want to add any complexity you really need to know android programming (java/eclipse etc). i dont think sending people down this easy path is going to help them become android developers.
Coursera does now have a course for Android Programming. It uses the Processing 'language' and teaches fundamentals such as the accelorometer, basics of a physics engine ( BoxWrap2d) and image and sound manipulation. I have almost finished this run of the course, and its a good starter for people who are interested in learning how to develop for Android.
The downside to the course though, if you don't have any knowledge of programming at all, I think you might struggle a little bit. (Just my opinion.)
Search for 'Creative Programming for Digital Media & Mobile Apps'
Like i said, its good for simple informative type apps for most of the major platforms at once. But its not for complicated apps like games/kernel. However i do think there is a big untapped market for sector specific informative type apps. Take medical sector, most of the apps doctors need gotta help them remember & docs will buy em. I saw simple jquery mobile type apps selling for £15. Also, if you are good at JavaScript, then you can basically carry your "app" over to all platforms. That's the catchy bit I guess. Its also easier for web devs to hack at mobile software market without having to learn a whole new language. Having said all that, Java is still one of the top languages there.
Sent from my Nexus 7 using Tapatalk 4 Beta
great android app developement youtube tutorial series
This guy is awesome!
His rapid for style allows us to learn more in a shorter amount of time, without dieing of boredom.
The tutorials were designed to familiarize us with the basics in the beginning, then to help us gain and retain a better understanding of how to develope apps.
You may feel overwhelmed by all of the information being shot of at you at such a rapid fire rate, but rest assured that as you progress through the series, things will make more and more sense to you.
I highly recommend that anybody that is new to developing Android apps, or that anyone who wants a refresher course, that doesn't feel like being bored out of their mind by long, drawn out, agonizing courses, check this out.!
Here's the link to the entire Android app developement tutorials.
http://www.youtube.com/watch?v=boj0f_O3i88&list=PLGLfVvz_LVvQUjiCc8lUT9aO0GsWA4uNe
Enjoy!
The New Boston.
On youtube Runs a Channel.
Provides 200 tutorials in android app development and also Other Valueable Sequel Tutorials. ...
----------Signature---------
Need Some Cool Guides Visit Hmpshah Guides
These Android tutorials by Vogella are also good.
http://www.vogella.com/android.html
As far as I get it, if you know Java well enough that you rate yourself > 6 out of 10 as a Java programmer, Android app development should be easy for you.
The ice is broken. On Coursera on 21-th January starts "Programming Mobile Applications for Android Handheld Systems".
Game Development Days
If you like game programming, I have started a guide a while ago:
Game Development Days
The guide walks you through the development of a 2D game engine, and covers side information around it.
Thought it could be useful here

[Q] How to make an android app

I need to create a mobile app for my project. So here's my question.
What language should I use to create an android app?
And can someone share me some basic knowledge about mobile application.
I'd like to make a basic calculator.
kroragna said:
I need to create a mobile app for my project. So here's my question.
What language should I use to create an android app?
And can someone share me some basic knowledge about mobile application.
I'd like to make a basic calculator.
Click to expand...
Click to collapse
the most common basic app for beginners is the calculator. u should be able to find a lot of youtube tutorials online.
Most of your android app coding will be done with a combination of xml and java.
You would use either eclipse with the adt plugin, or android studio to do so.
As was previously stated a calculator app should have many many tutorials for doing so online.
One of the better basic android tutorials I have found is by a fella named travis who has made a series of tutorials that he has posted on youtube under the name "thenewboston" what I like about them is he doesn't get overly technical and his delivery is sorta like being taught by one of your buddies over some beer. I have passed that to several of my friends who have asked me to "teach them to code" as I don't tend to have the patience to do that properly.

Categories

Resources