Use of ThreadSafeDatabase

[Peter]

Hi,

I have a few questions about the ThreadSafeDatabase.

1. How often do I need to close() the db?  Would it be a problem if I kept a static reference to an open database, and only closed it when the app enters either stop() or destroy()?

2. In Eclipse, the source for ThreadSafeDatabase.commitTransaction() calls:

    underlying.beginTransaction(); // not commitTransaction...?

Is this a bug?

3. I would love to read a blog post or documentation that elaborates on differences between sqlite in android vs ios.  I've never used sqlite before and hope that my use case is simple enough that I wouldn't run into any incompatibilities, but more detailed guidance (for a beginner, please!) would help me, and probably others.

Thanks,

Peter

IDE: Eclipse

[Shai Almog]

Hi,
1. destroy() is bad. You can use stop()/start() as destroy() isn't guaranteed.
That's possible.

2. Yes, thanks we'll fix it.

3. Unfortunately it's too nuanced since the OS's changed the behavior between versions. One of the problems we know about relates to transaction isolation which has different default values in both OS's. Not exactly light reading.