By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,856 Members | 2,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,856 IT Pros & Developers. It's quick & easy.

MySQL Vs XML for a Mobile site

P: 2
Hi All,

Hope I've posted this in the right forum as I will be using PH

I am currently in the process of designing a php based web site that will display info about new bands etc. The users will be able to add their own articles such as reviews, tour dates, photos, videos etc. There will also be a mobile site which will allow the user to add content from their handset. The mobile content will only be text at the moment.

I am wondering what would be the best backend to use on this? I am pretty familiar with MySQL but Im not sure how effective this is to use with mobiles? Im hearing so much about XML that it is an option Im guessing I need to look into.

From the mobile device, the user would be able to view text content like gig listings and then would be able to add content aswell. Obviously a login facility would be required on the mobile.

Any advice would be great, hope this all makes sense! :)

cheers
Si
Jan 29 '08 #1
Share this Question
Share on Google+
3 Replies


nathj
Expert 100+
P: 938
IMHO XML is great for transient data, data transfer and data exchange. It is not a great system for permanent data. I would therefore suggest you stick with MySQL. this can be used by PHP very easily to generate the output you want and it should work just fine on a mobile device - I've done it for a site in development and it's just fine.

cheers
nathj
Aug 20 '08 #2

Atli
Expert 5K+
P: 5,058
XML and MySQL aren't really comparable.

XML, is a markup language, whose primary purpose is to facilitate the *transportation* of data.

MySQL is a Database Management System, whose purpose is to *store* data.

In any case...
None of this has anything to do with the fact that your web-site is to be used via mobile devices.
As far as your PHP code and your database are concerned, data is just data whether it came from a phone or a PC.
Aug 20 '08 #3

drhowarddrfine
Expert 5K+
P: 7,435
Well, I don't consider XML's primary purpose the transportation of data but the naming and identification of data. Frequently you'll find SQL databases filled with data that's marked up with XML.

What needs to be done is to determine whether the data presented needs to be presented in multiple forms, that is, will this data be queried in many different ways? In that case, that's what SQL databases are for. XML doesn't come with its own query language (actually it does but that's a different story) so some form of access method would need to be created. But XML will be a far smaller and easier to use method than mySQL.

For example, we have an ecommerce system for online ordering at a restaurant that stores the menus, restaurant info, and all the orders in XML. But this data is relatively simple and short term storage compared to a large catalog of things from a department store or manufacturing plant that may need to cross reference multiple items, prices, descriptions, parts, etc. over many years.

All too often I see people advocate the use of a database because, well, you're supposed to...aren't you? And no other reason. I'd lean toward using XML over the database if you can write the code necessary to search through that to get the information you need.

EDIT: Aw man. Here I go responding to a 3-year old thread. I hate it when people do that.
Sep 12 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.