Database

Overview

QOC Cloud Console provides a managed database interface where you can browse tables, view data, and perform queries directly from your browser. No need for external database tools.

Accessing the Database

Navigate to APIs & Services in the sidebar, then select the Database tab to access your project's database.

Database Information

At the top of the database page, you'll see:

• Database Name: Your project's database identifier
• Database Type: PostgreSQL, MySQL, or other supported database
• Region: Data center location
• Connection Status: Online or offline indicator
• Storage Used: Current database size
• Last Backup: Timestamp of most recent backup

Tables Overview

Table List

The database interface displays all your tables in a sidebar:

• Table Name: Click to view table contents
• Row Count: Number of records in the table
• Size: Storage used by the table
• Last Modified: Most recent data change

Search and Filter

Quickly find tables using the search box:

• Search by table name
• Filter by size or row count
• Sort alphabetically or by modification date

Viewing Table Data

Click on any table to view its contents:

Data Grid

The data grid displays your table rows in a spreadsheet-like interface:

• Columns: Table fields displayed as column headers
• Rows: Records displayed with all field values
• Pagination: Navigate through large datasets
• Sorting: Click column headers to sort
• Search: Filter rows by column values

Column Information

Hover over column headers to see:

• Data Type: String, Number, Boolean, Date, etc.
• Nullable: Whether the field accepts null values
• Primary Key: Indicates primary key fields
• Foreign Key: Shows relationships to other tables

Data Display

Different data types are displayed appropriately:

• Text: Plain text display
• Numbers: Right-aligned with proper formatting
• Dates: Formatted according to your locale
• Booleans: Checkmark or cross icon
• JSON: Expandable tree view
• Long Text: Truncated with "Show more" option

Querying Data

Query Builder

Build SQL queries visually without writing code:

1. Select the table
2. Choose columns to display
3. Add filter conditions
4. Set sorting order
5. Click Run Query

Custom SQL

For advanced users, write custom SQL queries:

SELECT * FROM users 
WHERE created_at > '2024-01-01' 
ORDER BY email 
LIMIT 100;

Features:

• Syntax highlighting
• Auto-completion for table and column names
• Query history
• Save frequently used queries

Query Results

Query results are displayed in the same data grid format:

• Export Results: Download as CSV, JSON, or Excel
• Rows Affected: Count of returned rows
• Execution Time: Query performance metric
• Copy Data: Copy selected rows to clipboard

Table Schema

View detailed schema information for any table:

Columns Tab

See all column definitions:

• Name: Column identifier
• Type: Data type with length/precision
• Nullable: Whether NULL values are allowed
• Default: Default value if any
• Auto Increment: For automatic ID generation

Indexes Tab

View table indexes for query optimization:

• Index Name: Identifier
• Columns: Fields included in the index
• Type: Primary, Unique, or Regular
• Size: Storage used by the index

Relationships Tab

See foreign key relationships:

• Relationship Name: Identifier
• From Column: Local column
• To Table: Referenced table
• To Column: Referenced column
• On Delete/Update: Cascade rules

Statistics Tab

Table performance metrics:

• Total Rows: Current record count
• Table Size: Storage consumption
• Index Size: Index storage
• Last Analyze: Last statistics update
• Estimated Rows: Approximate count for large tables

Data Visualization

Charts

Create visual representations of your data:

Exporting Data

Export table data in multiple formats:

Export Options

1. CSV: Comma-separated values for Excel/spreadsheets
2. JSON: JavaScript Object Notation for applications
3. SQL: INSERT statements for backup or migration
4. Excel: XLSX format with formatting

Export Settings

• All Rows: Export entire table
• Current Page: Export visible rows only
• Selected Rows: Export marked rows
• Query Results: Export filtered data

Database Limits

Different plans have different database capabilities:

Free Tier

• 1 GB storage
• 10,000 rows per table
• 100 queries per minute
• Daily backups (7-day retention)

Pro Tier

• 10 GB storage
• Unlimited rows per table
• 1,000 queries per minute
• Hourly backups (30-day retention)

Enterprise Tier

• Custom storage
• Unlimited rows and queries
• Real-time replication
• Custom backup schedule

Performance Tips

Query Optimization

• Use indexes on frequently queried columns
• Add WHERE clauses to filter results
• Limit result sets with LIMIT clause
• Avoid SELECT * when possible

Data Management

• Archive old data to free up space
• Delete unused tables
• Normalize data to reduce redundancy
• Use appropriate data types

Security

Your database is secured with:

• Encryption at Rest: All data encrypted on disk
• Encryption in Transit: TLS 1.3 for all connections
• Access Control: Role-based permissions
• Audit Logging: All access attempts logged
• Network Isolation: Private network within your project

Troubleshooting

Slow Queries

If queries are slow:

1. Check if indexes exist on filtered columns
2. Review query execution plan
3. Reduce result set size with better filters
4. Consider caching frequently accessed data

Connection Issues

If you can't access the database:

1. Check project status in dashboard
2. Verify your subscription is active
3. Ensure no maintenance is in progress
4. Contact support if issues persist