Any developers up? Questions about XML - GoFuckYourself.com

Young · 07-15-2008, 09:13 PM

Working on a project. It will have about 1,500-2,000 separate entries with about 10 fields per entry. There won't be a huge amount of queries at first but scalability is a concern for the future. XML is a necessity.

1. Should I go with an XML file or a Database?
1a. Straight XML or MySql with XML export?
2. Anyone want to give me any advice or pointers on the way that you would do it.

ilbb · 07-16-2008, 01:12 AM

1) Save data in your MySQL
2) Cache your xml file

GrouchyAdmin · 07-16-2008, 01:41 AM

1) You have got to be kidding.
2) You need more experience; If I were you, I'd start reading up on database design.

brandonstills · 07-16-2008, 03:18 AM

Need more information before we can give you a suggestion. The nature of the data sounds like it's tabular in nature. Why is XML required? Data are data.

Young · 07-16-2008, 02:27 PM

Quote:

Originally Posted by brandonstills

Need more information before we can give you a suggestion. The nature of the data sounds like it's tabular in nature. Why is XML required? Data are data.

Data needs to be portable across different platforms + apps (online and off)

Young · 07-16-2008, 02:28 PM

Quote:

Originally Posted by GrouchyAdmin

1) You have got to be kidding.
2) You need more experience; If I were you, I'd start reading up on database design.

1. No I'm not kidding.

2. You have no clue how much experience I have with MySQL. I don't know much about XML. I am still learning.

3. You didn't answer my question. You contributed zero. So why waste your time? You'll never get those 2 minutes of your life back.

Young · 07-16-2008, 02:29 PM

Quote:

Originally Posted by ilbb

1) Save data in your MySQL
2) Cache your xml file

Thanks this is the way I think I'm gonna go. Though I'm reading up on some opensource XML databases.

GrouchyAdmin · 07-16-2008, 03:35 PM

Quote:

Originally Posted by Young

You contributed zero. So why waste your time? You'll never get those 2 minutes of your life back.

Neither will you manage to write a viable, useful application without knowing what the fuck you're doing, but don't let me stop you - I'll take the 'we need this rebuilt' job when you're gone.

mrkris · 07-16-2008, 03:39 PM

I would store the data in the database, then assuming you have an ORM approach, have a to_xml method that will convert the record object into xml.

Young · 07-16-2008, 03:39 PM

Quote:

Originally Posted by GrouchyAdmin

Neither will you manage to write a viable, useful application without knowing what the fuck you're doing, but don't let me stop you - I'll take the 'we need this rebuilt' job when you're gone.

It's my app you dumb fuck.

So I take it you were just born with the ability to design databases? You didn't learn right? God you are fucking moronic.

Sands · 07-16-2008, 03:43 PM

Pipe delimited text files. That's the way to go

Young · 07-16-2008, 03:45 PM

Quote:

Originally Posted by Sands

Pipe delimited text files. That's the way to go

Really?!?!? AWESOME! Starting on it now.

Young · 07-16-2008, 03:46 PM

Quote:

Originally Posted by mrkris

I would store the data in the database, then assuming you have an ORM approach, have a to_xml method that will convert the record object into xml.

This is the approach I think I'm going to take. Thanks. All I wanted to know. Instead I get a couple of responses from smart asses who need the work.

mrkris · 07-16-2008, 03:49 PM

Quote:

Originally Posted by Young

It's my app you dumb fuck.

So I take it you were just born with the ability to design databases? You didn't learn right? God you are fucking moronic.

Although I can understand your frustrations, Grouchy is by far one of the most intelligent people on GFY when it comes to technology. Yes, a sarcastic dick face, but still intelligent.

GrouchyAdmin · 07-16-2008, 03:51 PM

Quote:

Originally Posted by mrkris

Although I can understand your frustrations, Grouchy is by far one of the most intelligent people on GFY when it comes to technology. Yes, a sarcastic dick face, but still intelligent.

