UBports Robot Logo UBports Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Where is the database?

    Scheduled Pinned Locked Moved App Development
    4 Posts 3 Posters 44 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D Offline
      dl8aax
      last edited by

      Hello,

      I'd like to create a function for backing up the SQLite3 database. Where can I find the database? Is there a way to query it? And is this the same for all devices?

      Best regards,

      Dirk

      Vlad NirkyV 1 Reply Last reply Reply Quote 0
      • Vlad NirkyV Online
        Vlad Nirky @dl8aax
        last edited by

        @dl8aax
        Could you give some more details about the database to be backed up?
        Which application is it for?

        D 1 Reply Last reply Reply Quote 0
        • D Offline
          dl8aax @Vlad Nirky
          last edited by

          @Vlad-Nirky said:

          Could you give some more details about the database to be backed up?
          Which application is it for?

          I'm creating the database with:

          var db = LocalStorage.openDatabaseSync("MienImmen", "1.0", "", 1000000);

          Because there's also important data, I want to back up the database and import it to my PC. Swapping the database is less error-prone than exporting and importing individual tables.

          There are approximately 40 tables.

          lduboeufL 1 Reply Last reply Reply Quote 0
          • lduboeufL Online
            lduboeuf @dl8aax
            last edited by

            @dl8aax said:

            @Vlad-Nirky said:

            Could you give some more details about the database to be backed up?
            Which application is it for?

            I'm creating the database with:

            var db = LocalStorage.openDatabaseSync("MienImmen", "1.0", "", 1000000);

            Because there's also important data, I want to back up the database and import it to my PC. Swapping the database is less error-prone than exporting and importing individual tables.

            There are approximately 40 tables.

            App databases are stored under the app namespace, e.g if your app is called "abd.xyz", you should either find it in ~/.local/share/abd.xyz or under ./config/abd.xyz

            1 Reply Last reply Reply Quote 0

            Hello! It looks like you're interested in this conversation, but you don't have an account yet.

            Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

            With your input, this post could be even better 💗

            Register Login
            • First post
              Last post