tabularjson

Convert JSON Data into tabular format And convert from Tabular to Binary format

How to use

const {
    jsonObjectToBuffer,
    bufferToJsonObject
} = require('tabular-json-node')

const dataAsObject = { "Hello": { "World": [1,2,3,4] } }

// JS Object -> Buffer data
const dataAsBuffer = jsonObjectToBuffer(dataAsObject)

// Buffer data -> JS Object
const parsedObject = bufferToJsonObject(dataAsBuffer)

Supported Data type

| Type Name | | ------------ | | undefined | | null | | boolean | | number | | bigint | | string | | array | | object | | symbol | | function | | uint8array |

Object to Tabular

To convert JS Object to Object table

const {
    jsonObjectToTable
} = require('tabular-json-node')

const dataAsObject = { "Hello": { "World": [1,2,3,4] } }

// jsonObjectToTable function to convert JS Object to ObjectTable
const objectTable = jsonObjectToTable(dataAsObject)

Tabular to Binary

To convert Object table to Binary format

const {
    jsonObjectToTable,
    tableToBuffer
} = require('tabular-json-node')

const dataAsObject = { "Hello": { "World": [1,2,3,4] } }

const objectTable = jsonObjectToTable(dataAsObject)

// jsonObjectToTable function to convert ObjectTable to Binary format
const binaryObject = tableToBuffer(objectTable)

Now we reverse

Binary to Table

To convert Binary data to JS Table

/**
 * Binary representation for Object `{ hello: 'World' }`
 */
const binaryObject = new Buffer("020000000000000001000000070000000000000001000000020000000500050068656c6c6f05000000576f726c64", "hex")

const {
    bufferToTable
} = require('tabular-json-node')

// bufferToTable to convert Binary data/Buffer to JS Object
const objectTable = bufferToTable(binaryObject)

Tabular to Object

To convert Object table to JS Object

const binaryObject = new Buffer("020000000000000001000000070000000000000001000000020000000500050068656c6c6f05000000576f726c64", "hex")

const {
    bufferToTable,
    tableToJsonObject
} = require('tabular-json-node')

const objectTable = bufferToTable(binaryObject)

const parsedObject = tableToJsonObject(objectTable)

Binary Format

| Data | Data Type | Size (Bytes) | | ------------------------- | --------- | ------------ | | NumberOfRows | UInt32LE | 4 | | Row 1 Buffer | Buffer | Variable | | Row 2 Buffer | Buffer | Variable | | Row 3 Buffer | Buffer | Variable | | so on... for NumberOfRows |

Buffer data Format for Row

| Data | Data Type | Size (Bytes) | | -------------- | --------- | ------------ | | parentId | UInt32LE | 4 | | rowId | UInt32LE | 4 | | typeId | UInt16LE | 2 | | keyLength | UInt16LE | 2 | | keyLength | UInt16LE | 2 | | keyStringValue | Buffer | KeyLength | | dataLength | UInt32LE | 4 | | data | Buffer | dataLength |