How it works

/db takes an existing database model and automatically constructs a web service API from it. This makes your data instantly accessible to mobile applications, websites or enterprise systems.

/db works in two modes:

• Data Discovery – automatically reflects all objects in database as URL addressable resources
• SQL Pass-thru – configure any SQL statement and map it to a URL

In both modes data becomes addressable via simple URL.

Note that links on this page are for illustration only but we have a live demo elsewhere on this site.

To Try with Your Data…

GET /db Now →

Data Discovery Mode

In this mode all records automatically become HTTP resources, which can be read and udpated.

For example a Customer record could be referenced by:

slashdb.com/db/Sales/Customer/id/1.xml

Data becomes instantly available in several convenient data formats such as XML, JSON and comma-separated values text (CSV). The same record represented in JavaScript Object Notation (JSON) would be addressable as follows:

slashdb.com/db/Sales/Customer/id/1.json

/db effectively constructs a graph representation of all relational databases behind it. The system reflects the model’s relationships, so links between related records are natural to follow.

For example the customer’s orders can be referenced as:

slashdb.com/db/Sales/Customer/id/1/orders.json,

and also as:

slashdb.com/db/Sales/Order/customer/id/1.xml

Drill-downs to vector slices and individual scalar values are also supported without sacrificing clarity of the URL link. Customer’s name by itself in this example looks as follows:

slashdb.com/db/Sales/Order/customer/id/1/name.xml

In-lining related records within a document of a parent record is another powerful mechanism that simply works out of the box in data formats, which support record hierarchy (XML, JSON). In a single request you can get a Customer record with all his/her Order records.

SQL Pass-thru Mode

Once defined, queries can be executed using a URL:

slashdb.com/query/customers-by-city/params/city/London.html

As before the results are available in all supported formats simply by changing the extension of the URL:

• slashdb.com/query/customers-by-city/city/London.xml
• slashdb.com/query/customers-by-city/city/London.json
• slashdb.com/query/customers-by-city/city/London.csv

See Also

We invite you to explore our live demo on this website and to read about number of use cases, where /db offers unmatched benefits in software solution design.

Explore SolutionsSee a DemoDownload datasheet