3 ms·
dbeaver-community does the day to day stuff really well. One great feature is built-in SSH tunneling. There are also frequent updates. The only thing I haven't
by steamer25 8y ago
dbeaver-community does the day to day stuff really well. One great feature is built-in SSH tunneling. There are also frequent updates.
The only thing I haven't been able to find a great solution for yet is comparing schemas between DB instances and generating DDL to make up the difference.
- oneweekwonder 8y ago> solution for yet is comparing schemas between DB instances and generating DDL to make up the difference. Have you looked at liquibase diff[0] before? I created yet another python wrapper[1] for the jar to integrate it into my workflow for easy DDL generation as I need to compare databases. [0]: https://www.liquibase.org/documentation/diff.html https://www.liquibase.org/documentation/diff.html [1]: https://github.com/Morabaraba/python-liquibase https://github.com/Morabaraba/python-liquibase
- steamer25 8y agoI don't remember why I dismissed liquibase when I was looking at the options. Maybe it was seeing that 'Role-Based Authentication' is only supported in the paid version? I ended up getting most of what I needed out of pgquarrel although I think I ended up manually maintaining the auth parts anyway. If/when it comes up again, maybe I'll take another look at liquibase. Ultimately, yeah, I just got better at keeping track of the changes myself as in the article you link in your GitHub README: http://www.liquibase.org/2007/06/the-problem-with-database-diffs.html http://www.liquibase.org/2007/06/the-problem-with-database-d...