Concepts

FairCom DB concepts

This section describes how to use FairCom DB as a document database and describes how JSON and tabular data map to each other.

Use FairCom DB

This section details how the JSON DB API makes it easy to navigate data.

Use table filters

A table filter has a similar purpose to the SQL WHERE clause. It is an expression that uses syntax common to all C family programming languages, including C, C++, C#, Java, JavaScript, Go, Rust, and so forth.

Selectively return fields

Most query actions allow you to specify which fields to include or exclude from each record that is returned in the results. To do this, you use either the "includeFields" or the "excludeFields" properties.

Selectively return JSON properties

Most query actions allow you to specify which JSON properties to include or exclude from each record that is returned in the results. To do this, you use either the "includePaths" or the "excludePaths" properties.

Return results immediately

Immediately returning results works best when the resultset is small. When a resultset is large, it is best to paginate over the results by returning a different subset of records each time you call an action.

Use cursors

When you plan on retrieving a large recordset of data, a cursor is the most efficient approach. This is because a cursor allows you to call an action once to generate the recordset

Sort results

This section describes the different ways to sort results.

Get data concepts

This section describes the concepts of the Get data actions.