Database Manager is a rust, front-end, client-side application to quickly manage and view the state of a MySQL database. It was primarily developed to better manage the database behind HasinZaman.link.
More information about the project can be found at hasinzaman.link/Database_Manager.
Download the repository on your system
Use Cargo run to run the source code or cargo build to build an executable
Download and unzip one of the releases
The application requires certain environmental variables to be set to function.
DB_host : the host address of your database
DB_port : the port your database is hosted on
DB_name : the name of the database
DB_username : username of the user on the database
DB_password : password of the user on the database
The application can only be navigated through the commands inputted to the console.
- All
letter,numberandsymbolkeys input characters into the console Enterkey is used to execute commandsDown Arrowkey retrieves the previously executed commandUp Arrowkey retrieves the next most recently executed command or draft command
The schema tab is used to see the architecture of the database
Any of the following commands open's the Schema Tab
show *command is used to show the definition of every table and view the databaseshow viewscommand is used to show the definition of every view on the databaseshow tablescommand is used to show the definition of every table on the databaseshow [table or view name]command is used to show all the details relating to the definition of a specific table or view
Note: Font colour is used to refer to the primary key constraint, while highlighter colour is used to refer to the foreign key constraint. The same font and highlight colour refer to a primary-foreign key relation.
The query tab is used to see the state of tuples in views and tables in the database
Only valid SELECT SQL commands are used to open the Query Tab
SELECT ...commands define which tuples are viewednextcommand is used to get the next page of tuplesprevcommand is used to get the previous page of tuples
ex. Show all the tuples that exist in the natural join of two tables
SELECT * FROM table_1, table_2 WHERE table_1.id = table_2.idex. Show all tuples greater than 30
SELECT * FROM table_1 WHERE table_1.n > 30The snapshot tab is used to add, remove or rollback the database to a given point in the database's history
Only a snapshot command can open the Snapshot page
snapshotcommand opens the snapshot pageaddcommand adds a new snapshot from the current databaseremove [row or name]command removes the snapshotrollback [row or name]command is used to rollback the database to the specified snapshot
Distributed under the MIT License. See LICENSE.md for more information.