3 ms·
I was underwhelmed by Postico when I tried it. On the other hand, I've been underwhelmed by pretty much every one of these tools over the past few years. Some
by rotten 12y ago
I was underwhelmed by Postico when I tried it. On the other hand, I've been underwhelmed by pretty much every one of these tools over the past few years.
Some minor complaints about Postico:
1) Most of the time I am not changing ddl. Postico over emphasizes the infrequent tasks and under emphasizes the things I do every day.
2) Everything I do should be automatically logged, and not something that I have to explicitly save.
3) Syntax highlighting would be nice. It has been around in other SQL tools for many years. Why would a new tool not include it?
4) It is a common task for me to compare the schema and data between two databases. This tool didn't seem to make that any easier.
5) I also will log in with various identities and different times. After you have a dozen or so databases and two or three users on each - this did not strike me as a tool that would let me organize them very well.
6) It still doesn't see Foreign tables. None of the tools I've tried allow for visual interaction with foreign tables. A new tool should definitely include support for it.
7) In spite of its emphasis on table structure, it doesn't seem to show indexes, comments, size, dependencies, ownership, and other details that are on the table besides just the columns. (that I could find)
Without having the time to write my own, I'm sticking with the legacy and really feeling old, SQLExplorer (based on Eclipse). It gives me most of the features I need (and for multiple data sources, not just PG). I would love to find something more modern and better, so I'll keep looking...