hello, Fabio!

how can I help you today?

hi mark :)

do you have a question?

Yes, i'm a beginner and i'm starting to work on db access trough sqlite. I read your chapter and tutorial on this matter. My concern is about what is the best way to implement the db access through a single activity and multiple fragments requiring db access.

I would have some sort of data manager class be the access point to the database

Is it better to setup a class db helper which calls fragment through callbacks or implementing asynctask in fragments?

I would lean towards using your first option

have a centralized class that handles your data access, threading, caching, etc.

the activity can set up the instance of that class and make it available to the fragments

Ok just as you did in the epublite?

So, in general,is better using Threads instead of asynctask for db access

in EmPubLite, I went with the model fragment approach

in a single-activity app, a model fragment might be fine for your data access

sorry, let me rephrase that

in EmPubLite, I demonstrated two approaches

for the main EmPubLite activity, I used a model fragment for data access, though in that case it was not SQLite, but book information

for the notes, I delegated the threading and data access to the DatabaseHelper subclass of SQLiteOpenHelper

in both cases, the UI-related classes (the activity and regular fragments) did not handle threading or the actual I/O

whether you use regular threads or AsyncTask or RxAndroid or something else is really up to you

Ok, think i got it :)

they each have their pros and cons

Ok, thanks a lot for your time. Keep up with this work, i'ma really happy subscriber

you are very welcome!

Have a nice day

you too!

hello, Albert!

how can I help you today?

hi. thanks. i don't have a specific question today. just thought i'd check in to the chat room and see how it works. haven't visited this before.

mostly, the chat room is lightly populated

not sure -- is that an ok way to participate?

people ask questions, then head out

ah. ok.

you can see transcripts of past chats at: https://commonsware.com/office-hours/

thanks. i'll take a look at those then. best regards.

I'll be posting the transcript from today's chat (somebody was here earlier) shortly

FWIW, the next chat is tomorrow at 7:30pm US Eastern

but, for now, that's a wrap for today's chat -- I gotta get back to absorbing the O Developer Preview :-)

have a pleasant day!

ok. thanks. that's good to know. (i'm on west coast, fwiw).

you too.