Pros and Cons of SQLite and Shared Preferences [closed]

by

It really depends on the data you want to store.

SQLite

Large amounts of same structured data should be stored in a SQLite database as databases are designed for this kind of data. As the data is structured and managed by the database, it can be queried to get a sub set of the data which matches certain criteria using a query language like SQL. This makes it possible to search in the data. Of course managing and searching large sets of data influences the performance so reading data from a database can be slower than reading data from SharedPreferences.

SharedPreferences

SharedPreferences is a key/value store where you can save a data under certain key. To read the data from the store you have to know the key of the data. This makes reading the data very easy. But as easy as it is to store a small amount of data as difficult it is to store and read large structured data as you need to define key for every single data, furthermore you cannot really search within the data except you have a certain concept for naming the keys.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. Android SQLite database: slow insertion
  4. Share SQLite database between 2 android apps?
  5. Android: upgrading DB version and adding new table
  6. How do I view the SQLite database on an Android device? [duplicate]
  7. Best way to work with dates in Android SQLite [closed]
  8. Best place to close database connection
  9. Import .csv file to Sqlite in Android
  10. Cursor adapter and sqlite example [closed]
  11. How to add new Column to Android SQLite Database?
  12. Which Android Data Storage Technique to use?
  13. How to retrieve data from sqlite database in android and display it in TextView
  14. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  15. Android SimpleCursorAdapter doesn’t update when database changes
  16. Android SQLite Database, WHY drop table and recreate on upgrade
  17. How to use SharedPreferences to save more than one values?
  18. Android SharedPreferences limitations?
  19. SQLite simultaneous reading and writing
  20. update sql database with ContentValues and the update-method
  21. Create SQLite database in android
  22. Could not allocate CursorWindow
  23. Saving ArrayLists in SQLite databases
  24. android, how to exec a sql file in sqlitedatabase
  25. SQLiteOpenHelper – creating database on SD card
  26. SQLite android column not found
  27. How to store JSON object in SQLite database
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment