Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I sometimes need to modify url in big sql files. I usually open it up in some editor and do search and replace. On windows machine notepad++ works perfectly, it never hangs and feels snappy to show blocks of text. Now on my mac I cannot get anything to work properly! I have smultron 4 and it is sluggish. Any good software you recommend?

I imagine command line would be easiest with grep. But really do I have to mess with complicated syntax of grep or find to do this?

share|improve this question
Why are you making changes to the file and not directly to the database? – Dean Jul 17 '12 at 10:35
@Dean because you need to keep version control or it is test data – Mark Jul 17 '12 at 10:37
up vote 2 down vote accepted

If you want something similar in style and power to Notepad++, try using Sublime Text 2.

This is cross-platform (based on Python) and has loads of community supplied add-ins to make it a very powerful IDE and development platform.

The only disadvantage is that it isn't totally free - it pops up a reminder to purchase every few dozen saves.

This is now my chosen IDE and text editor.

It is perfectly happy with very large files and even has a graphical map of the file if you want to use it for navigation.

share|improve this answer
While it won't hang, sublime text 2 still takes a while to load the entire file before it will allow you to view/edit it (Notepad++ displays the file instantly while it's loading it). Still the best editor out there though, worth every penny for me. – Darth Android Jul 17 '12 at 14:24
Thanks for that clarification, you are correct. – Julian Knight Jul 17 '12 at 16:14
I've seen sublime text 2 before. But 50$ price turned made me walk away. I didn't know they had free version, I'm trying it out... it looks amazing. – Sandro Dzneladze Jul 17 '12 at 21:21
I agree that the price is rather high but he doesn't make a big thing of the free use and it is per user so you can use it on as many machines as you like. – Julian Knight Jul 18 '12 at 13:38

Choose your poison

Aquamacs puts the Mac in Emacs
Vim (Vi IMproved) for Mac OS X

share|improve this answer
vim is nice, loved it on ubuntu server. But binaries for mac has not been updated since 2007 on :( – Sandro Dzneladze Jul 17 '12 at 20:25
You could always use pure vim built from source – Nifle Jul 17 '12 at 21:15

TextWrangler is a great free text editor.

share|improve this answer
I've used it before, but it didn't stick... something about graphics wasn't right, I just didn't like feel of it. – Sandro Dzneladze Jul 17 '12 at 20:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.