Slashdot Mirror

← Back to Stories (view on slashdot.org)

Oracle SQL Development Environment in Linux?

Posted by Cliff on from the does-this-exist? dept.

Jón Ragnarsson asks: "I develop Oracle applicatons for a living. And they are usually internet-related. Right now I'm developing on a Oracle 8i / Windows NT4 machine. But I have more and more become aware that NT is very limiting compared to un*x when it comes to selection of tools and servers for Internet development. I have installed Apache, perl, php and other stuff on the NT, but with much difficulty. So now I'm planning to switch my development environment to Linux (RedHat, Debian or SuSE). The thing I would miss most is the SQL Navigator, a tool I don't know how I could live without it before I started to use it. :) I know there are some utilities available for postgres and mysql in KDE, but AFAIK, they don't work on Oracle databases. Any ideas what I could replace SQL Navigator with? Or should I start writing my own database front end?" Hey! I develop Oracle apps on Solaris and could use something like this myself!

2 of 118 comments (clear)

  1. A couple of tips by tweek · · Score: 4

    First of join the Oracle-LINUX mailing list.

    Send email to ListGuru@fatcity.com
    In the body put SUBSCRIBE ORACLE-LINUX-L

    Many a great discussion happens on this list. It does generate a TON of traffic though.

    A good repository of tools is available at
    here


    "We hope you find fun and laughter in the new millenium" - Top half of fastfood gamepiece

    --
    "Fighting the underpants gnomes since 1998!" "Bruce Schneier knows the state of schroedinger's cat"
  2. Great question... by nlh · · Score: 4

    I've been waiting for a discussion about this topic to pop up, so I'm happy to add my few cents.

    I'm currently working on a web development project (using Oracle 8.0.5) with some folks and we're using Linux as the development enviornment. I've not actually ever used NT for this sort of thing, so I'm not familiar with the joys of SQL Navigator (for better or for worse).

    In scouring the pages of freshmeat and other sources, the best tool I've found is called dbMan. It's based on Perl, Tk, and DBI interfaces and works quite well for some purposes.

    Currently, the version I have (0.0.9pre1) lets you browse and modify tables and table data in a spreadsheet-like interface (adding new rows doesn't seem to work perfectly), run command line SQL queries with command history, and do some basic import-export functions. (check the website for more details.)

    I am very interested, however, as to what other people use and if there's anything a bit more hard core than dbMan.

    --
    Ferrari and other exotic car rentals in New York