Android Store a Parcelable Object in SQLite

StErMi picture StErMi · Jan 17, 2012 · Viewed 11.6k times · Source

I need to store an object content in Sqlite. I was wondering which was the best way to do it with a serialization of the object or with Parcelable.

Is it possible to store it as Parcelable? How can I do it?

Answer

CommonsWare picture CommonsWare · Jan 17, 2012

You are welcome to convert your object into some sort of persistable data structure (XML, JSON, Serializable) and stuff it in some database column. Bear in mind that you will still need to deal with compatibility issues (e.g., Version 2 of your app changes a class, which now needs to deal with both Version 1 and Version 2 structures). Also bear in mind that, going this route, you lose a lot of database capabilities (e.g., querying on something in the object).

You are also welcome to experiment with object databases, or CouchDb, or storing your persistable data structure to a file, if SQLite is not a requirement.

What most certainly will not work reliably is to pour the Parcelable into a Parcel and try storing the Parcel. A Parcel is meant for IPC use only and is not designed to be persisted. This is one of the reasons why Parcelable is faster than Serializable.