Android data warehouse in xml

Question

I have a web platform that stores data for the application that I am creating. The web platform is built using Ruby on Rails, and the main application is for Android. I am curious about any performance issues storing my data in an XML file (for an Android application). In the end, my database in the web application will have about 2,000 entries (for example, articles / Article category → Article - content, description, title, image path).

Is it better to use SQLite or an XML file to store my data?

Answer 1

When the data set is larger, the SQLiteDatabasebest option. CRUD operations performed in a database will be much faster than parsing XML files to recover data.

To be more specific, a database has the advantage of SQL as a query language, relational theory as its foundation, and years of supplier optimization.

XML is a bit more than a data format that contains metadata with it. You can serialize it to and from disk, parse it in memory using standard parsers and query using XPath, but it is not configurable or optimized to the same extent as SQL.

XML can be useful as a configuration format or wired protocol or as a simple serialization to disk, but it is not a complete storage technology.

NoSQL (JasDB), . XML .

, XML . , .

Answer 2

SQLite :

1) Easy to manage like (Insert,update,delete)
2) Anytime if table structure is changed easy to change and update accordigly.

Answer 3

SQLite

Answer 4

I recommend you use SQLite because it is easy to use and manage your database. I can provide a .java model file if you want.