Rendering different data types in the Tables UI

[cstns]

Even though we won’t initially allow users to create tables with all possible data types through the UI, they will be able to do so manually since they have unrestricted access to their database.

That means we’ll need basic guidelines on how to display the different data types supported by Postgres.

The main questions that need to be answered for each data type are:

• Should it be displayed inline in the table?
• Should it be parsed before displaying the value?
• Should it be truncated?
• Should it be displayed in a separate modal (if over a given size)?

Related to https://github.com/FlowFuse/flowfuse/pull/5839

[joepavitt]

@gstout52 FYI - I've asked Serban to add this into 2.21 because it's a follow up we need for Tables.

[gstout52]

How's this looking, @cstns ?

[cstns]

Did not get a chance to look at it yet, It'll most probably get postponed to 2.22

[cstns]

I have compiled a list with details for each supported data type supported by a barebone postgres setup and also put a pin in dev time as there are more pressing issues that need attention.

data-types.csv

[gstout52]

I have compiled a list with details for each supported data type supported by a barebone postgres setup and also put a pin in dev time as there are more pressing issues that need attention.

data-types.csv

Can you take a look @joepavitt ?