Skip to content

TablePro icon used for sql and duckdb file types even when not set as the default app to open them with #1594

@somelinguist

Description

@somelinguist

What happened?

After installing TablePro, its icon used for sql and duckdb file types even when it is not set as the default app to open those types.

I'm not sure if this is because TablePro registers itself as the Owner of sql and duckdb file types:

<dict>
<key>CFBundleTypeExtensions</key>
<array>
<string>sql</string>
</array>
<key>CFBundleTypeIconFile</key>
<string>SQLDocument</string>
<key>CFBundleTypeName</key>
<string>SQL File</string>
<key>CFBundleTypeRole</key>
<string>Editor</string>
<key>LSHandlerRank</key>
<string>Owner</string>
<key>LSItemContentTypes</key>
<array>
<string>com.tablepro.sql</string>
<string>public.sql</string>
</array>
</dict>

<dict>
<key>CFBundleTypeName</key>
<string>DuckDB Database</string>
<key>CFBundleTypeRole</key>
<string>Editor</string>
<key>LSHandlerRank</key>
<string>Owner</string>
<key>CFBundleTypeExtensions</key>
<array>
<string>duckdb</string>
<string>ddb</string>
</array>
<key>LSItemContentTypes</key>
<array>
<string>com.tablepro.duckdb</string>
</array>
</dict>

Another possibility is because TablePro registers also itself as exporting UTI types that override public.sql and public.database

<key>UTExportedTypeDeclarations</key>
<array>
<dict>
<key>UTTypeIdentifier</key>
<string>com.tablepro.sql</string>
<key>UTTypeDescription</key>
<string>SQL File</string>
<key>UTTypeIconFile</key>
<string>SQLDocument</string>
<key>UTTypeConformsTo</key>
<array>
<string>public.sql</string>
<string>public.plain-text</string>
</array>
<key>UTTypeTagSpecification</key>
<dict>
<key>public.filename-extension</key>
<array>
<string>sql</string>
</array>
</dict>
</dict>
<dict>
<key>UTTypeIdentifier</key>
<string>com.tablepro.sqlite-db</string>
<key>UTTypeDescription</key>
<string>SQLite Database</string>
<key>UTTypeConformsTo</key>
<array>
<string>com.apple.sqlite3</string>
<string>public.database</string>
<string>public.data</string>
</array>
<key>UTTypeTagSpecification</key>
<dict>
<key>public.filename-extension</key>
<array>
<string>db</string>
<string>db3</string>
<string>s3db</string>
<string>sl3</string>
<string>sqlite</string>
<string>sqlite3</string>
<string>sqlitedb</string>
</array>
</dict>
</dict>
<dict>
<key>UTTypeIdentifier</key>
<string>com.tablepro.duckdb</string>
<key>UTTypeDescription</key>
<string>DuckDB Database</string>
<key>UTTypeConformsTo</key>
<array>
<string>public.database</string>
<string>public.data</string>
</array>
<key>UTTypeTagSpecification</key>
<dict>
<key>public.filename-extension</key>
<array>
<string>duckdb</string>
<string>ddb</string>
</array>
</dict>
</dict>

Whatever the issue, since there are many apps that can open and save sql files, it would be nice if TablePro didn't make it impossible or difficult to associate the desired app's icon.

Steps to reproduce

No response

Expected behavior

No response

Database type

None

TablePro version

No response

macOS version & chip

No response

Screenshots / Logs

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions