getWritableDatabase() VS getReadableDatabase()

Question

I am creating a database helper class and for some of the methods within it I am only querying the database and others I am writing to it.

My understanding is both these methods will open the database up and let the program either just read or write to the database.

For the query statements is it worth just using getReadableDatabase() or is there very little difference in performance between the two methods.

Thanks for your time.

http://stackoverflow.com/questions/10844578/difference-between-getwritabledatabase-and-getreadabledatabase — user2864740, Dec 05 '13 at 18:20

score 18 · Accepted Answer · answered Jul 06 '11 at 13:45

18

They return the same object unless the disk is full or there is some permission error that forces to open the database in read-only mode. The name is a bit confusing though :)

As a rule of thumb you should put any call to these methods outside the UI thread. Both can take a long time to return.

If you are not going to write the database just use getReadableDatabase as it will contribute to your code clarity and intention.

More info here.

answered Jul 06 '11 at 13:45

mgv

8,384
3
43
47

So can I execute select statements even if i use `getWritableDataBase`? – Sourav Kanta May 21 '16 at 15:39

score 2 · Answer 2 · answered Dec 05 '13 at 18:17

2

If you look at NotepadProvider.java in Google's NotePad sample project , you will see that they use both - depending on the use-case.

answered Dec 05 '13 at 18:17

IgorGanapolsky

26,189
23
116
147

score 1 · Answer 3 · answered Dec 03 '13 at 12:23

If you are doing too many operations on database like querying, updating frequently in some random order, then it doesn't really make any sense in using getReadabledatabase as it can be used only to read the values.

Based on your app requirement you can judge the usage. If you are only reading the values constantly then you can go for getreadabledatabase.

Note: Some times when you are trying to open data base for writable, using getwritabledatabase and if system finds an exception like write permission or so, in that case system may throw an exception. In such cases you can open the database using getreadabledatabase.

score 0 · Answer 4 · answered Sep 04 '13 at 00:43

0

If you are getting 'Database is locked' type errors when implementing concurrent (multi-thread) db calls, use getWritableDatabase instead of getReadableDatabase.

answered Sep 04 '13 at 00:43

MiramarHacker

1

score -2 · Answer 5 · answered Jul 06 '11 at 13:43

-2

Opening a database read-only should slightly improve performance, as the locking overhead will be lower.

answered Jul 06 '11 at 13:43

Philip Sheard

5,789
5
27
42

4

This isn't really true. The call to getReadableDatabase will return a writable database object most of the time, unless the disk is full or there are permission errors. – mgv Jul 06 '11 at 13:46
2

So basically there is no different in performance and usage between either method. thanks – James Dudley Jul 07 '11 at 12:43
1

@JamesDudley Except that getReadableDatabase *doesn't* have to return a writable database. – user2864740 Dec 05 '13 at 18:19

getWritableDatabase() VS getReadableDatabase()

5 Answers5

Linked