Overview

InfluxDB is a purpose-built time-series database designed for handling high volumes of timestamped data. Key characteristics include:

  • Time-series optimized: Purpose-built storage engine for time-stamped data with automatic data lifecycle management
  • SQL support: Query data using familiar SQL syntax (InfluxDB 3.0)
  • High performance: Optimized for high-write throughput and fast queries over time ranges
  • Data retention policies: Automatic data expiration and downsampling
  • Built-in visualization: Native support for time-series visualization and dashboards
  • Cloud and self-hosted: Available as managed cloud service or self-hosted deployment

InfluxDB is ideal for IoT sensor data, application metrics, real-time analytics, DevOps monitoring, and any use case involving time-stamped measurements.

Connecting

To connect to InfluxDB in DBCode, you’ll need:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Complete connection form: Select InfluxDB as the database type and enter:
    • Host/Server address
    • Port (default: 8181 for InfluxDB 3.0)
    • API Token for authentication
    • Database name
    • Enable SSL/TLS if required
  4. Connect: Click save to connect to your InfluxDB instance.
  5. Start Managing Your Data: Browse measurements and run SQL queries.

For detailed instructions on connecting to databases, refer to the Connect article.

InfluxDB Features in DBCode

DBCode enhances your InfluxDB development experience with:

  • SQL query editor: Write and execute SQL queries with syntax highlighting
  • Measurement browsing: Navigate through databases and measurements
  • Column type information: View field types and tag keys
  • Query results visualization: View and export query results
  • Time-series data display: Optimized display for time-stamped data

By using InfluxDB with DBCode, you can efficiently explore your time-series data, develop queries, and analyze metrics directly within Visual Studio Code.

For more information about InfluxDB, check out InfluxDB.