Hacker News Reader

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.

View on HN

> 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

[1]: https://github.com/Morabaraba/python-liquibase

I 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-d...

Reply on news.ycombinator.com