Fuck you too, skittle-popping nancy boy.

mrkris · 07-16-2008, 03:52 PM

Quote:

Originally Posted by GrouchyAdmin

Fuck you too, skittle-popping nancy boy.

You're the idiot who thought they were M&Ms

GrouchyAdmin · 07-16-2008, 03:53 PM

Quote:

Originally Posted by mrkris

You're the idiot who thought they were M&Ms

All I know I saw you taking them out of Brandon's He-Man lunchbox.

Bird · 07-16-2008, 04:16 PM

Use your database and user other sites XML feeds.

only use xml from your DB if your providing for widgets or API's

GrouchyAdmin · 07-16-2008, 05:18 PM

rss2xml.php3

mrkris · 07-16-2008, 05:21 PM

Quote:

Originally Posted by Bird

Use your database and user other sites XML feeds.

only use xml from your DB if your providing for widgets or API's

You're silly.

jay23 · 07-16-2008, 05:23 PM

Quote:

Originally Posted by Young

Working on a project. It will have about 1,500-2,000 separate entries with about 10 fields per entry. There won't be a huge amount of queries at first but scalability is a concern for the future. XML is a necessity.

1. Should I go with an XML file or a Database?
1a. Straight XML or MySql with XML export?
2. Anyone want to give me any advice or pointers on the way that you would do it.

These 10 Fields per entry, are they going to be same for all the entry or different.

1. If its same, go with any SQL data base
2. If its differnt then go with a XML data base (I personaly use MS SQL 2008 and its XML support)

Jay

Linguist · 07-16-2008, 10:13 PM

Quote:

Originally Posted by Young

1. No I'm not kidding.

2. You have no clue how much experience I have with MySQL. I don't know much about XML. I am still learning.

3. You didn't answer my question. You contributed zero. So why waste your time? You'll never get those 2 minutes of your life back.

Sorry mate but I totally agree with Grouchy here, and whether or not you use database or xml file depends purely on how you design the database. In this project a shitty database design will be about as fast or slower than the xml file.

07-15-2008, 09:13 PM	#1
Young Bland for life Industry Role: Join Date: Nov 2004 Posts: 10,468	Any developers up? Questions about XML Working on a project. It will have about 1,500-2,000 separate entries with about 10 fields per entry. There won't be a huge amount of queries at first but scalability is a concern for the future. XML is a necessity. 1. Should I go with an XML file or a Database? 1a. Straight XML or MySql with XML export? 2. Anyone want to give me any advice or pointers on the way that you would do it. __________________ ★★★

07-16-2008, 01:41 AM	#3
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	1) You have got to be kidding. 2) You need more experience; If I were you, I'd start reading up on database design. __________________ AIM: GrouchyGfy

07-16-2008, 03:18 AM	#4
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	Need more information before we can give you a suggestion. The nature of the data sounds like it's tabular in nature. Why is XML required? Data are data. __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

07-16-2008, 03:39 PM	#9
mrkris Confirmed User Join Date: May 2005 Posts: 2,737	I would store the data in the database, then assuming you have an ORM approach, have a to_xml method that will convert the record object into xml. __________________ PHP-MySQL-Rails \| ICQ: 342500546

07-16-2008, 04:16 PM	#18
Bird Confirmed User Join Date: Jan 2005 Location: Stockton Posts: 4,365	Use your database and user other sites XML feeds. only use xml from your DB if your providing for widgets or API's __________________ ICQ:268731675

07-16-2008, 01:12 AM	#2
ilbb Confirmed User Industry Role: Join Date: May 2005 Location: EU - Czech republic Posts: 3,025	1) Save data in your MySQL 2) Cache your xml file

07-16-2008, 03:43 PM	#11
Sands Confirmed User Join Date: Feb 2007 Location: 418194907 Posts: 3,134	Pipe delimited text files. That's the way to go

07-16-2008, 05:18 PM	#19
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	rss2xml.php3 __________________ AIM: GrouchyGfy