Store object with included list of objects in sqlite

Question

i want to store an object in an sqlite database:

public class TimeObject {

  long timeBegin;
  long timeEnd;
  long lastBeforePause;
  long lastBeforeClosed;
  int isPaused;
  String timeReadable;
  List<PauseObject> pauses;
}

Basically, storing this isn't a problem at all. But my question is, how do i store the list properly? Would it be reasonable to serialize the list and store it as a TEXT?

This is how a PauseObject looks like:

public class PauseObject {

  long pauseBegin;
  long pauseEnd;
  long pauseLastBeforeClosed;
  String pauseReadable;
}

I'm looking for a way that doesn't affect the performance of the application too much. Any help would be appreciated. Thanks in advance!

Vishal Vijay · Accepted Answer · 2013-12-11 12:24:37Z

1

Try ORM Lite http://ormlite.com/sqlite_java_android_orm.shtml

Object Relational Mapping Lite (ORM Lite) provides some lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages. It supports a number of SQL databases using JDBC and also supports Sqlite with native calls to Android OS database APIs.

answered Dec 11, 2013 at 12:24

Vishal Vijay

2,5282 gold badges25 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Store object with included list of objects in sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related