Is there any software that let me make graphical user interface to a connected database, allows me to make data visualizations, all things automatic and interactive?
Like a node editor or spreadsheet?
In theory Retool would be this, but it's clunky for the interface designer - namely, it assumes you might have different custom read and write paths, so it makes you jump through hoops in setting up a Cell Change Handler linked to a Query that writes to the database. See: https://community.retool.com/t/auto-save-table/16044
Airtable's interface builder is more reasonable in that it ensures that you're always looking at real-time data, and saves happen and propagate to all users whenever you change a character - but this requires that the canonical data live in Airtable. And setting up sync with external systems is clunky. I'm hopeful that people build better tools on top of Electric, because it's ridiculous that we live in 2024 and we don't have interfaces like this out of the box.