Database

Overview

The database is one of the core features of Deskree. For each project, we create a separate database instance with the following features:

• Automatically generated REST & GraphQL APIs with API documentation on the platform and in a form of postman collections. The data can also be accessed via our Javascript SDK.

• Each database is protected by middleware, where you are able to configure permissions for each endpoint as well as define the API rate limits.

Currently, we allow the creation of one database per project. However, soon users will be able to have an unlimited number of databases of various types (including MySQL, Postgres, etc.).

FAQ

What are the database size limitation?

We do not limit the project based on the database size, number of columns, or other properties. You can have it as large or small as you prefer. For limitations, visit the Database Limitations page.

How can I query my database?

The database can be queried via the API interface that we provide in a form of REST, GraphQL, and Javascript SDK.

Can I import or export data?

We allow exporting and importing of data in JSON or CSV format. For more information, visit Import / Export page.

Can I connect Deskree to an existing database?

Currently, this feature is not implemented, but is it in the works and is coming in Q2 2023.

Why there is an author column in every database?

Deskree permissions allow you to configure who can access what information within your back-end. Hence, to be able to limit data edits/deletes only to the original author of an object, we save the UID of the user who originally created that object in a author column for each table. For more information visit the Permissions page.

Can I link tables?

Yes, you can "link" one table to another by creating a column with one-to-one or one-to-many reference data type. You will then be able to get this data via GraphQL Queries, or REST API and Javascript SDK using includes parameter.

What data is saved in one-to-one or one-to-many type columns?

We save the UID(s) of the object(s) from another table that you referenced. You can get the full object that is referenced without making additional API requests via REST API using includes query parameter or GraphQL Queries.

Further Reads

Users TableDatatypesImport / ExportAPI Docs per TableLimitations / Naming Conventions