Page MenuHomeSealhub

Sealious PostgreSQL integration - add basic data types for sealious fields
Open, NormalPublic2 Points

Description

At the moment when using postgres datastore we are using JSONB type for each column created. Now we need to use proper datatypes for "plain" fileds like text, url etc. Some fileds will create two columns. Full list to be added

Name					Description														Suggested Data Type
Boolean					true or false														BOOLEAN
Color					Stores a color as string												VARCHAR
Coordinates				Stores value in GeoJSON													GEOGRAPHY
Date					Stores a date, as in a day in calendar, without time.									DATE
Datetime				Stores a timestamp as ms since epoch. Timezone-independent.								TIMESTAMP
Email					An email address													VARCHAR
Enum					Allows only values from a predefined list										VARCHAR
EnumMultiple				Stores an array of predefined strings											VARCHAR[]
File					Any kind of file													VARCHAR
Float					Any real number														FLOAT
Html					Takes text containing HTML and sanitizes it to prevent js injection							TEXT, TEXT (_original, _safe)
Image					An image. Can be scaled to different sizes automatically								VARCHAR
Int					An integer. Takes only whole numbers											INTEGER
JsonObject				Takes in arbitrary objects. Could be unsafe, requires investigation.							JSONB
Money					Keeps float value and provides ability to format as string with decode method						NUMERIC
Password				A hashed password. Used in the users collection										VARCHAR
SecretToken				Attaches a secret token when creating an item. The token cannot be read without SuperContext				VARCHAR
SessionID				Basically a mutable uuid												UUID
StructuredArray				An array of objects. Each object has the same defined field structure							JSONB[]??
Text					A text field														TEXT, TEXT
Uuid					Stores an automatically generated UUID string										UUID
Url					Accepts valid url links. You can also put some restrictions regardless valid domains and protocols			VARCHAR