Database Application Programming Interface (DBAPI)

DBAPI Project in Wolfram Language

Overview

Packages in this project extend Wolfram Language with commands that are related to data management and especially generic database management. There is a basic Utilities Package that is used in transformations between Wolfram Language constructs such as List, Rule, Association, and Dataset, and external serialization standards such as JSON and comma-separated values (CSV) files. On top of that package we are porting RESTful APIs from various web services through URLFetch into Wolfram Language building commands with arguments that specify options with rules of the form name->value. An example of such a RESTful API is the OrientDB HTTP API and the OrientDB package.

Features

  • Enhanced OrientDB HTTP RESTful API functionality with powerful new commands for Mathematica users
  • Fully documented functions and packages in the native documentation system of Wolfram Mathematica
  • Build interactive demos, powerful presentations and applications in the vast environment of Wolfram Language with nearly 5,000 built-in functions at a fraction of time it would require to build, test, and support these, in other programming languages.
  • Debug easily your applications by dynamic programming and interactive sessions
  • Deploy your application anywhere thanks to Wolfram Universal Deployment System
  • Create multiple visualization schemes, network topologies, data mining and search indexing algorithms powered by dynamically configured GUIs for the non-experienced user.

Installation

Testing

Documentation Pages

If you have already installed the DBAPI project, then you can search Wolfram Mathematica documentation for DBAPI. This is your starting point for browsing the documentation.

For demonstration purposes, we have included here the following documentation pages in pdf format for the ODBapi and ODBgetFieldAttributes functions of the OrientDB Package

DBAPI Posts

2016

From Declarative to Functional Database Operations
SQL CRUD RESTful Transformations in Mathematica and OrientDB
A new alternative, functional way to program databases

2015

OrientDB Mathematica Package
OrientDB RESTful HTTP-JSON API in Mathematica
Extends Wolfram Language (Mathematica) by porting OrientDB RESTful API

2014

AtomicDB Mathematica AddOn (ADBM)
Demo and Professional Versions in Wolfram Programming Language
The first add-on for AtomicDB that makes it fully compatible to work with Wolfram Language:

Modified: