topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 4:41 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Last post Author Topic: What's the best SQL software for writing queries?  (Read 13979 times)

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
What's the best SQL software for writing queries?
« on: February 15, 2011, 11:23 AM »
I'm working with an SQL database for the first time, and I was wondering what you guys consider a good SQL software for writing queries?
The one's I've seen so far are:
SQL+ which comes with SQL installer; nothing special
SQL Developer; free from Oracle, the guys here seem to like it, it seems pretty handy to me
PL/SQL Developer; a commercial software similar to the one above, it might be better, I don't know

Any others?  Is there a lesser known one that does things more nicely or easily?  Remember, I'm looking for nifty shortcuts, like buttons, panes, cool autofill features, etc.  Stuff that makes life easier.  Any suggestions?

mahesh2k

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,426
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #1 on: February 15, 2011, 11:46 AM »
1.SQLite admin ? Not updated version of sqlite in it but can get your small work done.
2. SQLite maestro

Floppy

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 15
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #2 on: February 15, 2011, 12:20 PM »

f0dder

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #3 on: February 15, 2011, 01:03 PM »
Notepad++ :)
- carpe noctem

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #4 on: February 15, 2011, 01:14 PM »
Notepad++ :)
Oh geez.  Yes, the highlighting features are nice, but it's not really tied to the database or anything.  These other programs kind of do it all.  I think I'm going to stick with PL/SQL, it's pretty neat.

Shades

  • Member
  • Joined in 2006
  • **
  • Posts: 2,922
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #5 on: February 15, 2011, 01:33 PM »
Personally I use the free Oracle SQL developer software the most.

But it is resource hungry. SQLtools is one hell of a lot smaller, open source and actually quite powerful and extended, given its size. It is not actively developed, but it is rock solid working with Oracle 9 and 10 databases on XP and lower (personal experience). Expect on windows 7 (UAC) problems.

There is also TOra, another open source project with more recent development activity. Seems to be interesting as well.


EDIT:
Added the TOra part
« Last Edit: February 15, 2011, 01:37 PM by Shades »

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,612
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #6 on: February 15, 2011, 01:36 PM »
I'm working with an SQL database ...
What database platform (brand) are you working with?

Shades

  • Member
  • Joined in 2006
  • **
  • Posts: 2,922
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #7 on: February 15, 2011, 01:37 PM »
Looking at the answers above it appears to be Oracle

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,612
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #8 on: February 15, 2011, 01:44 PM »
Oh, then I won't suggest the Microsoft toolchain then :P

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #9 on: February 15, 2011, 03:27 PM »
Not for Oracle, but...

SQLYog
HeidiSQL
Query Analyzer (Microsoft SQL Server Studio)

There are lots. Just find what you like.
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #10 on: February 15, 2011, 03:56 PM »
TOra looks interesting.  And yes, it's an Oracle database.  I still like PL/SQL so far.

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #11 on: February 15, 2011, 03:59 PM »
TOra looks interesting.  And yes, it's an Oracle database.  I still like PL/SQL so far.

To be honest, for your first database, Oracle doesn't really make sense. It's simply a gargantuan beast. Oracle runs countries. Something else would make more sense. MySQL is a good choice. Or PostGreSQL. MS SQL Server is good.

It's kind of like going to the firing range to learn how to shoot with strategic nuclear missiles.

Is there a reason why you're using Oracle?
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #12 on: February 15, 2011, 04:22 PM »
TOra looks interesting.  And yes, it's an Oracle database.  I still like PL/SQL so far.

To be honest, for your first database, Oracle doesn't really make sense. It's simply a gargantuan beast. Oracle runs countries. Something else would make more sense. MySQL is a good choice. Or PostGreSQL. MS SQL Server is good.

It's kind of like going to the firing range to learn how to shoot with strategic nuclear missiles.

Is there a reason why you're using Oracle?
I'm using Oracle because I'm at work.  Our IT is apparently overloaded  :mad: with work so I have to now get into this stuff.  It's not my job, but at least it's something I've always wanted to learn anyway.

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #13 on: February 15, 2011, 05:50 PM »
Ah. That makes sense then.
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 11,186
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #14 on: February 15, 2011, 07:15 PM »
TOAD is the one I always used for Oracle.  They have a free version (the one I linked) and a non-free one.

Shades

  • Member
  • Joined in 2006
  • **
  • Posts: 2,922
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #15 on: February 16, 2011, 12:34 PM »
yes, TOAD...the tone from their sales pitch goes bad after '...or else...' and

And the free one is quite limited in what it can do, even after they updated it to a more recent version of their pro product and extended the default time-limit. Granted, that is their prerogative, but it drove me into the arms of Oracle SQL Developer, which is free and practically does what the free one does. I do not have experience with the pro product from TOAD as I think they are way too expensive and have a nasty attitude regarding sales. Then again, that is the way Oracle does business, so why not affiliated 3rd party developers...

