QuestDB Database Management in VS Code

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.