XSQUARE DAC

A standalone web server, allowing to automate the process of creating REST API by providing access to stored procedures and functions on the PostgreSQL side

The advantages of using XDAC

  • Development requirements

    • One only needs to know PostgreSQL
    • Minimum training time for a programmer with Oracle Developer
      • - 2-5 days for MySQL/PHP Developer
      • - 14 days for MS SQL Developer
    • 1 command to install - yum install xdac
    • 10 parameters to set up

  • Environment requirements

    • 15 МБ RAM to work with 10 users HTTP clients
    • 100 МБ RAM to work with 1000 users HTTP clients
    • 2-5% additional load on the Postgres DB
    • Any RPM/DEB operating system
    • Any architecture - X86 / ARM / E2K / LoongArch

  • Launch Requirements

    • 10 minutes to create a service to receive data on the client curl curl http://host/api/getClient?id=2342
    • Creating enterprise applications 10x faster, using 100x less code
    • MVP of a microservice application in 2-3 days

The architecture of XDAC

Login and Try It

Demo

More details

Documentation

More details

Download

More details

The platform provides

  • Automatic creation

    connection endpoints (API) based on stored procedures and DB functions

  • Automatic conversion

    signatures of procedures and functions into API request parameters

  • Possibility of using

    several methods to work with the created API (GET/POST)

  • Ability to customize

    access to endpoints using the DB user rights settings

  • Granting access

    to additional http request parameters (headers, response code, etc.) inside called procedures and functions

  • Ability to process

    multipart/form-data requests

  • Loading
    and uploading

    of binary data

  • Service
    and balancing

    HTTP requests between the Web client and the database

  • Database
    Support

    PostgreSQL versions 13 and higher

  • Pool
    Support

    of the database connections