Visualizer for SQL databases able to read and write data from a databse using a website front end: https://pg-sql-visualizer.herokuapp.com/.
Current Version Notes:
- Click on the table name to pull the full table
- Bad links will kick you back to login without prompt. Successful links will display the data.
- User data is not saved. Sessions are persisted from JWT's on sign-up. If you'd like to change the database, return to the login screen and "sign-up" with a new database link to receive a new session JWT.
- There is a bug where queries do not go through to the databse. Just keep trying until it works. Create and update commands are performed after a cell is unselected.
- The insert row above/below doesn't work yet and has been disabled but the text it still displayed in the context menu.
Basic Features:
- Visualize all tables and column names
- Visualize all rows from a table when table name is clicked
- Create, Read, Update, Destroy for individual rows
- Drag cell values down to quickly copy and write to adjacent cells from same column
- Highlight primary key column
- Able to create new column
- Able to create new table
- Able to filter rows based on user input
- Able to sort rows based on user input
Advanced Features:
- Highlight and identify foreign keys/tables
- Able to manually create relationships between tables using keys
- Able to automatically create relationships between tables using keys
- Able to join tables
- Data visualization
- Data type matching
Authentication and Sessions:
- Save and persist database link in session as JWT
- Save user data in database to retrieve on login
- Store and switch between user databases from main page
- OAuth login
Quality of Life Features:
- Feedback if data was not written to database
- Feedback if database not successfully loaded
Stretch Features:
- Able to insert data in the middle at user-designated row
- Able to re-order columns by drag-drop
- Able to re-size columns
- Able to print table data