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.