XgeneCloud
Instant REST & GraphQL APIs on any Database

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

Supported Databases

• MySQL ��
• PostgresSQL ��
• MSSQL / SQL Server ��
• SQLite ��
• MariaDb ��
• Amazon Aurora ��

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

Feature Demos : Others

Youtube PlayLists

Serverless Platforms Supported

⤴️

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