App for my band

Your ideas for any killerapplication that comes to your mind ;)

App for my band

Postby charlesd81 » Tue Oct 19, 2010 1:46 pm

I am trying to learn Android programming and no better way to do so than trying to develop an application. I am looking to create an Android app for my band. Our website is hosted using the Joomla CMS. What would be the best way for me to get data that is stored in the MySQL database so that I may use it in my app? Initially I was thinking that the app could show recent band news, lyrics to songs, pictures, ability to purchase songs through AmazonMp3 and other features. I'm not familiar with web services but it seems like a lot of people use web services to do this. Keep in mind that my current Joomla installation is hosted on Linux and not Windows, although I supposed I could always switch it to Windows at GoDaddy. Any opinions on a recommended solution would be appreciated.
charlesd81
Freshman
Freshman
 
Posts: 3
Joined: Thu Oct 14, 2010 4:12 pm

Top

Re: App for my band

Postby blundell » Tue Oct 19, 2010 3:27 pm

Android uses SQLite as it's database, so would be good for you to take an image of your current website SQL and convert this to SQLite for you to work with:
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools
User avatar
blundell
Master Developer
Master Developer
 
Posts: 1610
Joined: Tue Nov 18, 2008 12:58 pm
Location: UK

Re: App for my band

Postby charlesd81 » Tue Oct 19, 2010 8:01 pm

I don't quite understand. Wouldn't that mean that everytime I update our website I would need to update the Android app? How is the Android app updated?
charlesd81
Freshman
Freshman
 
Posts: 3
Joined: Thu Oct 14, 2010 4:12 pm

Re: App for my band

Postby blundell » Tue Oct 19, 2010 9:10 pm

Yeah if you want to keep them upto date. You update it the same way you upload it the first time, through the app Market.

If you don't want to update it everytime, you could right a webservice to update the app but your just getting more complicated as you go.
User avatar
blundell
Master Developer
Master Developer
 
Posts: 1610
Joined: Tue Nov 18, 2008 12:58 pm
Location: UK

Re: App for my band

Postby leighelkins » Thu Nov 17, 2011 2:18 pm

I'm new to Android app development, but have been a software and website developer for a number of years. I know the Joomla CMS very well, and for pretty much everything you have said I think you are looking at a simple RSS reader, so for Band News you would set the RSS feed to the news category, etc.
The only thing I am not entirely sure of right now would be buying the songs, but that wouldn't necessarily have to be done through Joomla if they are on Amazon.

Good luck.
leighelkins
Freshman
Freshman
 
Posts: 2
Joined: Thu Nov 17, 2011 2:07 pm

Top

Return to Creative Corner

Who is online

Users browsing this forum: No registered users and 3 guests