0

I intend to make an app which is a sort of dictionnary for a slang/a dialect. There are not many words (less than 1000). To store the data, I have 2 solutions :

  • storing data in a clean sqlite database (which I use to do in my apps)
  • storing data in 26 xml files

according to you, which solution would be the most flexible and the most clean to use ?

Thank You

2
  • 5
    I guess a single database is the best solution over 26 xml files! Commented Oct 25, 2013 at 11:38
  • 1
    Use databases, useful for CRUD operation. Commented Oct 25, 2013 at 11:54

3 Answers 3

2

1.For Better performance you must use sqlite insted of xml.
2.xml is more complex and you have to parse data by reading a tag, so its decrease performance and increase complexity.

Sign up to request clarification or add additional context in comments.

Comments

1

Using sqlite database has more flexibility over storing in xmls

  1. you can manage the data easily. other operations like searching, adding more, or deleting and related operations will be easier
  2. you wont need to handle the store operations manually. if you use xmls then you need to store those separately which will be more complex.

(to be hones i dont find any reason to use 26 xmls in your case)

1 Comment

26 letters = 1 xml per letter ( i guess? )
1

If you're going to only read from your files/database, you can use xml files, especially if you're going to cache the data during the life of your application. This won't make a big performance hit with your number of records/words and will be easier to manage during development. Also, check if you can use smaller number of files to simplify development)

You can also use text files (csv) for read-only data: they are easier to manage and read in the code.

If you are going to update the data or create related data (e.g. favourite words), Sqlite database will be better as it offers more flexibility and performance.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.