How bishalbhandari-art/bms-backend works
This repository documents a PostgreSQL book-management database, not an application runtime. Its workflow is to create the database, define the normalized author/category/book schema, insert data, and run query and modification examples. The README also documents backup and restore with pg_dump/psql and remote version-control backup through GitHub. Relationships are based on README descriptions; SQL source was not available to inspect.
Components 13
Database lifecycle
- PostgreSQL
- Create database
- Define tables
- Authors
- Categories
- Books
- Insert sample data
- Query and modify
- pg_dump
- psql
- SQL backup
Other components
- Database user
- GitHub
Connections 18
- Database user → Create database: runs first
- Create database → PostgreSQL: creates database
- Database user → Define tables: runs next
- Define tables → PostgreSQL: creates tables
- Define tables → Authors: defines
- Define tables → Categories: defines
- Define tables → Books: defines
- Database user → Insert sample data: runs next
- Insert sample data → PostgreSQL: inserts data
- Database user → Query and modify: runs queries
- Query and modify → PostgreSQL: queries and modifies
- Database user → pg_dump: runs backup
- pg_dump → PostgreSQL: reads database
- pg_dump → SQL backup: writes backup
- Database user → psql: runs restore
- psql → SQL backup: reads backup
- psql → PostgreSQL: restores database
- Database user → GitHub: pushes scripts