1
  • 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...

    ITKE352,565 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?

    ITKE352,565 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!

    ITKE352,565 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.

    ITKE352,565 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.

    ITKE352,565 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...

    ITKE352,565 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.

    ITKE352,565 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?

    ITKE352,565 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.

    ITKE352,565 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?

    ITKE352,565 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?

    ITKE352,565 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...

    ITKE352,565 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...

    ITKE352,565 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...

    ITKE352,565 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:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • database querying question SQLite

    Hi I'm setting up an SQLIte database within my C application that will be used as an intermediate stage in converting filetypes. My design tries to keep data normalized - for example, i have an Entity table, and in that table each entity has an integer type. There is another EntityTypes table with...

    Kreyszig15 pointsBadges:
  • Setup project force new file replacement on reinstall

    Hello, I have a setup project that install a couple of projects and a couple of external files (one of which is a SQLite Database) - everything worked fine until i've recently modified the base database file included in the setup project. Now, every time i try to reinstall the project the new...

    Trutas25 pointsBadges:
  • CMake – Automatically regenerate a file using an external tool and custom target upon “make”

    Hi. I'm working on a project and I use cmake for generating "projects", that is, under Linux, a Makefile. I also use an external tool (re2c) to generate the scanner, and an included tool to generate the parser (lemon, part of sqlite). The problem is I need to "cmake" every time I change something...

    OriginalCopy30 pointsBadges:
1

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.

Following