面向开发的PostgreSQL IDE [英] Development oriented PostgreSQL IDE

问题描述

有人会推荐面向开发人员的PostgreSQL IDE，而不是数据库架构师或管理员。即我寻找一个可以提高我的工作效率的IDE：



1.编写存储的函数（代码完成和语法高亮）

2. Ctr + Click函数之间的导航（或任何其他方式）

3.查找所有引用（使用某些函数或表）

4.重构存储函数（重命名函数或变量;提取函数）等）

5.重构表（如果我更改列名，使用该列的函数和视图也应该更新）

6.在开发过程中构建我的函数文件夹（让它们最终在数据库上展平）



我目前正在处理的项目有数百个表和超过数千个函数。目前我使用pgAdmin并且我的工作效率非常低。

我迄今为止检查过的所有数据库开发工具（ http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools ）不要覆盖我对现代IDE的期望值的10％。

Could someone recommend PostgreSQL IDE oriented on developers, not on database architects or administrators. I.e. I look for an IDE that will increase my productivity in:

1. Writing stored functions (code completion and syntax highlighting)
2. Ctr+Click navigation between functions (or any other way)
3. Finding All References (where certain function or table is used)
4. Refactoring stored functions (renaming function or variable; extracting function etc.)
5. Refactoring tables (if I change column name, functions and views that uses that column should be also updated)
6. Structuring my functions during the development into kind of folders (let them be finally flatten on the database)

The project that I currently working on has hundreds of tables and more than thousand of functions. Currently I work with pgAdmin and my productivity is extremely low.
All database development tools that I checked so far from (http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools) do NOT cover even 10% of what I expect from a modern IDE.

推荐答案

我认为Eclipse的Toad插件将是你能找到的最接近的东西。不幸的是，拥有这些功能的完全全面的IDE将成为一个巨大的项目，部分原因是PostgreSQL可以使用多种不同语言的存储过程，因此存储过程中的语法突出显示需要大量的知识（理论上，是认为完整，不仅是sql和plpgsql，还有C，C ++，Java，Python，Perl，TCL，R，Ruby，Lisp，各种shell，PHP，Lolcode和Brainfuck - 可能还有更多但是那些是来的在我心里）。因此，这样做的唯一希望就是绑定到另一个IDE。

I think the Toad plugin for Eclipse is going to be the closest thing you can find. Unfortunately, having a totally comprehensive IDE with these features is going to be a huge project in part because PostgreSQL can use stored procedures in so many different languages, so syntax highlighting inside the stored procedure requires a vast amount of knowledge (in theory, to be considered complete, not only sql and plpgsql but also C, C++, Java, Python, Perl, TCL, R, Ruby, Lisp, various shells, PHP, Lolcode, and Brainfuck -- there are probably more but those are the ones that come to my mind). Consequently the only hope of doing this is to tie into another IDE.

这就是我说的，我认识的大多数开发人员都倾向于使用bash，vim等。是一种根本不同的范例，但它在很多方面都更加灵活，而且你所遇到的限制迫使你以合理的方式设计和测试你的SQL。

This being said I, and most devs I know, tend to use bash, vim, etc. It is a fundamentally different paradigm but it is more flexible in many ways, and the limitations you do run up against force you to design, and test, your SQL in sane ways.

这篇关于面向开发的PostgreSQL IDE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！