Time Series Storage

Qubitro Time Series Storage enables scalable, real-time device data storage with customizable retention, API access, and seamless dashboard integration.

Overview

Every device on Qubitro has built-in Time Series Storage, which is automatically created when the device is created.

This fully managed, highly available, and horizontally scalable storage engine eliminates database operations (DBOps) and the need for third-party databases.

Core Features

• Automatic Storage Creation – No setup required; storage is created per device.

• Dynamic Data Storage – Supports any valid JSON data structure.

• Per-Device Retention Period – Customizable based on plan and project settings.

• Scalability – Handles high-ingestion workloads with horizontal scaling.

• Storage Views – Enables writing data to multiple views for advanced structuring.

• Multi-Access Support – Available via APIs, dashboards, and UI-based views.

Data Accessibility

Time Series Storage data is available through:

Device Detail Page → Storage Tab (Table view)

Qubitro Time Series Storage View

APIs (For programmatic access)

Retrieve Device DataAllows to retrieve data from a device.

Example response:

{
  "success": true,
  "action": "get device data",
  "status": 200,
  "message": "Device data fetched successfully.",
  "data": [
    {
      "acoustic_level": 45.425554079986945,
      "anomaly_detected": false,
      "equipment_health": "Good",
      "flow_rate": 159.9091980083704,
      "humidity": 80.84150406882252,
      "maintenance_needed": false,
      "pressure": 926.2272770144835,
      "temperature": 22.9795338621098,
      "time": "2025-03-02T20:30:21.202946Z",
      "timestamp": "2025-03-02T20:30:05Z",
      "vibration": 8.039540775151707
    },
    {
      "acoustic_level": 97.35889180403677,
      "anomaly_detected": false,
      "equipment_health": "Good",
      "flow_rate": 168.36617819046316,
      "humidity": 66.9764711069997,
      "maintenance_needed": false,
      "pressure": 1091.38434821347,
      "temperature": 37.229863557166354,
      "time": "2025-03-02T20:30:06.637564Z",
      "timestamp": "2025-03-02T20:30:06Z",
      "vibration": 1.0982245649319902
    }
  ]
}

Dashboard Widgets (For visualization)

Retention Period

Retention periods vary based on plan type and organization settings:

Plan Type	Default Retention Period
Starter Plan (Personal)	7 days
Scale Plan (Personal)	14 days
Enterprise Plan (Organizations)	Configurable per project

For Enterprise accounts, retention can be set per project, per device.

Example:

• Project A → 3 months data retention per device.

• Project B → 6 months data retention per device.

The default retention period for organizations is defined in the agreement.

Data Size Limits

The data size limit applies per device, meaning each device has its own maximum limit for individual data points.

Plan Type	Max Data Point Size
Starter Plan (Personal)	1 KB
Scale Plan (Personal)	10 KB
Enterprise Plan (Organizations)	Custom (Up to 10 MB per data point)

Deleting Device Data

Qubitro provides multiple options for deleting device data, allowing you to remove data in bulk or delete specific data points as needed.

This section covers per-device data deletion. To delete data for all devices, you can:

• Use the Qubitro API to fetch all devices and delete their data.
• Delete the entire project, which will remove all associated devices and data.

Data deletion is permanent and cannot be undone. Once deleted, the data cannot be recovered.

Bulk Deletion

• You can delete all stored data for a device from the Storage tab.

• Click the options menu (...) and select Delete all device data.

This action removes all historical data points from Time Series Storage and cannot be undone.

Deleting Individual Data Points

This method is useful when only selective data needs to be removed without affecting the rest of the dataset.

• To delete a specific data point, expand the table view by clicking the + icon next to a data entry.

• Click the red cross (❌) next to the data point to remove it.

Deleting Data via API

This method is ideal for automated cleanup tasks or bulk deletions managed through scripts.

• Refer to the API documentation for supported endpoints and usage details.