For those that use SQL, what are your thoughts/impressions? Do you have more than one node talking to the SQL DB?
I like the idea of using SQL, but I run into so many weird things compared to a single node talking to a local LiteDB.
Issue number 1. I tend not to use the UI for updating scripts and prefer to use VScode to do my work. When I have a node connected to SQL and edit through the filesystem via VSCode, I get sync issues where my changes in VSCode get reverted unless I make the change through PSU UI.
For instance, if I make a change through VScode, it might not show up in the PSU UI after a refresh.
Issue number 2. I might have a few nodes talking to this single DB, and one of those nodes might have a script unique to node one, and when I run the script, it defaults to whatever node is accessible. Can I set that script to only run on a particular node via the New-PSUScript cmdlet?
For those that have multiple nodes talking to a single DB, do you have your dev/test/prod instances all talking to a single db? or would it be better to have something like this:
Dev/test -> SQL
Prod -> SQL
One of the reasons we are wanting to move to SQL is due to the number of variables we have stored in PSUSecretStore and BuiltInLocalVault and it’s annoying to have to reconfigure them across instances. We are also looking forward to the reporting capabilities we can get out of SQL and longer auditing.
I am also running SQL, and see lots of issues lately. There have always been some quirks, but for me they definitely seem to be getting worse as time goes on.
On my instance it takes a long time to save changes through the GUI, and I think maybe there is some race condition where VSCode will send a change, but then something happens in the GUI that supersedes that change, or if I change code and then modify the script settings too soon the old code will revert back… like the change writes the whole script code and settings regardless which was changed.
Sometimes I also see VSCode get out of sync where I will make a change in VSCode and it looks like it’s saving but PSU doesn’t see the changed. Usually I have to restart VSCode to fix that.
That is exactly what i have been seeing as well. Nothing sucks worse then when you make a change to your code, and it gets reverted back without you noticing. I thought it was just me using VScode externally and not the PSU UI.
I run a two node instance to a HA SQL database. I haven’t had too much issue with VSCode changes but I have had issues with looooong save times via Powershell UI. One other issue that I experience is if you use PSCredential and you save it in the database, it still only works on one node.
For the slow saving…is it all resources (scripts, dashboards, variables etc) when this is happening?
Is git sync enabled?
How many dashboards do you have?
Have you checked out the profiler at all? It has specific timings around the configuration system and I wonder if we could get some more info on what might be slow: Profiling - PowerShell Universal
It appears the slow saving is because it is closing and reopening every dashboard session when saving a dashboard page. Why would it do every dashboard session instead of just the dashboard the page was saved in?