Author Topic: What's the best SQL software for writing queries? (Read 21,041 times)

timns · « **Reply #25 on:** February 17, 2011, 01:31 AM »

Can anyone compare EditPlus with EditPadPro please?

The features seem almost identical.

Renegade · « **Reply #26 on:** February 17, 2011, 01:35 AM »

Quote from: superboyac on February 17, 2011, 01:25 AM

Quote from: timns on February 17, 2011, 01:22 AM
Quote from: superboyac on February 17, 2011, 01:16 AM
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...

+1 * 10^10^10 timns~!

The thing with regular expressions is that the first time it saves you a kajillion hours of work, and you reflect on the few minutes that it took to get done, you realize that you are hooked, and you wonder how anyone could possibly live without them. Regular expressions are like crack^2.

timns · « **Reply #27 on:** February 17, 2011, 01:39 AM »

One of the few pieces of paper I still have out on my desk the whole time is my regex crib sheet. I mean, I use them a lot, but dangit there are some things I still cannot remember without looking them up.

Renegade · « **Reply #28 on:** February 17, 2011, 01:40 AM »

Quote from: timns on February 17, 2011, 01:31 AM

Can anyone compare EditPlus with EditPadPro please?

The features seem almost identical.

I prefer EditPlus. I have an EditPad Pro license that Jan gave me, but I still like EditPlus. I think EditPad Pro is probably a bit more powerful in some areas though. I find EditPlus is cleaner though. Maybe I'm just used to it though.

Jan writes THE definitive regular expressions program though -- PowerGREP. Very expensive.

Renegade · « **Reply #29 on:** February 17, 2011, 01:44 AM »

Quote from: timns on February 17, 2011, 01:39 AM

One of the few pieces of paper I still have out on my desk the whole time is my regex crib sheet. I mean, I use them a lot, but dangit there are some things I still cannot remember without looking them up.

Some things in regex are so complicated that it's simply easier to fire up your IDE and write a little piece of software to do it for you. Very few people ever truly master regular expressions. I'm damn good, but there's still a lot I don't know or can never remember. Crib sheets are pretty much necessary for regex for most people. That or going back to read a tutorial on back references or whatever.

Speaking of...

Expresso - http://www.ultrapico.com/Expresso.htm - Started out at the Code Project. Excellent piece of free software. Highly recommended.

timns · « **Reply #30 on:** February 17, 2011, 01:44 AM »

Quote from: Renegade on February 17, 2011, 01:40 AM

Quote from: timns on February 17, 2011, 01:31 AM
Can anyone compare EditPlus with EditPadPro please?

The features seem almost identical.

I prefer EditPlus. I have an EditPad Pro license that Jan gave me, but I still like EditPlus. I think EditPad Pro is probably a bit more powerful in some areas though. I find EditPlus is cleaner though. Maybe I'm just used to it though.

Jan writes THE definitive regular expressions program though -- PowerGREP. Very expensive.

Thanks! I have a powergrep license and it's paid for itself many times over. I'm tempted to go with his editor simply because he is Mr RegEx!

I'm getting too old and impatient to download all these trial versions of 10 different programs that purport to do the same thing. Thank goodness folks on here have such useful opinions... at least I can weed out the real pups in advance

Oh, and sorry about going completely off-topic

wraith808 · « **Reply #31 on:** February 17, 2011, 02:03 AM »

Quote from: timns on February 17, 2011, 01:29 AM

This thing helps considerably:

Regex Buddy

^ That's what *I* swear by... great app!

superboyac · « **Reply #32 on:** February 17, 2011, 02:11 AM »

I'm guessing that Regex Magic is more appropriate for a newbie like myself.

timns · « **Reply #33 on:** February 17, 2011, 05:13 AM »

Yes and no. Yes, to keep your life simple since you can easily put together a RegEx that works, but perhaps without really understanding what it is you've done.

If you'd like to really get into RegEx a bit, the Buddy is nice since you'll pick up a decent bit of knowledge due to the way it explains the component parts of the expression.

If you're interested in playing with some RegEx, please start a thread - sounds like there are some real experts on here, and I'd be interested in following along too

Author Topic: What's the best SQL software for writing queries? (Read 21,041 times)

timns

Re: What's the best SQL software for writing queries?

Renegade

Re: What's the best SQL software for writing queries?

timns

Re: What's the best SQL software for writing queries?

Renegade

Re: What's the best SQL software for writing queries?

Renegade

Re: What's the best SQL software for writing queries?

timns

Re: What's the best SQL software for writing queries?

wraith808

Re: What's the best SQL software for writing queries?

superboyac

Re: What's the best SQL software for writing queries?

timns

Re: What's the best SQL software for writing queries?