Daptin

Daptin is a server exposing HTTP APIs for web and application developers providing to talk to database and persistent storage.

• Consistent API with authentication and authorization for database table and metadata

• User management and user group management API with row and table level ownership

• Stateless and easily scalable

• Dadadash : https://github.com/daptin/dadadash/

  • docker run -p 8080:8080 daptin/dadadash

Go down if you are looking for headless CMS

Download • Documentation • Community

The most powerful ready to use data and services API server.

• Define data tables and relations from YAML or Web dashboard UI
  • Middleware for handling data normalizations and conformations
  • Create indexes, constraints on columns
  • Column can be have images/video/audio/blobs attachments, stored appropriately in #cloudstore
• Authentication and Authorization on APIs
  • Add users and user groups
  • RWX based permission system for rows and tables
  • JWT token with configurable expiry time
  • User sign in/sign up/password reset flows
• JSON API and GraphQL API
  • JSONAPI.org complaint endpoints
  • GraphQL endpoint with Data/Query and Mutations available
  • Pagination and filtering using page number or cursor based
  • Fetch relationships in a single call
• Cloud storage
  • Connect to over 30 storage providers (localhost/HTTP/FTP/GDrive/Dropbox/S3 and many more)
  • Manage files using daptin actions
  • Automated 1 hour sync scheduled
• Static and HUGO sites
  • Host site on multiple domains
  • Inbuilt HTTPS certificate generation with lets-encrypt
  • Web file browser and FTP access (disabled by default)
• Action workflows & 3rd party API integration
  • Supports v2/v3 openapi in yaml or json format
  • Call any 3rd party API by importing OpenAPI Spec
• Email server
  • Enable SMTPS and IMAPS services and use daptin as your daily email provider
  • Multi hostname mail server
  • Multiple email accounts, database backed email storage

Features • Getting Started

Why use daptin

Easily consume the following features on any device

• Database backed persistence, 3NF normalized tables
• JSON API/GraphQL for CRUD apis
• User and group management and access control
• Social login with OAuth: tested with google, github, linkedin
• Actions for abstracting out business flows
• Extensive state tracking APIs
• Enable Data Auditing from a single toggle
• Synchronous Data Exchange with 3rd party APIs
• Multilingual tables support, supports Accept-Language header
• Market place API to manage and share schemas
• Cloud storage sync like gdrive, dropbox, b2, s3 and more
• Asset column to hold file and blob data, backed by storage
• Multiple websites under separate sub-domain/sub-paths
• Connect with external APIs by using extension points
• Data View Streams
• Flexible data import (auto create new tables and automated schema generation)
  • XLSX
  • JSON
  • CSV

Javascript/Typescript Client

https://github.com/daptin/daptin-js-client

Starter kit: https://github.com/daptin/vue_typescript_starter_kit

Define Schema

Find

Get By Id

Create

Delete

Delete relations

List relations

• Versioning of the data
• Authentication and authorization
• JSON API endpoint
• GraphQL endpoint
• Actions and integrations with external services

Get Started

• Native binary
• Heroku
• Docker image
• Kubernetes YAML

Features

• Declarative Data Modeling system
  • Unique/Primary keys
  • Single/Multiple Relation
  • Normalizations and conformations
  • Scripting using JS
• CRUD JSON APIs' for all tables
  • Create, Read, Update, Delete
  • Sort, filter, search, group by single/multiple columns
  • Authentication and Group based authorization
  • Pluggable middleware, conformations and normalizations
  • Trigger actions/pipelines
• GraphQL APIs
  • Read and Mutations APIs for all tables
  • One level of relationship fetching
• Client SDK libraries for all platforms
• Rich data types
  • Column types ranging from number to json to file/image assets
• Sub sites hosting
  • Expose multiple websites from a single instance
  • Connect multiple domains/sub-domains
• Pluggable Social Auth, Basic Auth or Username/Password Auth
• Cloud storage
  • Connect to external cloud storage services seamlessly
  • Pull data/Push data
