Skip to content

.db not registered as SQLite document type — Finder "Open With" grays out TablePro #1327

@salmonumbrella

Description

@salmonumbrella

What happened?

TablePro's Info.plist registers six SQLite extensions under the "SQLite Database" document type — sqlite, sqlite3, db3, s3db, sl3, sqlitedb — but not the bare .db extension. Finder therefore grays out TablePro under right-click → Open With for .db files, even though .db is one of the most common SQLite extensions in the wild (Django's default app DB, many macOS system stores, Anki, Bear, Things).

Steps to reproduce

  1. Save any SQLite database with a .db extension (e.g., the Chinook sample DB).
  2. In Finder, right-click the file → Open With.
  3. TablePro is grayed out / not offered.

Expected behavior

TablePro appears in Finder's "Open With" menu for .db files and can be set as the default handler, the same way it handles .sqlite and .sqlite3.

Suggested fix

Add db to the SQLite Database entry under CFBundleDocumentTypes:

CFBundleTypeExtensions = (
    sqlite, sqlite3, db, db3, s3db, sl3, sqlitedb
);

Current entry (from installed Info.plist)

CFBundleTypeExtensions = ( sqlite, sqlite3, db3, s3db, sl3, sqlitedb );
CFBundleTypeName = "SQLite Database";
LSHandlerRank = Default;
LSItemContentTypes = ( "com.apple.sqlite3", "com.tablepro.sqlite-db" );

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions