Paxa / postbird

Open source PostgreSQL GUI client for macOS, Linux and Windows
MIT License
1.54k stars 124 forks source link

On Windows 10 v2004, "Snippets" and "See History" will open an empty window #118

Open mastazi opened 4 years ago

mastazi commented 4 years ago

On Windows 10 Pro version 2004, Postbird 0.8.4 installed. Navigating to the "Query" tab and clicking on the "See History" button and/or "Snippets" button results in a new window being opened, that window contains a menubar (File, Edit, etc....) and nothing else, the rest of the window is just empty white space.

Due to this, I lost access to a snippet that I had saved before, does anyone know where are those saved on disk?

mastazi commented 4 years ago

Just in case anyone is wondering, snippets are saved in

%userprofile%\AppData\Roaming\Postbird\custom_snippets.json

luckily my snippet was there!

So at least we know that saving a snippet works as intended, it's just the retrieval part that's the issue.

mastazi commented 4 years ago

More info: I tried deleting the folder %userprofile%\AppData\Roaming\Postbird\ in order to start from a clean state, but the issue still persisted.

In addition I wanted to add that I also use Postbird on Mac (with Catalina) and I have no issues there.

ghost commented 3 years ago

so just another abandoned opensource project?

Paxa commented 3 years ago

Unfortunately I can't replicate this issue, I don't have windows. What you can do to help: open developer tools (inside view menu), then try to replicate the issue. If you see some error message there please share it

Lately I don't have much time to work on this project but I plan to release update for Postgres 13 soon, with few minor feature changes

mastazi commented 3 years ago

Hey @Paxa I submitted a PR, this fixes the issue on Windows https://github.com/Paxa/postbird/pull/119

Paxa commented 3 years ago

Thanks for PR, if someone can verify https://postbird.paxa.kuber.host/2020_10_12.20_33-master-bc53845 we can close this issue

mastazi commented 3 years ago

@Paxa I was the one doing the PR so I don't know if my opinion counts :-D

Anyway it works for me :-)

2020-10-20 15_26_25-Postbird 2020-10-20 15_26_08-Postbird

mastazi commented 3 years ago

@sebolio maybe you could test the build that @Paxa posted and confirm it's working now?

mastazi commented 3 years ago

@Paxa I hope you can get around releasing this fix some day. I have a mixed dev team with Windows and Mac users, Postbird is one of the very few cross platform free alternatives. Everyone dislikes pgAdmin 4 because it opens in the browser and often new team members ask me what client could they use. I would like to answer that they should use Postbird, but as long as History and Snippets are broken on Windows, I can't recommend it unfortunately.

paulwongx commented 1 year ago

Just encountered this issue on windows today. This is an amazing tool after downloading it today! I wish this snippets feature worked though....

mastazi commented 1 year ago

@paulwongx Postbird is abandonware. The last release was made in 2019. If you use it, it's at your own risk...

paulwongx commented 1 year ago

@mastazi That's unfortunate. It feels like a very nice clean setup without too much stuff going on. I downloaded and surface-level tried a bunch of different ones like a built-in vscode one, dbeaver, sqlectron. Any good free ones you'd recommend?

mastazi commented 1 year ago

@paulwongx nowadays I went back to using pgAdmin since it went back to being a desktop app (it no longer opens in a browser tab). But pgAdmin is pretty clunky and certainly not lightweight.

Besides that I had a good time with Beekeeper Studio which is easier to use compared to pgAdmin: https://www.beekeeperstudio.io/