Share SQLite database between 2 android apps?

by

UPDATE: The method described below relies on android:sharedUserId, deprecated as of API level 29 (Android 10).

You certainly can share a single database between 2 apps.

In order to share data between apps (provided they are issued by the same publisher) you will need to specify a shared user id in the AndroidManifest.xml of both apps.

<manifest xmlns:android="http://schemas.android.com/apk/res/android" android:sharedUserId="my.app" ... >

(It’s undocumented, but the shared user id needs to be a string with at least one dot separator)

The rest is easy, and you don’t need to mess around with the database path. Just use the same DBAdapter in both apps. In the app that hosts the database, call the DBAdapter with the native context.

DBadapter hostDBAdapter = new DbAdapter(getApplicationContext());
performerDBadapter.open();

In the second app, access the database with the context of the database hosting app.
First, define the shared context:

Context sharedContext = null;
    try {
        sharedContext = this.createPackageContext("replace.with.host.package.name", Context.CONTEXT_INCLUDE_CODE);
        if (sharedContext == null) {
            return;
        }
    } catch (Exception e) {
        String error = e.getMessage(); 
        return;
        }

Then open the DBAdapter with the shared context:

DbAdapter sharedDBadapter = new PerformerDbAdapter(sharedContext);
sharedDBadapter.open();

As a final note, if your database exists previous to setting the shared user id in the manifest, you will need to uninstall/reinstall the apps on a physical device, lest you will lock yourself out of your database (sqlite error 14). The emulator, on the other hand, might prove to be more forgiving. Bottom line, if your apps are published on the Android market, setting a shared user id in an afterthought will not work.

Hope this helps.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. Pros and Cons of SQLite and Shared Preferences [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. Best place to close database connection
  9. Import .csv file to Sqlite in Android
  10. Cursor adapter and sqlite example [closed]
  11. How to add new Column to Android SQLite Database?
  12. How to retrieve data from sqlite database in android and display it in TextView
  13. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  14. How do I create a database in android? [closed]
  15. How to save images into Database
  16. Android SimpleCursorAdapter doesn’t update when database changes
  17. SQLite simultaneous reading and writing
  18. update sql database with ContentValues and the update-method
  19. How does one check if a table exists in an Android SQLite database?
  20. Create SQLite database in android
  21. Could not allocate CursorWindow
  22. Saving ArrayLists in SQLite databases
  23. android, how to exec a sql file in sqlitedatabase
  24. SQLiteOpenHelper – creating database on SD card
  25. SQLite android column not found
  26. How to store JSON object in SQLite database
  27. H2 Database vs SQLite on Android [closed]
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment