7

I use reading and writing to the database without any problems . But I can not find out the difference. I searched on Internet but it 's not quite clear. Can anyone tell me the difference? In which case should I use getWritableDatabase() or getReadableDatabase()?

CopsOnRoad
  • 237,138
  • 77
  • 654
  • 440
Tai Tran
  • 1,406
  • 3
  • 15
  • 27
  • possible duplicate of [getWritableDatabase() VS getReadableDatabase()](http://stackoverflow.com/questions/6597277/getwritabledatabase-vs-getreadabledatabase) – Krishnabhadra Jun 01 '12 at 04:54
  • http://stackoverflow.com/questions/3066318/how-often-to-run-getwritabledatabase-and-getreadabledatabase – Krishnabhadra Jun 01 '12 at 04:54
  • I read it, But I cant not find the different and the conclusion? – Tai Tran Jun 01 '12 at 05:00
  • http://stackoverflow.com/questions/6597277/getwritabledatabase-vs-getreadabledatabase – Manroop Jun 01 '12 at 05:34
  • @oers : Thank you because of fixing my poor English. – Tai Tran Jun 01 '12 at 07:19
  • Possible duplicate of [getWritableDatabase() VS getReadableDatabase()](https://stackoverflow.com/questions/6597277/getwritabledatabase-vs-getreadabledatabase) – Mark Nov 24 '19 at 10:28

5 Answers5

22

Taken from my deleted answer here (this question is a duplicate of that one).

In normal situations, getReadableDatabase() will return the same writable database returned by getWritableDatabase().

However, should it not be possible to return a writable database, getWritableDatabase() will fail, whereas getReadableDatabase() will attempt to return a READ_ONLY database.

Mark
  • 7,446
  • 5
  • 55
  • 75
10

Check the Reference

public synchronized SQLiteDatabase getReadableDatabase ()

Since: API Level 1

Create and/or open a database. This will be the same object returned by getWritableDatabase() unless some problem, such as a full disk, requires the database to be opened read-only. In that case, a read-only database object will be returned. If the problem is fixed, a future call to getWritableDatabase() may succeed, in which case the read-only database object will be closed and the read/write object will be returned in the future.

Like getWritableDatabase(), this method may take a long time to return, so you should not call it from the application main thread, including from ContentProvider.onCreate(). Returns

a database object valid until getWritableDatabase() or close() is called.

Throws SQLiteException if the database cannot be opened

public synchronized SQLiteDatabase getWritableDatabase ()

Since: API Level 1

Create and/or open a database that will be used for reading and writing. The first time this is called, the database will be opened and onCreate(SQLiteDatabase), onUpgrade(SQLiteDatabase, int, int) and/or onOpen(SQLiteDatabase) will be called.

Once opened successfully, the database is cached, so you can call this method every time you need to write to the database. (Make sure to call close() when you no longer need the database.) Errors such as bad permissions or a full disk may cause this method to fail, but future attempts may succeed if the problem is fixed.

Database upgrade may take a long time, you should not call this method from the application main thread, including from ContentProvider.onCreate(). Returns

a read/write database object valid until close() is called

Throws SQLiteException if the database cannot be opened for writing

Imran Rana
  • 11,899
  • 7
  • 45
  • 51
  • 2
    @tai.tran2008 look first para: **This(getReadableDatabase ()) will be the same object returned by getWritableDatabase() unless some problem, such as a full disk, requires the database to be opened read-only**. So, use **getReadableDatabase()** if you want to read only as name makes it simplified to understand what you want. – Imran Rana Jun 01 '12 at 05:10
3

The different between two is the condition when disk become full. Both the getReadableDatabase() and getWritableDatabase() task is to open/create database.

But when the disk got full application crashes if you make a call to getWritableDatabase(). However, getReadbleDatabase() works fine in this case. Since, the getReadableDatabase() blocks write operations and allows Read operation.

Don't call these methods from applications main thread like from onCreate() method of MainActivity in Android or any callback methods.

seenukarthi
  • 8,241
  • 10
  • 47
  • 68
user1957229
  • 61
  • 4
0

The main difference is -

getReadbleDatabase() -

  • Create and/or open a database. This will be the same object returned by getWritableDatabase() unless some problem, such as a full disk, requires the database to be opened read-only. In that case, a read-only database object will be returned. If the problem is fixed, a future call to getWritableDatabase() may succeed, in which case the read-only database object will be closed and the read/write object will be returned in the future.

getWritableDatabase() -

  • Create and/or open a database that will be used for reading and writing. The first time this is called, the database will be opened and onCreate(SQLiteDatabase), onUpgrade(SQLiteDatabase, int, int) and/or onOpen(SQLiteDatabase) will be called. Once opened successfully, the database is cached, so you can call this method every time you need to write to the database. (Make sure to call close() when you no longer need the database.) Errors such as bad permissions or a full disk may cause this method to fail, but future attempts may succeed if the problem is fixed.
Dipankar Baghel
  • 1,932
  • 2
  • 12
  • 24
0

If your database crashes GetReadableDatabase() will return you a read/only object while GetWriteableDatabase() will fail.

Navjot
  • 1,202
  • 1
  • 11
  • 24
Alex Max
  • 1
  • 1