Database Dashboard Overview

Introduction to the CodeNull Database Dashboard and its capabilities

Database Dashboard Overview

The Database Dashboard in CodeNull provides a comprehensive set of tools to create, manage, and optimize your application’s database without writing complex queries or database code. This intuitive interface allows you to visually design database schemas, import and manage data, and configure database relationships.

What You Can Do

Create Databases

Set up MongoDB, SQL, or custom databases with just a few clicks

Add Data

Import, create, and manage your database records efficiently

Design Schemas

Visually design your data models and their relationships

Migrate Data

Import from external sources and migrate between environments

Dashboard Interface

The Database Dashboard interface is organized into several key areas:

Main Navigation Panel

The left sidebar provides access to your database resources:

• Database List: All your connected databases
• Collections/Tables: Lists of your data collections
• Saved Queries: Frequently used database queries

Workspace Area

The central area changes based on your current task:

• Schema Designer: Visual schema creation interface
• Data Explorer: Browse and edit your data records
• Query Builder: Create and run database queries
• Import/Export Tools: Data migration utilities

Properties Panel

The right sidebar displays properties for the selected item:

• Field Settings: Data type, validation rules, default values
• Relationship Properties: Defines how tables or collections relate
• Index Configuration: Performance optimization options
• Query Parameters: Settings for saved queries

Supported Database Types

CodeNull supports multiple database types to meet your application needs:

MongoDB

Document-based NoSQL database ideal for flexible data structures and rapid development.

Key features:

• Schema-less data storage
• JSON-like document structure
• Horizontal scaling
• Geo-spatial support

Document-based NoSQL database ideal for flexible data structures and rapid development.

Key features:

• Schema-less data storage
• JSON-like document structure
• Horizontal scaling
• Geo-spatial support

Advanced open-source relational database with robust features for complex data.

Key features:

• ACID compliance
• Complex queries
• Multi-version concurrency control
• Advanced data types

Popular relational database system known for reliability and ease of use.

Key features:

• Solid data integrity
• Transaction support
• Comprehensive SQL support
• Widespread community support

Import existing spreadsheet data into your application database.

Key features:

• Direct import from spreadsheets
• Automatic schema detection
• Data type conversion
• Bulk record creation

Database Dashboard Workflow

The typical workflow for using the Database Dashboard includes:

1. Create a Database

   Set up your database and configure connection settings.

2. Design Your Schema

   Define your data models, fields, and relationships.

3. Add Initial Data

   Import or manually add records to your database.

4. Configure Optimization

   Set up indexes and query optimization for performance.

5. Connect to Frontend

   Link your database collections to frontend components.

Next Steps

Creating Your First Database

Learn how to set up and configure a new database

Adding Data

Import or create records in your database

Designing Database Schemas

Visually design your data models and relationships

Migrating Existing Data

Import from external sources and migrate between environments