Python / Schema Diff Tool
От | Patrick Earl |
---|---|
Тема | Python / Schema Diff Tool |
Дата | |
Msg-id | courier.44151B66.00003182@e-intermart.com обсуждение исходный текст |
Список | pgadmin-hackers |
Greetings all. I am a fan of the pgAdmin system as it seems to be the most developed open source admin tool for PostgreSQL. I did some searching for software to compare database schemas and generate scripts to make two databases the same. I found a couple projects that used either a web interface or the command line to do the work. My wishes are for something more visual. For example, you would see a tree of objects with items highlighted in different colours that show the changes. You could then select any of those items and have the tool make those changes in the appropriate database. I am presently working on such a tool. The reason I'm writing is that I would have liked to integrate the diff system into pgadmin. However, I don't have the inclination to work in C++, so I opted to use Python for the tool. I noticed that Python scripting is one of the major todo items. I was hoping for even simplistic integration. To start, all that would be needed would be a way to load a python extension and some method that allows you to add an item to a menu. To keep the dependencies to a minimum, I'm using only wxPython and the PygreSQL modules (Python's DB-API). I have little doubt that python extensions would help pgAdmin attract even more development. Even a simple extension system could be extended as developers need new forms of integration. So in summary, I would be happy to integrate my python program into pgAdmin if python support is provided. Otherwise, it will unfortunately remain a stand-alone program. I look forward to hearing comments and hopefully being able to contribute to the pgAdmin community. Best regards, Patrick Earl
В списке pgadmin-hackers по дате отправления: