Overview

QuestDB is a high-performance time-series database designed for fast data ingestion and real-time analytics with key characteristics:

  • High-speed ingestion: Handles millions of rows per second with minimal hardware
  • SQL support: Query time-series data using standard SQL with time-series extensions
  • Column-oriented storage: Optimized for analytical queries on time-series data
  • PostgreSQL wire protocol: Compatible with PostgreSQL clients and tools
  • Built-in web console: Includes a web-based SQL editor and data visualization

QuestDB is ideal for financial market data, IoT sensor data, application metrics, monitoring systems, and any time-series workloads requiring high throughput.

Connecting

To connect to QuestDB 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 QuestDB as the database type and enter:
    • Host/Server address
    • Port (8812 for PostgreSQL wire protocol)
    • Username (default: admin)
    • Password (default: quest)
    • Database name (optional, default is ‘qdb’)
  4. Connect: Click save to connect to your QuestDB server.
  5. Start Managing Your Data: Explore tables and run queries.

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

QuestDB Features in DBCode

DBCode enhances your QuestDB development experience with:

  • SQL query editor: Write and execute QuestDB SQL queries with syntax highlighting
  • Time-series functions: Use QuestDB’s time-series specific functions like SAMPLE BY
  • Schema browsing: Navigate through tables and columns
  • Query results visualization: View and export query results

By using QuestDB with DBCode, you can efficiently develop and test time-series queries and data transformations directly within Visual Studio Code.

For more information about QuestDB, check out QuestDB.