Timescale Database Management in VS Code

Overview

TimescaleDB is a scalable time-series database designed to handle high-resolution metrics and time-series data based on PostgreSQL. It is designed to be highly available, scalable, and performant, making it an ideal choice for storing and analyzing large volumes of time-series data.

Connecting

To connect to TimescaleDB, follow these general steps:

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 new connection form: Choose TimescaleDB as the type, and enter the required information.
4. Connect: Click save to connect to your TimescaleDB database.
5. Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.

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

Kerberos / GSSAPI Authentication

DBCode exposes Integrated (Kerberos) for TimescaleDB connections when the server is configured to accept PostgreSQL GSSAPI or SSPI authentication.

• Select Integrated (Kerberos) and enter the TimescaleDB username that the Kerberos identity maps to.
• On Windows, DBCode uses the current signed-in identity. On macOS and Linux, it uses an existing Kerberos ticket cache.
• Integrated authentication requires a host/TCP connection. DBCode does not accept or manage keytabs.
• The default Kerberos Service Name is postgres. Change it only when the server administrator registered another service name.

By using TimescaleDB with DBCode, you can connect to your TimescaleDB databases, query and manage your data, and visualize your results, all directly from Visual Studio Code.

For more information about TimescaleDB, check out TimescaleDB.