Database Features Reference
Common aspects pertaining to APIs 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 Db | Any 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 Objects | Via Low-Code Customize |
info
Schema Reference https://graphql.org/learn/schema/
Queries
| All Supported Db | Any Exceptions | |
|---|---|---|
| Simple | ✅ | |
| Filter / Search | ✅ | |
| Sort | ✅ | |
| Paginate | ✅ | |
| Multiple Arguments | ✅ | |
| Multiple Queries | ✅ | |
| Variables / Aliases / Fragments | ✅ | |
| Table Relationship Queries | ✅ | |
| Nested Objects | Via Low-Code Customize |
Mutations
| All Supported Db | Any Exceptions | |
|---|---|---|
| Insert | ✅ | |
| Update | ✅ | |
| Delete | ✅ |
Subscriptions
| All Supported Db | Any Exceptions | |
|---|---|---|
| Subscriptions | ✅ |
GraphQL & REST
Below features applicable to both GraphQL & REST APIs.
Extend with Serverless Function
| All Supported Db | Any Exceptions | |
|---|---|---|
| Cloud Functions | ✅ | |
| AWS Lambda | ✅ | |
| Azure Cloud Functions | ✅ | |
| Google Cloud Functions | ✅ |