Skip to main content

Boolean types

Section

Description

BIT

BIT is a FairCom database field type containing a Boolean value of 0 or 1.

BIT

BIT is a FairCom database field type containing a Boolean value of 0 or 1. It is stored in a record as an 8-bit integer.

BIT's behavior in different APIs:

  • In FairCom's JSON DB API, a BIT value is represented as a JSON Boolean with a value of false or true.

    A field value of 0 maps to false. A field value of 1 maps to true.

  • In FairCom's SQL API, a BIT value is submitted and returned as a 0 or 1 ASCII characters.

  • In FairCom's ISAM and CTDB APIs, a BIT value is submitted and returned as an unsigned byte with a value of 0 or 1.

A record contains data about one thing. A record describes the attributes of a thing using one or more fields. Zero or more records exist in a table; thus, a table contains data about zero or more things.

Different systems represent records differently. A JSON database represents each record as a JSON document. SQL represents each record as a row containing one or more columns of data. ISAM represents each record as a binary buffer of raw bytes.

FairCom products are unique because the FairCom database engine simultaneously supports these different record formats. The same record can be updated and queried simultaneously as JSON, a SQL row, or a binary buffer using the JSON DB API.

The JSON DB API uses JSON over HTTP to manage databases, tables, indexes, records, queries, cursors, and transactions. It is available in all FairCom products.

This API is part of FairCom's family of JSON APIs.

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

FairCom's SQL engine is ANSI compliant and has almost all SQL features up through the SQL:2003 standard.

Indexed Sequential Access Method (ISAM) is FairCom's primary ACE API. ISAM uses the Record Buffer Method, which gives the application full control over the contents of the entire record buffer to store structured or unstructured data.

FairCom's ISAM API provides full control over record processing. This allows developers to implement data processing algorithms that are tailored to precise application needs, and this allows an application to achieve unrivaled performance. FairCom's ISAM API works best in the C and C++ languages.

FairCom ACE APIs include ISAM, CTDB, and Low-level ACE API.

The c-tree Database API (CTDB API) is FairCom's database API in the ACE family of APIs. It provides high performance with less code than the FairCom's ISAM API. The CTDB API introduces database concepts that are compatible with SQL. It requires records to contain predefined field structures. FairCom's CTDB API provides full control over record processing. This allows developers to implement data processing algorithms that are tailored to precise application needs, and this allows an application to achieve unrivaled performance. FairCom's CTDB API works well in a variety of languages, such as C, C++, Java, C#, and Visual Basic.

FairCom ACE APIs include ISAM, CTDB, and Low-level ACE API.