Decode MessagePack, igbinary, Protobuf and Avro values with Display As

未关闭
  • 哪里不对？
#3,607 2 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

维护者通常 1 天内回复

还没有人认领这个 Issue。

评估

难度
5/5
预计耗时
一周以上
新手友好度
25/100
Issue 类型
功能
描述清晰度
描述清楚
活跃度
活跃
技术栈
kafka, mysql, postgresql, swift
领域
database, databases

调研方向

Start with apple/TablePro/Core/Services/Formatting/ValueDisplayFormat.swift and ValueDisplayFormatter.swift, then review features/json-viewer.mdx and databases/kafka.mdx for existing viewer behavior. Identify how per-column formats and Kafka schema settings are represented before scoping the decoders. Done means reference-library fixtures decode for each format, invalid values fall back to hex with an explanation, and swapped-time UUIDs display as their original UUID.

由索引模型根据 Issue 内容生成。

描述

enhancement platform-macos
Problem

Display As has seven formats: Raw Value, Text, UUID, two Unix timestamps, JSON and PHP Serialized (features/json-viewer.mdx:14-22, apple/TablePro/Core/Services/Formatting/ValueDisplayFormat.swift:12-19). A binary column that holds a compact serialization shows only hex:

  • MessagePack, common for cache payloads and job queues.
  • igbinary, the binary form of PHP serialization, which the PHP Serialized viewer does not read.
  • Protobuf and Avro. On Kafka, a topic whose values are Avro or Protobuf shows the raw bytes, five-byte wire-format prefix included (databases/kafka.mdx:151-152).

The UUID format also renders the bytes in stored order (apple/TablePro/Core/Services/Formatting/ValueDisplayFormatter.swift:56-74). A MySQL column filled with UUID_TO_BIN(uuid, 1), which moves the time fields to the front, renders as a UUID that differs from the one the application wrote.

Proposed solution
  • MessagePack on binary columns: decoded into the JSON tree viewer, read-only, with badges for bin, ext and timestamp values.
  • igbinary on binary columns: decoded into the PHP serialized viewer's tree.
  • Protobuf on binary columns: with no schema, the wire format as field numbers and wire types. With a .proto file or descriptor set chosen for the column, field names and types.
  • Avro on binary columns: decoded with a writer schema file chosen for the column.
  • On Kafka, a value with the wire-format prefix reads its schema ID, and when the connection names a Schema Registry URL, the Avro or Protobuf schema is fetched from it.
  • UUID (Swapped Time) for UUID_TO_BIN(uuid, 1) columns, and an edit typed as a UUID is written back in the same byte order.
  • Each format behaves like the existing ones: set per column and scoped to the connection and table, rendering only, a single copied cell copies the decoded text, and filters and highlight rules still read the stored value (features/filtering.mdx:32).
  • A value that does not decode falls back to hex, and the viewer says why.

Done when: each format decodes a fixture written by its reference library, a broken value falls back to hex, and a UUID_TO_BIN(uuid, 1) value renders as the UUID passed in.

Alternatives considered

Copy the hex out and decode it with a script, or write a view that decodes on the server where the engine can.

Platform

macOS

Related database type

N/A / General

主要语言
Swift
星标
6.2k
派生
412
平均合并
3 小时 56 分钟
30 天内合并 PR
669

环境准备

这个项目没有提供开发容器、Dockerfile 或贡献指南，环境需要你自己搭建：先看它的 README，通用步骤见我们的新手贡献指南。

从这里开始

  1. 先读完整个 Issue，再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库，在一个分支上完成修改。
  4. 提交 Pull Request，并在描述里引用这个 Issue 编号。

TableProApp/TablePro 的其他 Issue

查看 TableProApp/TablePro 的全部 Issue

相似的 Issue

更多 Swift Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。