Examples for Express Admin
Environment
- node >= 14
- npm
- docker
- docker-compose
MySQL
# start MySQL database server (pick one) docker-compose up mysql docker-compose up mysql5 docker-compose up mariadb # login to the running container (pick one) docker exec -it x-admin-mysql bash docker exec -it x-admin-mysql-5 bash docker exec -it x-admin-mariadb bash # login to mysql mysql -u root -p
-- create database create schema `x-admin-examples` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
# import schema mysql -p --user=root 'x-admin-examples' < fixtures/mysql/schema.sql mysql -p --user=root 'x-admin-examples' < fixtures/mysql/insert.sql
PostgreSQL
# start PostgreSQL database server (pick one) docker-compose up pg docker-compose up pg9 # login to the running container (pick one) docker exec -it x-admin-pg bash docker exec -it x-admin-pg-9 bash # login to psql psql -U postgres
# create database create database "x-admin-examples";
# import schema psql -U postgres 'x-admin-examples' < fixtures/pg/schema.sql psql -U postgres 'x-admin-examples' < fixtures/pg/insert.sql
SQLite
# create database and import schema
node fixtures/sqlite-import.jsExamples
# install test dependencies npm install # update absolute paths set inside the config folder node path.js # start the admin node start.js mysql # or pg, sqlite
Navigate to http://localhost:3000 user admin pass 1234abCD
Diagrams
MySQL Workbench can be used to preview the database diagrams.