Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 27FCC635369 for ; Thu, 27 May 2010 16:29:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 90214-08-3 for ; Thu, 27 May 2010 19:29:15 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id E70256346A7 for ; Thu, 27 May 2010 16:29:09 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id o4RJSlKM031458 for ; Thu, 27 May 2010 16:29:07 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id o4JLTCif053899 for pgsql-admin@postgresql.org; Wed, 19 May 2010 18:29:12 -0300 (ADT) (envelope-from news) From: Lew X-Newsgroups: pgsql.admin Subject: Re: Firebird To postgresql migration help needed Date: Wed, 19 May 2010 17:29:15 -0400 Organization: albasani.net Lines: 29 Message-ID: References: <28610086.post@talk.nabble.com> <28610897.post@talk.nabble.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@albasani.net X-User-ID: oGIrLJPfN7B3vaxT9b3ln+8MmbfvUk/2K8NoJTrFYw0= In-Reply-To: Cancel-Lock: sha1:ary9TsR86+WlzUG2vVwNa7oJWHA= User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100423 Thunderbird/3.0.4 X-NNTP-Posting-Host: gwMgN9xBlqybgpU8qSkGzmXkUh1QjkAiClu4tVSFEeo= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/13 X-Sequence-Number: 34791 Scott Marlowe wrote: >>> I use nano or vi for most stuff. Both can do color coding quite nicely >>> for .sql files. mnavahan wrote: >> i [sic] need powerful IDE for it with modernize options (extended editor) rich >> good .... Scott Marlowe wrote: > Got me. Maybe eclipse has a nice plugin? I find both Eclipse and NetBeans to be quite sufficient as SQL editors and admin/edit/query front ends for any database system that has a JDBC driver. They probably aren't quite as useful if you aren't using Java, although both have C/C++ capability. I'm not familiar with other IDEs. No extra plugins were required with the current versions that I downloaded, namely NetBeans 6.8 or 6.9beta or Eclipse Galileo SR2. The IDEs have additional advantages besides managing databases and editing SQL and program source code, such as providing quite convenient management consoles for popular Java application servers such as Tomcat or various Java EE products, and handling applications' build and deployment phases. YMMV. They might represent overkill for some folks. I enjoy the convenience of having everything under one roof. -- Lew