And Renegade is right, Oracle Enterprise runs countries. But their free XE version (based on 10g) is actually quite a nice product if you can live with some missing (Enterprise-related) functionality and a limited database size of 4 GByte. Ideal for home use and/or study.

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #16 on: February 16, 2011, 03:29 PM »
I'm still sticking with PL/SQL Developer as the best option so far.  What's my favorite thing about it?  It's more responsive than the others.  it just feels faster, like a good text editor.  Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.

Stoic Joker

  • Honorary Member
  • Joined in 2008
  • **
  • Posts: 6,646
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #17 on: February 16, 2011, 04:03 PM »
Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.

I think that's why f0dder suggested Notepad++ earlier. I use Emedit for much the same thing/reason. I write the query in the syntax high-lighted editor and then paste it into a command prompt (CLI client connection) - Usually with all activity dumpted to a text file for later review. (But that's for MySQL stuff)

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #18 on: February 16, 2011, 04:48 PM »
Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.

I think that's why f0dder suggested Notepad++ earlier. I use Emedit for much the same thing/reason. I write the query in the syntax high-lighted editor and then paste it into a command prompt (CLI client connection) - Usually with all activity dumpted to a text file for later review. (But that's for MySQL stuff)
Nice.  Turns out I think like a programmer after all!  I knew I had it in me.

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #19 on: February 16, 2011, 07:12 PM »
I'm still sticking with PL/SQL Developer as the best option so far.  What's my favorite thing about it?  It's more responsive than the others.  it just feels faster, like a good text editor.  Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.

Syntax highlighting is the absolute most important thing for me in a text editor. (Regular expressions are #2 by a tiny margin.) I find Editplus has the best for what I like.
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #20 on: February 16, 2011, 07:16 PM »
I'm still sticking with PL/SQL Developer as the best option so far.  What's my favorite thing about it?  It's more responsive than the others.  it just feels faster, like a good text editor.  Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.


Syntax highlighting is the absolute most important thing for me in a text editor. (Regular expressions are #2 by a tiny margin.) I find Editplus has the best for what I like.
I agree!  I like EditPlus also!  I just tried it for the first time a couple of weeks ago and i was impressed.  I can't put my finger on it yet, but it was nice.  I tried doing a regex thing yesterday...I don't get it at all.

timns

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,211
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #21 on: February 16, 2011, 07:22 PM »
  I tried doing a regex thing yesterday...I don't get it at all.

RegEx is one of those things that this phrase desribes perfectly:

"It's nice to live there, but you wouldn't want to visit"

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #22 on: February 16, 2011, 07:25 PM »
  I tried doing a regex thing yesterday...I don't get it at all.

RegEx is one of those things that this phrase desribes perfectly:

"It's nice to live there, but you wouldn't want to visit"
ha ha.  I totally get that.  Yeah, people swear by it who use it all the time.  But to just dabble in it makes no sense.  I was saying what the fuck a lot...

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,288
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #23 on: February 16, 2011, 07:28 PM »
I'm still sticking with PL/SQL Developer as the best option so far.  What's my favorite thing about it?  It's more responsive than the others.  it just feels faster, like a good text editor.  Actually, I'm ending up writing the queries in a text editor and pasting it into Developer because I prefer the highlighting and code folding features of most editors better than these integrated things.


Syntax highlighting is the absolute most important thing for me in a text editor. (Regular expressions are #2 by a tiny margin.) I find Editplus has the best for what I like.
I agree!  I like EditPlus also!  I just tried it for the first time a couple of weeks ago and i was impressed.  I can't put my finger on it yet, but it was nice.  I tried doing a regex thing yesterday...I don't get it at all.

Oh god... You MUST get to know regex in EditPlus -- you will ****ing LOVE it~!  :-*

They're not 100% full regex, but it's still enough power for 99.9% of everything you'll ever need to do.

^ - beginning of line
$ - end of line
\n - line break
\t - tab
. - any character
*+? - used for matching 0/1 or more or 0/1 of the preceding character
[a-z0-9] - range of characters, e.g. [a-f0-9] for hex
[^a-z] - character NOT in range
() - used to group for later reference
\1 - reference to a group

That's likely about all that you'll ever need in EditPlus.

Also -- MAKE SURE TO CHECK THE REPLACE DIALOG -- THERE'S AN OPTION TO DO REGEX REPLACEMENTS IN ALL OPEN FILES~! Very powerful and very useful. God... That has saved me sooooo much work.

EditPlus is fast and can handle a LOT. I loaded 900 bada headers in it the other day.

I often write my DC posts in it first. :)

But this is horribly off topic...

Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

timns

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,211
    • View Profile
    • Donate to Member
Re: What's the best SQL software for writing queries?
« Reply #24 on: February 16, 2011, 07:29 PM »
This thing helps considerably:

Regex Buddy