Skip to main content

Database Features Reference

Common aspects pertaining to databases features reference guide for Backend APIs - GraphQL and REST APIs.

Introduction

EasyManage generates GraphQL and REST APIs from tables/views in your database.

Feature support

The below table shows the database wise support for the GraphQL & REST features.

Supported Databases List : Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server, Azure SQL, (DB2, H2, HSQLDB)

GraphQL

GraphQL EasyManage automatically generates your GraphQL schema and resolvers based on tables/views in your database . No more manual coling for GraphQL schema or resolvers.

Schema

All Supported DbAny Exceptions
Type language - GraphQL schema language
Object types and fields
Arguments
The Query and Mutation types
Scalar types
Custom Scalar types Date, DateTime, Time
Enumeration types
Lists and Non-Null
Input types
Nested ObjectsVia Low-Code Customize

Queries

All Supported DbAny Exceptions
Simple
Filter / Search
Sort
Paginate
Multiple Arguments
Multiple Queries
Variables / Aliases / Fragments
Table Relationship Queries
Nested ObjectsVia Low-Code Customize

Mutations

All Supported DbAny Exceptions
Insert
Update
Delete

Subscriptions

All Supported DbAny Exceptions
Subscriptions

GraphQL & REST

Below features applicable to both GraphQL & REST APIs.

Extend with Serverless Function

All Supported DbAny Exceptions
Cloud Functions
AWS Lambda
Azure Cloud Functions
Google Cloud Functions