Data model

DevLess uses a relational database as it's backing database and can expose as much as you want to clients. Controlling what a user is allowed to access or write can be done by using the rules engine. The same is true for manipulation of data before writing or after reading.

Field Types

When creating fields in DevLess, you can chose what field type that field has. The field type is used for both determining efficient storing, as well as for validation. E.g. the email type is stored in the same way as text, but is also validated.

DevLess field type Stored as Use for
text string Shorter strings/text, e.g. names
textarea longText Longer texts, e.g. comments or blog posts
integer integer Integers (whole numbers)
decimals double Decimal numbers
password string Password. Will be securely stored using a cryptographic hash. Validated to be text.
percentage integer Percentage values.
url string URLs. Will be validated as URLs.
timestamp timestamp Points in time.
boolean boolean Boolean (true or false)
email string Emails. Validated to be a valid email format
reference integer A reference to another table. At field creation, the referred field is specified. The reference is to the generated id columm of that field.
base64 base64 Binary data, for example files and images.

Table relationships

When using the reference field types, you are creating relations to some specific row in another table. The table you refer to is specified at field creation. When inserting data in this field, you have to keep track of the id of the row you want to refer to in the referred table.

Check out this video for a deeper dive into linking up data using relationships.

results matching ""

    No results matching ""