:fire: :fire: Instantly generate REST & GraphQL APIs on any Database (Supports : MySQL, PostgreSQL, MsSQL, SQLite, MariaDB)

repo name	xgenecloud/xgenecloud
repo link	https://github.com/xgenecloud/xgenecloud
homepage	https://xgenecloud.com
language	JavaScript
size (curr.)	77841 kB
stars (curr.)	767
created	2020-06-09
license	Apache License 2.0

Supported Databases

• MySQL :fire:
• PostgresSQL :fire:
• MSSQL / SQL Server :fire:
• SQLite :fire:
• MariaDb :fire:

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

Amazing Responses To Our HackerNews Launch

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

Please Note

• Whilst we are in beta - you can expect some breaking changes.

All Demos : Instant APIs on other SQL databases

Database	REST APIs Demo	GraphQL APIs Demo
MySql	using CLI / using GUI	using CLI / using GUI
Postgres	using CLI / using GUI	using CLI / using GUI
MsSql	using CLI / using GUI	using CLI / using GUI
Sqlite3	using CLI / using GUI	using CLI / using GUI
MariaDb	using CLI / using GUI	using CLI / using GUI
Multiple Databases	using CLI / using GUI	using CLI / using GUI
Scaffolding for a Table	using CLI / using GUI	using CLI / using GUI
ACL	Click here	Click here
Auto Documentation	Click here

Feature Demos : Others

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

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	Lambda	Fargate
GCP	Cloud Function	Cloud Run
Azure	Function App	Function App Container
Zeit	Now
Alibaba	Function Compute	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

• Install Azure cli and login.
• npm install -g azure-functions-core-tools
• npm run azure:deploy

⤴️

GCP Cloud Function

• Install Google Cloud cli and authenticate.
• 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
  • or fun deploy