SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    May 2003
    Location
    somewhere on the Earth
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    building a small forum: xml or mysql?

    I know to do this using Mysql is easy but I wonder if xml will work just fine. I like to try new things.

    there are about 300 members in the forum and maybe 20 online at the same time. Is it ok to use xml instead of mysql as the data container?
    what about the speed and something related(secure.....)?

    simple XML structure expected:
    Table_User:
    <user>
    <id>id</id>
    <email>email</email>
    <username>username</username>
    <password>password</password>
    </user>

    Table_Topic:
    <topic>
    <id>id</id>
    <subject>subject</subject>
    <body>body</subject>
    <time>time posted</time>
    <author>author</author>
    </topic>

    what's more.. is it ok to put all topics in a single xml file? then the file will be extremely huge.....(measured in .MB)

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use a DBMS. XML is not a data storage format. You may want to look at SQLite, although I would recommend MySQL (*shudder*) or PostgreSQL over SQLite any day.


Bookmarks

Posting Permissions

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