dashboard icon indicating copy to clipboard operation
dashboard copied to clipboard

Optimising data type rendering

Open sunng87 opened this issue 3 years ago • 2 comments

As we have finished rendering data as table and chart, the next step is to visualize data type/table schema information.

Date types

As of https://github.com/GreptimeTeam/greptimedb/tree/v0.1.0-alpha-20221205-weekly, we have following data types supported:

  • Null (can be ignored when rendering schema)
  • Boolean
  • Numbers:
    • Int8
    • Int16
    • Int32
    • Int64
    • UInt8
    • UInt16
    • UInt32
    • UInt64
    • Float32
    • Float64
  • Strings:
    • Binary bytes (not supported for now)
    • String
  • Time and date:
    • Date
    • DateTime
    • Timestamp
  • Compound types
    • List (not well supported at the moment, ignored for now)

https://github.com/GreptimeTeam/greptimedb/blob/v0.1.0-alpha-20221205-weekly/src/datatypes/src/data_type.rs#L34

So the main types we going to render are:

  • Boolean
  • Number
  • Strings
  • Date time types

Rendering

How we are rendering these types:

  • Use icon and tooltip for table schema tree
  • Use icon and tooltip for result table row header
  • Use custom styles for result table content:
    • use special style for string, hex bytes
    • use special style for date time types, add readable tooltip for timestamps

sunng87 avatar Dec 06 '22 03:12 sunng87

https://docs.greptime.com/reference/data-types We have 4 types of timestamp[(0/3/6/9)]. Probably need to address this. Fixed by #312 for #311

ZonaHex avatar Aug 08 '23 03:08 ZonaHex

https://github.com/GreptimeTeam/greptimedb/issues/2072 Follow up on this. Probably need to change time types.

ZonaHex avatar Aug 17 '23 04:08 ZonaHex