This content has been marked as final. Show 21 replies
Sumanth wrote:I have been using vim (Vi IMproved) and sqlplus (with subversion as backend) for many years now as development environment. And I do a lot of development and a lot of db admin.
Recently we moved from Windows to Linux, can you guys suggest good SQL, PL/SQL Editors for Linux.
It is a perfect combination for those that are familiar with actually using the keyboard, as oppose to those that can only go clickety clicking on shiny GUI buttons with the same vacant expression in the eyes as that of a crystal meth addict.
Sumanth wrote:So what.. you have that vacant stare in your eyes too?
I am talking about any GUI tool for linux not a command line tool.
Writing s/w is done with the keyboard. GUI or console mode does not change that fact. And if that is an issue that prevents you from writing s/w, then I would question your writing s/w skills.
Granted - there are arguments to be made for a "slick/easy" IDE type of environment. Especially when dealing with the client environment that uses GDI objects and GUI widgets. But PL/SQL is server-side. And does not even have a console device for displaying data to the client.
So insisting that only a GUI is a consideration for writing PL/SQL s/w is stretching it.. a lot...
You are one of those fortunate people, who are "always writting" code.
I do 50% developement (writting code) and 50% (sometimes more) analysis/support, which is mainly browsing data, troubleshooting issues. Sql*plus (on Unix or Windows) is not ideal for simply browsing data.
I accept, I am not as expert as you, but looking at a table with 200-odd columns and looking at the indices it has and when all of these were analyzed, is a big job for me in sql*plus, which takes 20 secs in TOAD/SQLDeveloper.
BTW, if you are on Linux, I am not aware of a IDE/GUI you can install.
But Oracle provides iSQL*Plus, which can come handy without much efforts.
I assume you mean you are using Linux as your desktop os and not just that you have moved your database onto Linux? SQlDeveloper can definitely run directly on Linux but I've never really used it to know if your hanging issues are commonplace or you have something set up wrong - are you running the latest version?
There are various emulators to allow you to run windows app on linux which may be what you want? This for instacne sounds interesting - though I've never tried it http://digg.com/newsbar/topnews/PL_SQL_Developer_on_Linux
using vi/vim/emacs or your native gui linux editor is fine for simple stuff but working with large packages with lots of dependencies and stepping through debugging code is much easier in a full IDE it depends on how complex the work you are doing is.
As somebody doubted my s/w writing skills, we have done lot of development work in db which took very less time for development
using TOAD & PL/SQL Developer and where the application works great.
We have recently move to Ubuntu and we connect to client databases which are located at client sites, we installed TOAD & PL/SQL Developer with some work around but those works for sometime and hangs in between.
jgarry wrote:OK, so you found a blog posting from 2007 that says (basically) TOAD does not work on Linux (because it is Windows only), so install a Windows VM on Linux and run it from that VM.
wtf? I put "toad on linux" in the google, and out came http://www.toadworld.com/Blogs/tabid/67/EntryId/144/Running-Toad-on-Linux.aspx
The OP already knows TOAD does not work on Linux. The OP seems to be looking for an alternative that does work on Linux (natively I presume).
Am I missing something? Maybe I have misread something?
I have the same recommendation as Johan - namely, Oracle SQL Developer.