ide
ide copied to clipboard
Improve SQL table views
- (1) Highlight that the user needs to input the name of the variable in which sqlite database is stored (usually 'db'). Users commonly mistake this for the table name, resulting in errors.
- (2) The last row of the table has input fields to make it possible to add new data, but these inputs blend in with rest of the rows and the user does not notice them. Update input fields to make them stand out more than the rows.
- (3)* Pre existing rows cannot be updated. Create a row component that will have an edit icon along with the delete icon. Clicking this icon will replace row texts with input fields and show a save button. On save run a query to update the row accordingly
- (4) Show a confirmation popup on clicking the delete icon, it is possible to delete the row by mistake.