Android SQLite result to Array

Question

I've been playing around with android sqlite and I noticed it uses a cursor. Is their a function that takes query as input and returns a 2D array for all results.

I come from php and its a lot more easy, but i can't find any similar function any where!

You really don't want to put the results of a (possibly very large) database query into an array on a device as memory-constrained as a smartphone. What do you want to do with the data? There most likely is a better approach. — Philipp Reichart
– Philipp Reichart, Commented Sep 8, 2011 at 17:03
i will be reading back and forth many times as i traverse each and every single row. it is an optimization type. and no the fetch result is very small. possibly 10 rows or at most 100 — TDSii
– TDSii, Commented Sep 8, 2011 at 18:39

Dan S · Accepted Answer · 2011-09-08 17:04:59Z

1

No, the Cursor is what is used for all database query results. The Cursor object is beneficial to Java because it is a strongly-typed language. PHP uses dynamic weak typing which lends itself to that kind of SQL query response. Also there are memory considerations that a Cursor will solve by being able to see only one row of data at a time.

answered Sep 8, 2011 at 17:04

Dan S

9,2093 gold badges40 silver badges50 bronze badges

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

2 Comments

TDSii Over a year ago

perhaps ur right, but sometimes i need to fetch whole query into an array and then traverse certain rows, depending on the algorithm

Dan S Over a year ago

You can pull all the data you want, the point is that the Cursor helps you manage it.

Collectives™ on Stack Overflow

Android SQLite result to Array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related