Native XML database vs. SQLite/MySQL -


I am in the design phase to design a media player for an embedded system. Most of these systems use SQLite / embedded MySQL for data management. How would you compare the XML database used for the media player in the embedded system? Pro / Oppo?

Thank you!

Professionals / Opposition (given the same amount

    • XML :
      • [+] Use low system resources to recover simple data
      • [-] Data changes will be difficult
      • The risk of changing the wheel for common SQL features such as very limited data management capabilities ( LIKE , Group B , LIMIT etc. ). However, check that you have an XQuery / XPath Lib, but I think that anyway you will be very limited to writing data, table management, joining.
      • SQLite / MySQL :
        • [+] The possibility to manage data using SQL, ease with multiple tables Work from ...
        • [+] (SQLite only): if no server is needed, unlike MySQL, should establish fewer problems, use less system resources, etc.

          I would then go to SQLite.

  • Comments