• Action APIs
  • Define work-flows
  • Expose custom endpoints for other services
• Ready to use web dashboard
  • Responsive to desktop, mobile and table
• Cross platform
  • Windows, Mac, Linux and more

APIs

• CRUD APIs
  • Read, search, filter
  • Create
  • Update
  • Delete
  • Relations
  • Execute
• Action APIs
  • Using actions
  • Actions list
• User APIs
  • User registration/signup
  • User login/signin
• State tracking APIs
  • State machines

Users

• Guests
• Adding users
• Usergroups
• Data access permission
• Social login

Asset and file storage

• Cloud storage

Sub-sites

• Creating a subsite

Client library

API spec RAML

OpenAPI V3 spec is auto generated for each endpoint exposed. This can be use to generate further documentation and clients.

curl http://localhost/apispec.yaml

{
    "data": [
        {
            "type": "tableName",
            "attributes": {
                "col1": "",
                "col2": "",
            },
            "id": "",
        }
    ],
    "included": [
        {
            "type": "tableName",
            "attributes": {},
            "id": "",
        },
        .
        .
    ],
    "links": {
        "current_page": 1,
        "from": 0,
        "last_page": 100,
        "per_page": 50,
        "to": 50,
        "total": 5000
    }
}

Web Dashboard

Why Daptin?

Daptin was to help build faster, more capable APIs over your data that worked across for all types of frontend.

While Daptin primarily targeted Web apps, the emergence of Android and iOS Apps as a rapidly growing target for developers demanded a different approach for building the backend. With developers classic use of traditional frameworks and bundling techniques, we struggle to invest enough time in the business and frontend demands for all sorts of Apps that provide consistent and predictable APIs which perform equally well on fast and slow load, across a diversity of platforms and devices.

Additionally, framework fragmentation had created a APIs development interoperability nightmare, where backend built for one purpose needs a lot of boilerplate and integration with the rest of the system, in a consistent way.

A component system around JSON APIs offered a solution to both problems, allowing more time available to be invested into frontend and business building, and targeting a standards-based JSON/Entity models that all frontends can use.

However, JSON APIs for data manipulation by themselves weren't enough. Building apps required a lot of custom actions, workflows, data integrity, event subscription, integration with external services that were previously locked up inside of traditional web frameworks. Daptin was built to pull these features out of traditional frameworks and bring them to the fast emerging JSON API standard in an automated way.

Getting started

• Deploy instance of Daptin on a server
• Upload JSON/YAML/TOML/HCL file which describe your entities (or use marketplace to get started)
• or upload XLS file to create entities and upload data
• Become Admin of the instance (until then its a open for access, that's why you were able to create an account)

Tech Goals

• Zero config start (sqlite db for no-config install, mysql/postgres is recommended for serious use)
• A closely knit set of functionality which work together
• Completely configurable at runtime
• Stateless (Horizontally scalable)
• Piggyback on used/known standards
• Runnable on all types on devices
• Cross platform app using qt (very long term goal. A responsive website for now.)

Road Map

• [x] Normalised Db Design from JSON schema upload
• [x] Json Api, with CRUD and Relationships
• [x] OAuth Authentication, inbuilt jwt token generator (setups up secret itself)
• [x] Authorization based on a slightly modified linux FS permission model
• [x] Objects and action chains
• [x] State tracking using state machine
• [x] Data connectors -> Incoming/Outgoing data
• [x] Plugin system -> Grow the system according to your needs
• [x] Native support for different data types (geo location/time/colors/measurements)
• [x] Configurable intelligent Validation for data in the APIs
• [x] Pages/Sub-sites -> Create a sub-site for a target audience
• [x] Define events all around the system
• [x] Data conversion/exchange/transformations
• [x] Live editor for subsites - grapesjs
• [x] Store connectors for storing big files/subsites - rclone
• [x] Market place to allow plugins/extensions to be installed
• [x] Online entity designer
• [x] Excel to entity identification
• [x] CSV to entity identification

Documentation

• Checkout the documentation for daptin

Golang Dependencies list