Bunny Database Management in VS Code

Overview

Bunny Database is Bunny.net’s cloud-hosted edge database service built on libSQL (the open-source fork of SQLite). Key characteristics include:

• Edge-optimized: Runs on Bunny.net’s global CDN infrastructure for low-latency access worldwide
• SQLite compatible: Full SQLite SQL dialect support with familiar query syntax
• Simple connectivity: URL-based connections with token authentication
• Managed infrastructure: No database servers to provision or maintain
• libSQL foundation: Benefits from libSQL enhancements over standard SQLite

Bunny Database is ideal for edge applications, content-driven websites, and projects that need a lightweight, globally distributed relational database.

Connecting

To connect to Bunny Database in DBCode:

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 Bunny Database as the database type and enter:
   • Database URL (e.g., libsql://your-database-id.lite.bunnydb.net)
   • Auth Token from your Bunny.net dashboard
4. Connect: Click save to connect to your Bunny Database.
5. Start Managing Your Data: Browse tables, run queries, and manage your schema.

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

Bunny Database Features in DBCode

DBCode enhances your Bunny Database experience with:

• Schema browsing: Navigate tables, views, indexes, and triggers
• SQL query editor: Write and execute SQLite-compatible queries with syntax highlighting
• Data editing: Insert, update, and delete rows directly in the data grid
• DDL management: Create and alter tables, views, and indexes
• Data export: Export query results in multiple formats

By using Bunny Database with DBCode, you can efficiently develop and manage your edge database directly within Visual Studio Code.

For more information about Bunny Database, visit bunny.net.