Forum Question: What app to open db file?

What application should be used to open cache.db?

In text it is just gobbledygook.

Does your book get into details like this?

— B Mueller

Comments: 7 Responses to “What app to open db file?”

    11/24/09 @ 2:01 pm

    That’s not really a file you should open. It is a SQL database of some flavor. There is no basic level application for it — not sure what you would do with it anyway unless you were hacking the application that made the .db file.
    I don’t mention it in the book because there is no use for doing this, especially for beginning-level users.

      B Mueller
      11/25/09 @ 1:26 pm

      The reason I asked was a follow up to my question about corrupted software downloads.

      You said go to library/caches/com.apple.softwareupdate, and remove the corrupted update.

      That brings up caches.db but not the individual update. Is there a way to clear the cache?

        11/25/09 @ 9:03 pm

        Ah, I see. In this case, don’t worry about it. Just remove the other cache files that would show the downloads themselves — if you even see any. You can delete the .db file as well if you have nothing in the cache. Or, even if you do. The worst that would happen is that Software Update would rebuild the database the next time you did an update. No big deal.

      Todd
      1/31/11 @ 2:28 pm

      I’ve come across another use for opening this type of file. There is an iPhone 2Do App that has the ability to export your lists. The export is in the form of a .db file. I’d like to be able open this file and save it as an excel or work file if possible.

        1/31/11 @ 2:42 pm

        It is possibly (likely?) that the .db file exported by the app and the .db file from the original question are two different file formats. They just happened to choose the .db extension. Have you tried to look in the app developer’s support info for ways you can use their .db file? They should say something about it there if it is a useful function of the app.

    B Mueller
    11/30/09 @ 12:59 pm

    Thank you so much Gary.

    Your help and website are the best there is for us switchers.

    Thanks again.

    Todd
    1/31/11 @ 4:47 pm

    I’ll look into that. Thanks for the tip.

Comments Closed.