What is Database Management in HeyBoss?
HeyBoss projects include built-in database functionality, allowing you to create and manage tables to store structured data for your applications.
This feature is perfect for storing user submissions, product catalogs, customer information, or any structured data your project needs.
How to Access Database Management
Open your project in the HeyBoss editor
Navigate to the project settings or database section
Click "Tables" or "Database" to view your tables
Creating Tables
Step 1: Create a New Table
Click "Create Table" and define your table structure:
Table Name: Choose a descriptive name (e.g., "customers", "products", "orders")
Columns: Define the fields your table needs
Data Types: Text, number, date, boolean, etc.
Step 2: Configure Columns
For each column, you can set:
Column name
Data type
Required/optional
Default values
Managing Data (CRUD Operations)
Create (Add Records)
Add new records to your tables:
Click "Add Record" or "New Row"
Fill in the field values
Save to add the record
Read (View Records)
View and search your data:
Browse all records in a table
Search and filter records
Sort by different columns
Update (Edit Records)
Modify existing records:
Click on a record to edit
Update field values
Save changes
Delete (Remove Records)
Remove records you no longer need:
Select the record to delete
Confirm deletion
Warning: This action cannot be undone
Import and Export Data
Import Data
Bulk import data from CSV files:
Prepare your CSV file with matching column names
Click "Import" in the table view
Upload your CSV file
Map columns if needed
Confirm import
Export Data
Export your data to CSV:
Select the table to export
Click "Export to CSV"
Download the file
Common Use Cases
Customer Database
Store customer information for your business:
Name, email, phone
Purchase history
Preferences and notes
Product Catalog
Manage your product inventory:
Product name and description
Price and SKU
Stock quantities
Images and categories
Form Submissions
Collect and store form data:
Contact form submissions
Survey responses
Registration information
Booking/Reservation System
Track appointments or reservations:
Customer details
Date and time
Service type
Status (confirmed, pending, cancelled)
Connecting Tables to Your Website
Once you've created tables, you can connect them to your website:
Display Data: Show table data on your pages
Forms: Save form submissions to tables
Dynamic Content: Update website content from table data
User Actions: Allow users to view, add, or edit records
Best Practices
Plan Your Data Structure
Think about what data you need to store before creating tables. Good planning saves time later.
Use Descriptive Names
Give tables and columns clear, descriptive names that explain what they contain.
Regular Backups
Export your data regularly as a backup, especially before making major changes.
Data Validation
Set required fields and data types to ensure data quality.
Limits and Storage
Database storage limits depend on your plan:
Free Plan: Limited storage
Paid Plans: Increased storage capacity
Contact support for enterprise storage needs
Need Help?
If you have questions about database management, contact HeyBoss Support.
Need help? Contact Support