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.
- SQLite / MySQL :
Comments
Post a Comment