...
To get a holistic view of collections, we categorize them into these sections:
Collection types: Collection types and how to work with them on the ClearBlade Platform
Collection management: Provides various collection management options
Click here for the Collection management Collections tutorial.
Purpose
ClearBlade collections provide a single interface for interacting with numerous database types.
...
The following is required to configure a connection:
Field | Description | Example |
|---|---|---|
Database Type | DB application type | MySQL |
IP Address | Database URL | |
Port | Port number on which the application is running | 5432 |
Database Name | Database name | dbname |
Connection Name | String | example |
Table Name | String | sensor_data |
Username | String | admin |
Password | String | zrHcnzpBenHSOIq0uK/og8R |
Column types
Type | Description |
|---|---|
string | Series of characters. Example: Column 1 |
integer (int) | Positive or negative whole number |
boolean (bool) | True/false |
timestamp | 03/29/21 22:15:07 |
float | Numbers with decimals |
bigint | Large whole numbers |
double | Large numbers with decimals |
jsonb | See below |
binary large object (blob) | A binary data collection stored as a single entity |
universally unique identifier (uuid) | A 128-bit unique identification value. Example: bc37d0c0-fcf2-11d9-8cd6-0800200c9a66 |
jsonb
jsonb enables users to store JSON values in the database tables and query based on keys (for objects) or indexes (for arrays). Send stringified data when creating and updating all tables on a jsonb column.
...
You can create a timestamp variable using : var curr_timestamp = new Date(); and insert it into the collection.