DBmanager - Database Management for Lara Dashboard

A powerful and user-friendly database management module for Lara Dashboard. Manage, monitor, and maintain MySQL, MariaDB, and SQLite databases directly from your admin panel with comprehensive tools and a modern interface.

Version: 1.0.0

⚠️ Key Features

This module provides full database management capabilities without requiring external tools like phpMyAdmin.

Supported Databases:

• ✅ MySQL (5.7+)
• ✅ MariaDB (10.0+)
• ✅ SQLite (3.0+)

Features

• Database Overview - Quick statistics and database size monitoring
• Table Management - Create, view, edit, and delete tables
• Data Management - Insert, update, delete, and bulk edit rows
• Structure Management - Add, modify, and drop columns with full control
• Index Management - Create and manage database indexes
• Foreign Keys - Manage foreign key relationships
• Data Import/Export - CSV import and export functionality
• SQL Query Editor - Execute custom SQL queries with syntax highlighting
• Database Backup - Create and download database backups (MySQL, SQLite)
• Database Restore - Restore databases from backup files
• Search Functionality - Search across tables and data
• Settings & Security - Secure authentication and access control
• Dark Mode Support - Full Bootstrap 5 dark mode compatibility
• Responsive Design - Works perfectly on desktop, tablet, and mobile

Core Modules

Database Overview

Quick access to database statistics and common operations.

Overview Features:

• Database size and row count
• Table count statistics
• Quick action buttons
• Database type indicator
• Recent activity log

Tables Management

Comprehensive table management interface.

Table Operations:

• View all tables with row counts
• Create new tables
• Edit table structure
• Delete tables (with confirmation)
• View table data
• Export table data to CSV
• Import data from CSV
• Truncate tables

Table Structure

Manage table columns and indexes.

Structure Features:

• View column details (name, type, constraints)
• Add new columns
• Modify existing columns
• Drop columns with safety checks
• Create and manage indexes
• Add and manage foreign key relationships
• View table relationships

Data Management

Insert, update, and delete database records.

Data Operations:

• View table data with pagination
• Create new records
• Edit existing records inline
• Delete individual records
• Bulk edit multiple records
• Bulk delete records
• Search and filter data
• Sort columns
• Show/hide columns

SQL Query Editor

Execute custom SQL queries directly.

Query Features:

• Syntax-highlighted SQL editor
• Execute SELECT, INSERT, UPDATE, DELETE queries
• Query history
• Query results display
• Error reporting
• Database-specific query support

Import/Export

Data import and export functionality.

Import/Export Features:

• Export tables to CSV format
• Import CSV files
• Column mapping
• Data validation
• Import preview
• Error handling

Backup & Restore

Database backup and restoration.

Backup Features:

• Create full database backups
• Backup includes all tables and data
• Download backup files
• Restore from backup files
• Automatic backup naming with timestamps
• Large database support (via CLI)
• Compression support for MySQL backups

Settings

Configure DBmanager module parameters.

Settings Options:

• Authentication credentials
• Database connection settings
• Session management
• Display preferences

Dashboard Statistics

• Database Type - Currently connected database
• Database Size - Total size of all data
• Total Tables - Number of tables in database
• Total Rows - Count of all records
• Last Updated - Last database activity time

Security Features

• Secure Authentication - Session-based authentication for database operations
• Access Control - Integrated with Lara Dashboard admin auth
• CSRF Protection - Protection against cross-site request forgery
• Session Management - Configurable session timeout
• Safe Operations - Confirmation dialogs for destructive operations
• Audit Logging - Operation logging for security tracking

User Interface

Modern, responsive admin interface with:

• Sidebar Navigation - Quick access to all modules
• Table Cards - Visual table overview with row counts
• Data Tables - Professional data grid with sorting and pagination
• Modal Dialogs - Inline editing and operations
• Form Validation - Client and server-side validation
• Loading States - Visual feedback during operations
• Error Messages - Clear, actionable error reporting
• Dark Mode - Full Bootstrap 5 dark mode support
• Mobile Responsive - Works seamlessly on all devices

Requirements

• Lara Dashboard v2.0+
• PHP 8.2+
• Laravel 13+
• MySQL 5.7+ OR MariaDB 10.0+ OR SQLite 3.0+
• Database connection configured in Laravel
• Shell access for backup operations (optional but recommended)

Database Support

MySQL/MariaDB

• Full CRUD operations
• Full backup support via mysqldump
• Large database support (handles 500MB+ databases)
• Multiple connection support

SQLite

• Full CRUD operations
• Simple file-based backups
• Optimal for embedded databases
• Perfect for testing and small projects

Performance

• Optimized for Large Databases - Efficiently handles 100+ tables and millions of rows
• Pagination - Smart pagination prevents memory overload
• Lazy Loading - Tables load on-demand
• Memory Management - Unlimited PHP memory for backup operations
• Query Optimization - Efficient queries for all operations

Backup Strategy

DBmanager supports two backup approaches:

1. CLI Backup (Recommended for large databases)

   • Creates full SQL dumps via CLI
   • Unlimited memory usage
   • Supports databases of any size
   • Automatic file naming with timestamps

2. Inline Backup

   • Backup through web interface
   • Suitable for smaller databases
   • Respects PHP memory limits

Configuration

Configure DBmanager through the Settings tab:

• Username/Password - Authentication credentials for database operations
• Session Key - Session storage key for authentication
• Database Prefix - URL prefix for database operations
• Admin Prefix - Admin panel URL prefix

Usage Tips

• Always backup before major operations
• Use the SQL editor for complex queries
• Export data regularly for disaster recovery
• Review logs for audit trail
• Test destructive operations on development first
• Use foreign keys to maintain data integrity

Troubleshooting

Backup fails

• Check PHP memory_limit setting
• Ensure storage/backups directory is writable
• Use CLI backup for large databases

Upload size limits

• Check PHP upload_max_filesize
• Check PHP post_max_size
• Use CSV import for large datasets

Slow operations

• Add indexes to frequently queried columns
• Archive old data to separate tables
• Check database server load

Support

• Documentation: Lara Dashboard Docs
• Issues: GitHub Issues
• Discussions: GitHub Discussions

License

This module is part of Lara Dashboard and is licensed under the MIT License.