Note: This is a alpha version of the software. You are advised to proceed with caution!
Overview
A free and open source database administration and development tool for developers, database admins and sysadmins.
Installation
Prerequisites
- Git
- Composer
- NPM
Option 1: via Composer
- Run
composer create-project logicent/crudbase:dev-main && cd crudbase
Option 2: via CLI
- Run
git clone git@github.com:logicent/crudbase.git && cd crudbase - Run
composer install
Continue:
- Create a database and update your
.envsettings - Run
./crudle serve -t webin local environment or use preferred web server in production
Context
Crudbase is a database management tool for easy development and maintenance of relational and non-relational databases built using a modified Yii2-crudle template. It features a fully-fledged and responsive admin UI.
Containers
- app (Admin)
- modules (Plugins)
Components
- Main module - for bootstrapping the web app
- Setup module - for managing plugins & users
- Admin module - for managing your DB objects
- Extension modules - for installed plugins
Programming Languages and Frameworks
- PHP 8.0 using Yii2 and JavaScript using jQuery & Htmx 2
- Dockerized (todo later)
Databases Supported
- MySQL
- MariaDB
- SQLite
- PostgreSQL
Now:
- Create Database
- Drop Database
- Alter Database (Create Database [Rename Table..To..] Drop Database)
- Create Table
- Rename Table
- Truncate Table
- Drop Table
- Create View
- Drop View
- Add Column
- Rename Column
- Alter Column
- Drop Column
- Add Primary Key
- Drop Primary Key
- Add Foreign Key
- Drop Foreign Key
- Create Index
- Drop Index
Next:
Later:
Want to contribute? Thank you for considering to make a contribution to Crudbase. New contributors to improve the solution further or help provide support to issues are most welcome.
License Crudbase is released under the BSD-3-Clause.