Can I download an SQLite db on /sdcard and access it from my Android app?

Sure you can. The docs are a little conflicting about this as they also say that no limitations are imposed. I think they should say that relative paths are to the above location and dbs there ARE private. Here is the code you want:

File dbfile = new File("/sdcard/mydb.sqlite" ); 
SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbfile, null);
System.out.println("Its open? "  + db.isOpen());

Related Contents:

  1. Version of SQLite used in Android?
  2. How can I avoid concurrency problems when using SQLite on Android?
  3. Pros and Cons of SQLite and Shared Preferences [closed]
  4. Share SQLite database between 2 android apps?
  5. Android Pre-Populated Database [duplicate]
  6. Android SQLite database: slow insertion
  7. What are the performance characteristics of sqlite with very large database files? [closed]
  8. Android: upgrading DB version and adding new table
  9. How do I view the SQLite database on an Android device? [duplicate]
  10. Simple export and import of a SQLite database on Android
  11. How do I backup a database file to the SD card on Android?
  12. Best way to work with dates in Android SQLite [closed]
  13. Android SQLite Example [closed]
  14. Android database encryption
  15. How can I merge many SQLite databases?
  16. How to retrieve the last autoincremented ID from a SQLite table?
  17. How to import load a .sql or .csv file into SQLite?
  18. Import .csv file to Sqlite in Android
  19. Cursor adapter and sqlite example [closed]
  20. How to add new Column to Android SQLite Database?
  21. Copying data from one SQLite database to another
  22. How to recover a corrupt SQLite3 database?
  23. Best place to close database connection
  24. Convert SQLITE SQL dump file to POSTGRESQL
  25. Android multiple databases open
  26. How to retrieve data from sqlite database in android and display it in TextView
  27. How to backup sqlite database?
  28. SQLite UPSERT / UPDATE OR INSERT
  29. How to save images into Database
  30. SQLiteOpenHelper onUpgrade() Confusion Android
  31. Android SimpleCursorAdapter doesn’t update when database changes
  32. Android SQLite Database, WHY drop table and recreate on upgrade
  33. How does one check if a table exists in an Android SQLite database?
  34. How do I create a database in android? [closed]
  35. Android: Cannot perform this operation because the connection pool has been closed
  36. SQLite simultaneous reading and writing
  37. Saving ArrayLists in SQLite databases
  38. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  39. Sqlite in flutter, how database assets work
  40. When to close db connection on android? Every time after your operation finished or after your app exit
  41. ER Diagram that implements Actors Database [closed]
  42. Location of sqlite database on the device
  43. Store query result in a variable using in PL/pgSQL
  44. Can I rollback a transaction I’ve already committed? (data loss)
  45. Frontend tool to manage H2 database [closed]
  46. Download Manger not working in Android Pie 9.0 NetworkSecurityConfig: No Network Security Config specified, using platform default
  47. In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?
  48. What is a sequence (Database)? When would we need it?
  49. Saving images: files or blobs?
  50. sqlite3.OperationalError: unable to open database file

Leave a Comment