Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder mOrloff's Avatar
    Join Date
    Nov 2008
    Location
    The Great Pacific NW, USA
    Posts
    422
    Thanks
    8
    Thanked 6 Times in 6 Posts

    Should I use a table or XML for not-necessarily tabular data?

    First, let me lay the ground work.
    I am going to have a "Part Work Screen" (php) pulling info from our database (stock levels, quote/sales history, etc).
    This is all tabular data, so I know that a DB is the best place for that info, but
    I will also be pulling series level data, and this isn't inherently tabular.

    (please keep in mind that I'm a total noob.)

    IE:
    Code:
    <series>
      <pdf link/>
      <pdf link/>
      <photo link/>
      <photo link/>
      <photo link/>
    </series>
    The series info will be simple, but can have anywhere from zero-to-many links of one type, regardless of whether it has zero-or-many links of another type.
    It seems to me that using a table would kinda be like "wasting space".

    Am I correct in thinking that XML would be best suited for this?
    Note: For starters, there are probably about 15k different series representing about 65k part numbers. This will continue to grow.
    I can, however, parcel out the XML and have a separate data-island for each PN Category (ie: machines, people, animals) if size tends to be a hurdle for XML.

    I'm looking for some advice and/or suggestions from the seasoned pro's (or anyone with something to add).

    ~ Mo

    NOTE: Realizing I may get a slightly biased opinion or two, I am also posting this in the MySQL group to see what kind of biased opinions I can milk out of them , then reconcile everything together.

  • #2
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    cross posting is against cf rules:

    http://www.codingforums.com/showthre...001#post797001

    see 1.2 from:

    http://www.codingforums.com/rules.htm

    regards

  • #3
    Moderator
    Join Date
    May 2002
    Location
    Hayward, CA
    Posts
    1,460
    Thanks
    1
    Thanked 23 Times in 21 Posts
    Closing thread per previous comment.
    "The first step to confirming there is a bug in someone else's work is confirming there are no bugs in your own."
    June 30, 2001
    author, Verbosio prototype XML Editor
    author, JavaScript Developer's Dictionary
    https://alexvincent.us/blog


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •