• Where is a SQLite database file located on my Android device?

    I want to find the path to my SQLite database file in my android devices. Can I change the default save location to some other folder like Dropbox?

    hussain22juzer530 pointsBadges:
  • List tables in SQLite database

    In a SQLite database, is there a way to list tables? Specifically when I attach the database file with the ATTACH command on the SQLite command line tool. Thanks so much!

    ITKE371,580 pointsBadges:
  • Backup SQLite database to SD card on Android

    I'm trying to add a feature to one of my Android applications that would back up a SQLite database to my SD card. Is there a way to do this? Thank you very much!

    ITKE371,580 pointsBadges:
  • How to backup SQLite database to SD card

    Does anyone know if it's possible to backup our database to a SD card automatically in my Android app? After that's done, is there a way to restore it too?

    ITKE371,580 pointsBadges:
  • How can I backup a SQLite database to my SD card?

    I'm trying to add a feature in my Android application that would automatically back up a SQLite database to my SD card. Is there a way to do this? Thank you very much.

    ITKE371,580 pointsBadges:
  • Move places.SQLite file bookmark backup to another laptop

    My laptop died but I salvaged HD. Now I need to move places.sqlite file bookmark backups to another laptop. How can I do that?

    deweydoit5 pointsBadges:
  • Where are my database files stored on my Android device?

    I've just created a SQLite database on my Android device. The program reads/writes to the database so the file has been created. Here's what the SQLiteDatabase.mPath is set to: db.mPath = "/data/data/dev.client.android/databases/clientDB.db" But my problem is when I'm browsing the directories on my...

    ITKE371,580 pointsBadges:
  • What’s the better database option: MySQL or SQLite?

    Our organization is deciding to use either SQLite and MySQL for our database. We understand that SQLite is a single-file database and MySQL is just a normal database. But in your opinion, what's the better option?

    ITKE371,580 pointsBadges:
  • How to export a MySQL database to SQLite

    I apologize for the short question but can anyone help me export my MySQL database into a SQLite database? Thanks so much!

    ITKE371,580 pointsBadges:
  • How to copy data from one SQLite database to another

    My team has two different SQLite databases that have similar data but with different purposes and we would like to avoid reinserting the data. So basically we're wondering if there's a way to copy a table from one database to another. Thanks so much.

    ITKE371,580 pointsBadges:
  • How to list the tables from a SQLite database file

    What SQL can I use to list all the tables in a SQLite database file (along with the rows inside those tables)? Thank so much for the help.

    ITKE371,580 pointsBadges:
  • Adding a new table to our SQLite database

    My team and I have already created SQLite tables but we're looking to add a new table to our database. Here's the DB version: private static final int DATABASE_VERSION = 2; We've also added this string to create the table: private static final String DATABASE_CREATE_color = "CREATE TABLE IF NOT...

    ITKE371,580 pointsBadges:
  • What’s the better embedded database: SQLite or MongoDB?

    I've been working on a RSS reader application and I'm looking at several different back end databases to use. I need the database to be embedded because I don't want the users to install a database server. I'm between SQLite and MongoDB. Which one is the better choice?

    ITKE371,580 pointsBadges:
  • How can I browse a SQLite database in Android

    I'm an Android user and I was wondering if there's a way to browse SQLite databases on my smartphone / view the data in the databases. I've been using SoftTrace but I was wondering if there was a mobile way to do it.

    ITKE371,580 pointsBadges:
  • Joining tables from a different SQLite database

    In one of my applications, I currently use a SQLite database and it's been working great. But I've been adding new functions and features so I'll need a second database and I'm having trouble with joining tables from a different database. How can I do this?

    ITKE371,580 pointsBadges:
  • How to encrypt a SQLite database

    I understand that Android uses SQLite database to store data but now I need to encrypt a SQLite database but I'm not sure how this can be done. What's the process to do so? My friend mentioned SQLCipher, would that work?

    ITKE371,580 pointsBadges:
  • Would I be able to merge multiple SQLite databases?

    I currently have a large number of SQLite databases (that all have the same schema). Is there a way I can merge them altogether so I can perform a query on all the databases? I thought I could use "ATTACH" but I found out it has a limit of 32 / 64 databases (depending on the memory system). Can...

    ITKE371,580 pointsBadges:
  • What’s the posting limit for client-side storage?

    Does anyone know if the posting limits for client-side storage are still correct? I've seen that for LocalStorage, the sizes are 5MB SQLite storage and another 5MB is expandable by a user's request. Also, are these storage schemes exclusive? I mean is this limit an aggregate of all client-side...

    ITKE371,580 pointsBadges:
  • Should I use SQLite or Shared Preferences for data storage?

    For storage purposes, does anyone think there's more of an advantage using SQLite over Shared Preferences? My application data is currently small right now but it might rise quickly over the next few months. Is there any differences in speed between the two? In your honest opinion, which option...

    ITKE371,580 pointsBadges:
  • SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.