Cannot modify columns on imported or created PSQL databases

[michaelma7]

Description

Cannot delete tables or modify column data of existing or created PSQL databases. Buttons and forms seem to respond but do not properly update the table with new columns or deleting columns. Imported tables still have access to change existing column data but columns cannot be removed or added.

Reproduction

Win10 App D/L for v14.0
https://github.com/open-source-labs/SeeQR/releases/download/v14.0.0/SeeQR-14.0.0-win.zip

System information

System:
OS: Windows 10 10.0.19045
CPU: (16) x64 AMD Ryzen 7 7700X 8-Core Processor
Memory: 31.21 GB
Binaries:
Node: 20.13.1 - ~\nodejs\node.EXE
npm: 10.8.0 - ~\repos\SeeQR\node_modules.bin\npm.CMD
Browsers:
Chrome: 125.0.6422.142
Edge: Chromium (125.0.2535.85)
Internet Explorer: 11.0.19041.4355
npmPackages:
@babel/core: ^7.22.10 => 7.24.5
@babel/preset-env: ^7.22.10 => 7.24.5
@babel/preset-react: ^7.22.5 => 7.24.1
@babel/preset-typescript: ^7.24.1 => 7.24.1
@electron/packager: ^18.3.2 => 18.3.2
@emotion/react: ^11.11.1 => 11.11.4
@emotion/styled: ^11.11.0 => 11.11.5
@eslint/js: ^9.2.0 => 9.3.0
@faker-js/faker: ^8.0.2 => 8.4.1
@fontsource/roboto: ^5.0.13 => 5.0.13
@mui/icons-material: ^5.15.6 => 5.15.18
@mui/material: ^5.14.5 => 5.15.18
@pmmmwh/react-refresh-webpack-plugin: ^0.5.11 => 0.5.13
@reduxjs/toolkit: ^2.2.4 => 2.2.5
@testing-library/jest-dom: ^6.4.5 => 6.4.5
@testing-library/react: ^15.0.7 => 15.0.7
@types/chart.js: ^2.9.37 => 2.9.41
@types/debounce: ^1.2.1 => 1.2.4
@types/enzyme: ^3.10.13 => 3.10.18
@types/enzyme-adapter-react-16: ^1.0.6 => 1.0.9
@types/jest: ^29.5.12 => 29.5.12
@types/ms: ^0.7.31 => 0.7.34
@types/mysql2: github:types/mysql2 => 1.0.0
@types/node: ^20.5.2 => 20.12.12
@types/pg: ^8.10.2 => 8.11.6
@types/react: ^18.2.20 => 18.3.2
@types/react-dom: ^18.2.7 => 18.3.0
@types/styled-components: ^5.1.26 => 5.1.34
@types/three: ^0.164.0 => 0.164.0
@types/webpack: ^5.28.5 => 5.28.5
@typescript-eslint/eslint-plugin: ^7.9.0 => 7.9.0
@typescript-eslint/parser: ^7.9.0 => 7.9.0
babel-loader: ^9.1.3 => 9.1.3
chart.js: ^4.3.3 => 4.4.3
concurrently: ^8.2.1 => 8.2.2
cross-env: ^7.0.3 => 7.0.3
css-loader: ^7.1.1 => 7.1.1
d3: ^7.8.5 => 7.9.0
dagre: ^0.8.5 => 0.8.5
debounce: ^2.0.0 => 2.0.0
electron: ^30.0.4 => 30.0.6
electron-builder: ^24.13.3 => 24.13.3
electron-reloader: ^1.2.3 => 1.2.3
electron-store: 9.0 => 9.0.0
enzyme: ^3.11.0 => 3.11.0
eslint: ^8.57.0 => 8.57.0
eslint-config-airbnb: ^19.0.4 => 19.0.4
eslint-config-prettier: ^9.1.0 => 9.1.0
eslint-import-resolver-typescript: ^3.6.1 => 3.6.1
eslint-plugin-import: ^2.29.1 => 2.29.1
eslint-plugin-jsx-a11y: ^6.8.0 => 6.8.0
eslint-plugin-react: ^7.34.1 => 7.34.1
eslint-plugin-react-hooks: ^4.6.2 => 4.6.2
file-loader: ^6.2.0 => 6.2.0
fix-path: 3.0 => 3.0.0
fork-ts-checker-webpack-plugin: ^9.0.2 => 9.0.2
html-webpack-plugin: ^5.5.3 => 5.6.0
identity-obj-proxy: ^3.0.0 => 3.0.0
immer: ^10.1.1 => 10.1.1
jest: ^29.7.0 => 29.7.0
jest-environment-jsdom: ^29.6.3 => 29.7.0
monaco-editor: ^0.48.0 => 0.48.0
ms: ^2.1.3 => 2.1.3
mysql: ^2.18.1 => 2.18.1
mysql2: ^3.6.0 => 3.9.7
nodemon: ^3.0.1 => 3.1.0
npm: ^10.7.0 => 10.8.0
npm-run-all: ^4.1.5 => 4.1.5
pg: ^8.11.3 => 8.11.5
postcss: ^8.4.28 => 8.4.38
postcss-loader: ^8.1.1 => 8.1.1
react: ^18.2.0 => 18.3.1
react-chartjs-2: ^5.2.0 => 5.2.0
react-dom: ^18.2.0 => 18.3.1
react-force-graph: ^1.43.0 => 1.44.3
react-redux: ^9.1.2 => 9.1.2
react-refresh: ^0.14.0 => 0.14.2
reactflow: ^11.8.3 => 11.11.3
sass: ^1.66.1 => 1.77.2
sass-loader: ^14.2.1 => 14.2.1
sql-formatter: ^15.3.1 => 15.3.1
sqlite3: 5.1.6 => 5.1.6
style-loader: ^4.0.0 => 4.0.0
styled-components: ^6.0.7 => 6.1.11
text-encoding: ^0.7.0 => 0.7.0
three: ^0.164.1 => 0.164.1
three-spritetext: ^1.8.1 => 1.8.2
ts-jest: ^29.1.3 => 29.1.2
ts-loader: ^9.4.4 => 9.5.1
ts-node: ^10.9.2 => 10.9.2
typescript: ^5.4.5 => 5.4.5
typescript-eslint: ^7.9.0 => 7.9.0
webpack: ^5.88.2 => 5.91.0
webpack-bundle-analyzer: ^4.9.0 => 4.10.2
webpack-cli: ^5.1.4 => 5.1.4
webpack-dev-server: ^5.0.4 => 5.0.4

Additional information

No response

👨‍👧‍👦 Contributing

• 🙋‍♂️ Yes, I'd love to make a PR to fix this bug!