db-system

Web application for creating and managing databases and tables. Each table gets a REST API for CRUD operations, secured with its own access token.

Features

• Registration and login with JWT authentication
• Create, edit and delete databases
• Create, edit and delete tables, columns and constraints
• Change column types and constraints
• Database access tokens with a configurable lifetime, separate from UI login tokens
• REST API for creating, reading, updating and deleting rows in any created table

Planned: custom queries, more column types and constraint options.

Tech stack

Project structure

server/   Spring Boot API
client/   Angular application
docker-compose.yml

Running

Requires Docker.

docker-compose up --build

Data API

After creating a database and a table, create an access token for the database in the UI. Send it as a bearer token to the data endpoints:

License

MIT