Laravel Voyager Database – Database manager for Voyager

Laravel Voyager provides a robust database management interface that allows you to easily create, manage, and interact with your application’s database tables directly from the admin panel.

Accessing the Database Manager

1. Log in to Voyager: First, ensure you’re logged into the Voyager admin panel at http://your-app-url/admin.
2. Navigate to Database: From the sidebar, click on Tools, then select Database. This will bring you to the database management interface.

Key Features of the Database Manager

1. View Tables: You can see a list of all the tables in your database. Clicking on a table will show you its structure and allow you to manage it.
2. Create New Tables:
   • Click the Add Table button.
   • Fill out the form to define the table name and other settings.
   • After creating the table, you can define its columns.
3. Manage Columns:
   • For any table, you can view, edit, or delete columns.
   • To add a new column, click the Add Column button, and specify the column name, type, and other attributes (like nullable, unique, default values).
4. BREAD Management:
   • Once you have a table, you can set up BREAD (Browse, Read, Edit, Add, Delete) for that table.
   • Click on BREAD next to the table name to start configuring it. You can customize which fields are visible in each action and set validation rules.

Configuring BREAD

When you set up BREAD, you’ll have several options:

• Display Name: Set a user-friendly name for the resource.
• Columns: Choose which columns to display in the list view and detail view.
• Validation: Define validation rules for each field to ensure data integrity.
• Relationships: Set up relationships with other tables (e.g., one-to-many, many-to-many).

Advanced Features

1. Relationships: Voyager supports defining relationships between tables. You can set foreign keys in the column configuration and link them to related tables.
2. Indexes: You can create indexes on columns to improve query performance. This is especially useful for columns that will be searched frequently.
3. Database Backup: Voyager has built-in options for database backups. You can manage your database backups through the Tools > Backup section.
4. Migrations: While Voyager allows you to manage tables directly, it’s a good practice to use migrations for version control. You can create migrations using:

   bash

   php artisan make:migration create_table_name --create=table_name

   1	php artisan make:migration create_table_name --create=table_name

   After creating the migration, run it with:

   bash

   php artisan migrate

   1	php artisan migrate

Viewing Data

• Click on any table name in the Database manager to view the data within that table.
• You can add new records, edit existing ones, or delete them directly from the Voyager interface.

Conclusion

The Database manager in Laravel Voyager makes managing your application’s database straightforward and intuitive. By leveraging its features, you can easily create and manage your tables and their relationships, as well as set up BREAD functionality without writing extensive code. This not only speeds up development but also provides a user-friendly interface for managing your database.

 

