XgeneCloud – Instant REST and GraphQL APIs on Any SQL Database

XgeneCloud

Instant REST & GraphQL APIs on any Database

Website • Documentation • Newsletter • Discord • Twitter • Download App

Supported Databases

• MySQL, PostgresSQL, MSSQL, SQLite, MariaDb

Usage

Install CLI

$ npm install -g xc-cli

Install & Open GUI (Built in Database & API Client)

$ xc app.install
$ xc app.open

GUI Installation Notes

• For Mac : Move the installed application to applications folder
• For Windows : Install into default paths (program files) and open app manually by going to program files.
• For Linux : Install into default path

Generate REST/GraphQL APIs Instantly

$ xc new project-name

For Help

$ xc man

Demo 1 : Generate REST APIs on existing MySQL Database

Demo 2 : GUI for Database Design and Scaffolding APIs

Demo 3 : Generate GraphQL APIs on existing MySQL Database

What is XgeneCloud ?

XgeneCloud consists of Three simple & amazing products :

• An Instant API Framework that can generate REST & GraphQL on any database
• A GUI based fully-featured Database & API Client
  • GUI DB Client enables - Point & Click schema design & schema migrations.
  • GUI API Client to debug APIs.
• A Hybrid Serverless Framework !
  • All APIs generated can be deployed as Serverless Functions on any Cloud Platform!
  • This is without changing any change to source code generated.

A Simple Overview

A Detailed Overview

Table Of Contents

• Setup
  • Install
  • Generating APIs for first time
• Architecture
  • Components
  • REST APIs
    • Router Service Model
    • Request Lifecycle
  • GraphQL APIs
    • Resolver Service Model
    • Request Lifecycle
• REST APIs Framework
  • APIs Generated
  • Authentication
  • ACL
  • Middleware
  • Swagger Documentation (autogenerated)
• GraphQL API Framework
  • Authentication
  • ACL
  • Middleware
  • GraphQL Schema Generation & Stitching
• Database
  • Database Modelling
  • Schema Migrations
  • Validations
  • Hooks for write operations
• Hybrid Serverless API Framework
  • AWS Lambda
  • GCP Cloud Functions
  • Azure Function App
  • Alibaba/Aliyun Function Compute
  • Vercel / Zeit Now
• API Client
  • Debug APIs
  • Test Performance of APIs
• CLI
  • Using man pages
    • man
  • API Generation
    • new
    • gen.apis.rest
    • gen.apis.graphql
  • Module Generation
    • gen.module
  • Database Schema Migrations
    • db.migrate.list
    • db.migrate.create
    • db.migrate.up
    • db.migrate.down
    • db.migrate.sync
  • Access Control Lists (ACL)
    • permissions.set
    • permissions.get
    • permissions.user.add
    • permissions.user.rename
    • permissions.user.delete
  • Component
    • components.add

All Demos : Instant APIs on other SQL databases

Database	REST APIs Demo	GraphQL APIs Demo

Feature Demos : Others

Feature	Links
Setup
API Client History
API Client Collections
API Performance Test
Database Client Design
Database Client Migrations
Smart Terminal
Themes : Dark
Themes : Colors
Themes : Custom Colors
Multi Environment project

Youtube PlayLists

Playlist	Link
Instant Rest APIs	Click here
Instant GraphQL APIs	Click here
Database Client - Desktop App	Click here
Smart Terminal	Click here
Themes	Click here

Serverless Platforms Supported

Cloud Platform	Serverless	Serverless Containers
AWS	Fargate
GCP	Cloud Run
Azure	Function App Container
Zeit
Alibaba	Alibaba Serverless Kubernetes

Generating REST APIs for MySQL Database Using CLI

Asciinema

Generating REST APIs for MySQL Database Using GUI

Youtube

Generating REST APIs for Postgres Database Using CLI

Asciinema

Generating REST APIs for Postgres Database Using GUI

Youtube

Generating REST APIs for MSSQL Database Using CLI

Asciinema

Generating REST APIs for MSSQL Database Using GUI

Youtube

Generating REST APIs for SQLite Database Using CLI

Coming Soon...

Generating REST APIs for SQLite Database Using GUI

Youtube

Generating REST APIs for Multiple Databases Using GUI

Youtube

Scaffolding for a Table

Youtube

Scaffolding for a Table : CLI

Youtube

Generating REST APIs for Multiple Databases Using CLI

Youtube

Generating GraphQL APIs for MySQL Database Using CLI

Asciinema

Generating GraphQL APIs for MySQL Database Using GUI

Youtube

Generating GraphQL APIs for Postgres Database Using CLI

Asciinema

Generating GraphQL APIs for Postgres Database Using GUI

Youtube

Generating GraphQL APIs for MSSQL Database Using CLI

Asciinema

Generating GraphQL APIs for MSSQL Database Using GUI

Youtube

Generating GraphQL APIs for SQLite Database Using CLI

Coming Soon...

Generating GraphQL APIs for SQLite Database Using GUI

Youtube

Generating GraphQL APIs for Multiple Databases Using GUI

Coming soon...

Generating GraphQL APIs for Multiple Databases Using CLI

Coming soon...

Scaffolding for a Table : GQL

Youtube

Scaffolding for a Table : GQL CLI

Youtube

GraphQL : ACL

Youtube

REST : ACL

Youtube

Swagger

Youtube

Setup

Asciinema

API Client History

Youtube

API Client Collections

Youtube

API Performance Test

Youtube

Database Client Design

Youtube

Database Client Migrations

Youtube

Smart Terminal

Youtube

Themes : Dark

Youtube

Themes : Colors

Youtube

Themes : Custom Colors

Youtube

Multi Environment project

Youtube

Serverless Deployment

AWS Lambda Deployment

• Open server/config/default.config.js and set aws.lambda to true and change other cloud serverless platform values as false .

• Install AWS cli & authenticate

  Refer : https://docs.aws.amazon.com/cli/index.html

• Open serverless.yml file and do the necessary changes.

• npm run aws:lambda

Azure Function App

npm install -g azure-functions-core-tools
npm run azure:deploy

GCP Cloud Function

npm run gcp:fn

Zeit Now

• Install Zeit now library and authenticate using email.

• Add production environment in config.xc.json

  "envs": {
      "production": {
        "db": [
          {
            "client": "mysql",
            "connection": {
              "host": "localhost",
              "port": "3306",
              "user": "root",
              "password": "password",
              "database": "sakila"
            },
            "meta": {
              "tableName": "_evolutions",
              "dbAlias": "primary"
            }
          }
        ],
        "api" : {}
      }
    },

• npm run zeit:now

Alibaba Function Compute

• Install fun cli tool npm install @alicloud/fun -g
• Setup alibaba account configuration in cli using fun config ( https://www.alibabacloud.com/help/doc-detail/64204.htm )
• Run

  npm run ali:fn:compute
  fun deploy