| 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. |
