Android: Store ArrayList into sqlite database

Question

I have been banging my head against the wall for a while and I can't figure out how I could store an ArrayList into a sqlite column. I was thing it would work like the following:

Storing into database:

ArrayList -> String
String -> Sqlite column

Retrieving:

Sqlite column data -> ArrayList

However, I am unsure on how to accomplish this? Any guidance or advice?

an arraylist is a list of things, not a single item, so unless you store it as a delimited string then maybe creating a one to many relationship would be better. — Scary Wombat
– Scary Wombat, Commented Apr 15, 2014 at 5:35

Community · Accepted Answer · 2017-05-23 11:57:38Z

0

Convert List to comma (whatever) delimited String.

Convert delimited String to List.

You will need a large text column though. You never know how large these lists can get. As @Java1 suggested, maybe a master/detail would be better for this?

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Apr 15, 2014 at 7:05

velis

10.2k4 gold badges50 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Android: Store ArrayList into sqlite database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related