1. Laravel Breeze – Simple authentication starter kit
2. Laravel Jetstream – Scaffolding for Laravel apps
3. Laravel Passport – API authentication via OAuth2
4. Laravel Sanctum – Simple API authentication
5. Spatie Laravel Permission – Role and permission management
6. Laravel Cashier – Subscription billing with Stripe
7. Laravel Scout – Full-text search using Algolia
8. Laravel Socialite – OAuth authentication (Google, Facebook, etc.)
9. Laravel Excel – Excel import and export for Laravel
10. Laravel Horizon – Redis queues monitoring
11. Laravel Nova – Admin panel for Laravel
12. Laravel Fortify – Backend authentication for Laravel
13. Laravel Vapor – Serverless deployment on AWS
14. Laravel Telescope – Debugging assistant for Laravel
15. Laravel Dusk – Browser testing
16. Laravel Mix – API for compiling assets
17. Spatie Laravel Backup – Backup management
18. Laravel Livewire – Building dynamic UIs
19. Spatie Laravel Media Library – Manage media uploads
20. Laravel Excel – Excel spreadsheet handling
21. Laravel Debugbar – Debug tool for Laravel
22. Laravel WebSockets – Real-time communication
23. Spatie Laravel Sitemap – Generate sitemaps
24. Laravel Spark – SaaS scaffolding
25. Laravel Envoy – Task runner for deployment
26. Spatie Laravel Translatable – Multilingual model support
27. Laravel Backpack – Admin panel
28. Laravel AdminLTE – Admin interface template
29. Laravel Collective Forms & HTML – Simplified form and HTML generation
30. Spatie Laravel Analytics – Google Analytics integration
31. Laravel Eloquent Sluggable – Automatically create slugs
32. Laravel Charts – Chart integration
33. Laravel Auditing – Track changes in models
34. Laravel JWT Auth – JSON Web Token authentication
35. Laravel Queue Monitor – Monitor job queues
36. Spatie Laravel Query Builder – Filter, sort, and include relationships in Eloquent queries
37. Laravel Datatables – jQuery Datatables API
38. Laravel Localization – Multilingual support for views and routes
39. Laravel Acl Manager – Access control list manager
40. Laravel Activity Log – Record activity in your app
41. Laravel Roles – Role-based access control
42. Spatie Laravel Tags – Tagging models
43. Laravel Installer – CLI installer for Laravel
44. Laravel Breadcrumbs – Generate breadcrumbs in Laravel
45. Laravel Mailgun – Mailgun integration for Laravel
46. Laravel Trustup Model History – Store model change history
47. Laravel Deployer – Deployment automation tool
48. Laravel Auth – Custom authentication guards
49. Laravel CORS – Cross-Origin Resource Sharing (CORS) support
50. Laravel Notifications – Send notifications through multiple channels
51. Spatie Laravel Http Logger – Log HTTP requests
52. Laravel Permission Manager – Manage permissions easily
53. Laravel Stubs – Customize default stubs in Laravel
54. Laravel Fast Excel – Speed up Excel exports
55. Laravel Image – Image processing
56. Spatie Laravel Backup Server – Centralize backups for Laravel apps
57. Laravel Forge API – Manage servers through the Forge API
58. Laravel Blade SVG – Use SVGs in Blade templates
59. Laravel Ban – Ban/unban users from your application
60. Laravel API Response – Standardize API responses
61. Laravel SEO – Manage SEO meta tags
62. Laravel Settings – Store and retrieve settings
63. Laravel DOMPDF – Generate PDFs
64. Laravel Turbo – Full-stack framework for building modern web apps
65. Spatie Laravel Event Sourcing – Event sourcing implementation
66. Laravel Jetstream Inertia – Jetstream’s Inertia.js integration
67. Laravel Envoy Tasks – Task automation
68. Laravel Likeable – Like/dislike functionality
69. Laravel GeoIP – Determine visitor’s geographic location
70. Laravel Country State City – Dropdowns for country, state, and city
71. Laravel Hashids – Generate short unique hashes
72. Laravel Repository – Repository pattern for Laravel
73. Laravel UUID – UUID generation for models
74. Spatie Laravel Medialibrary Pro – Enhanced media management
75. Laravel Queue Monitor – Monitor Laravel job queues
76. Laravel User Activity – Monitor user activity
77. Laravel DB Snapshots – Create database snapshots
78. Laravel Twilio – Twilio integration
79. Laravel Roles – Role-based permission handling
80. Laravel Translatable – Add translations to Eloquent models
81. Laravel Teamwork – Manage teams in multi-tenant apps
82. Laravel Full Text Search – Add full-text search to Laravel models
83. Laravel File Manager – File and media management
84. Laravel User Timezones – Automatically detect user time zones
85. Laravel ChartsJS – Render charts with ChartsJS
86. Laravel Stripe – Stripe API integration
87. Laravel PDF Generator – PDF generation
88. Laravel Elasticsearch – Elasticsearch integration
89. Laravel Simple Qrcode – Generate QR codes
90. Laravel Timezone – Manage timezones and conversions
91. Laravel Collective API – API management for Laravel
92. Laravel Rest API Boilerplate – REST API starter kit
93. Laravel Multi Auth – Multi-authentication functionality
94. Laravel Voyager – Admin panel for Laravel
95. Laravel Voyager Database – Database manager for Voyager
96. Laravel Categories – Handle categories for models
97. Laravel Multitenancy – Multi-tenancy implementation
98. Laravel Access Control – Advanced access control for users
99. Laravel Menus – Menu management
100. Laravel Translatable Routes – Multilingual route handling