Open encrypted SQLite database with DB Browser

  1. 4 months ago

    Craig G

    Feb 16 Australia

    I'm trying to open an SQLITE database with DB Browser for SQLite so I can run some error checks on it.
    When I'm prompted for a password I enter my encryption key used to open the file in my app. But the password won't open it.
    DB Browser only asks for the password and page size which is set at 1024 by default.
    Am I doing something wrong or is there a better program out there for this purpose?

    @Paul S Paul Sondervan 4 hours ago Pre-Release Testers, Xojo Pro Europe (Netherlands, Den Haag)

    SQLiteManager by SQLabs can open encrypted SQLite databases

    Thanks, that's a much better program and it does open encrypted Xojo SQLite databases. It should, it's written in Xojo :)
    Unfortunately the corrupt one won't open but at least I know it's nothing to do with the password.

    I think it's a worthwhile investment to purchase the full version of SQLiteManager.
    It is so much easier to build and execute complex SQL queries in a program like this rather than continually running your app in debug mode to see if you get the results you want.

  2. Edited 4 months ago

    @Craig G — Well the latest release 3.11.0 has been pulled because of encryption problems on 11th February 2019. Could it be your case?

  3. Craig G

    Feb 16 Australia
    Edited 4 months ago

    I am using 3.10.1 but I've tried several times in the last 12 months with no success.
    I normally work-around by starting my app and setting a breakpoint after it unlocks the file with the password.
    Then while the app is paused used the DB browser to view the unlocked file but in this case the database is corrupt and the app won't get to that point.

  4. Jean-Yves P

    Feb 16 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    using sqlite with multiples users ;) ???

  5. Craig G

    Feb 16 Australia

    No it's a desktop app.

  6. Dave S

    Feb 16 San Diego, California USA

    Bear in mind that there are multiple encryption schemas that can be employed with SQLite, so if it was encrypted with one method, then perhaps the app uses another.

  7. @Craig G — Do you use an ASCII password?

  8. Craig G

    Feb 16 Australia
    Edited 4 months ago

    @Dave S Bear in mind that there are multiple encryption schemas that can be employed with SQLite, so if it was encrypted with one method, then perhaps the app uses another.

    Yes that's probably it.
    Can anyone recommend a compatible program that can open an Xojo SQLite encrypted database?
    I use "DB Browser For SQLite" for unencrypted database and it's works fine.
    A great tool for quick checks for data writes when debugging or testing SQL before using it in the program.

  9. Craig G

    Feb 16 Australia
    Edited 4 months ago

    @Stéphane ;Mons @Craig Grech — Do you use an ASCII password?

    Yes, no special characters. It's a local file and is only to prevent curious tampering by the owner.

  10. Dave S

    Feb 16 San Diego, California USA
    Edited 4 months ago

    my Tadpole app will open an encrypted SQLite database... assuming it was encrypted using the same method that Xojo uses

    if the contents isn't sensitive, and you want to send to to me, I will verify if it can or cannot

  11. Craig G

    Feb 16 Australia

    @Dave S my Tadpole app will open an encrypted SQLite database... assuming it was encrypted using the same method that Xojo uses

    if the contents isn't sensitive, and you want to send to to me, I will verify if it can or cannot

    I will just need to get the owners permission first.

  12. Paul S

    Feb 16 Pre-Release Testers, Xojo Pro Europe (Netherlands, Den Haag)

    SQLiteManager by SQLabs can open encrypted SQLite databases

  13. Craig G

    Feb 16 Answer Australia
    Edited 4 months ago

    @Paul S Paul Sondervan 4 hours ago Pre-Release Testers, Xojo Pro Europe (Netherlands, Den Haag)

    SQLiteManager by SQLabs can open encrypted SQLite databases

    Thanks, that's a much better program and it does open encrypted Xojo SQLite databases. It should, it's written in Xojo :)
    Unfortunately the corrupt one won't open but at least I know it's nothing to do with the password.

    I think it's a worthwhile investment to purchase the full version of SQLiteManager.
    It is so much easier to build and execute complex SQL queries in a program like this rather than continually running your app in debug mode to see if you get the results you want.

  14. Jean-Yves P

    Feb 17 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    @Craig G It is so much easier to build and execute complex SQL queries in a program like this rather than continually running your app in debug mode to see if you get the results you want.

    yep ...
    or make your own ?
    -image-
    -image-

or Sign Up to reply!