Slashdot Mirror

http://www.navicat.com/en/products/navicat_pgsql/pgsql_overview.html
http://www.sqlmanager.net/products/postgresql/manager

In spite of this, I use mysql.

It allows vendors to make apps available on Linux with minimal effort. I use the Linux version of Navicat[1] as my main MySQL interface on the desktop and it comes wrapped with a its own stand-alone version of Wine. It's slightly slower to load than a native app and, annoyingly, doesn't support middle click paste in X, but it's still miles ahead of rebooting or running up a VM just to use one program.

1. http://navicat.com/linux_detail.html

By the way, there is a WYSIWYG editors for both mysql and postgres that handles triggers..

http://www.navicat.com/

If I HAD a problem with it I wouldn't use it. I know this will shock you to the core, but, for what I use Microsoft products for, they serve me pretty well. My games work, I seldom need to reboot, I have 15 applications open, and the machine's not crapping itself.

I'm working on a Windows machine right now, and the most troublesome piece of software I use on it is fricking FIREFOX, and I am actually considering boycotting it...To the point that I've actually bothered to download the new version of Opera for the first time in god knows how long.

Right now I'm running Eclipse, Putty(x4), Navicat, Reflections, Dreamweaver, MS Management Console, MySQL Query Browser(x2), Outlook, Firefox, and Access 2003. Nothings causing me any problems, I'm on top of all my systems, and I'm satisfied...If I wasn't I'd be using something else.

Apparently though, I'm some kind of intellectual traitor for not being miserable, and not boycotting all these products that aren't making my life a living hell, just because a zealot thinks I should. And yes, if you decide that my using Windows software is symptomatic of the moral decline of the US you're undoubtably a zealot.

People like me, who are comfortable dealing with open and closed source software do more for OSS and the free software movement than all the hairy fanatics who equate closed source with all the evils of the world. If you can't even appreciate that there are legitimate reasons why people use closed source products instead of their OSS competitors, you are NEVER going to create a superior OSS product because you have absolutely no idea of what the POINT of the product actually IS.

I use Navicat for MySQL and I really like it. They make a PostgreSQL version too
http://pgsql.navicat.com/

there's actually a quite nice GUI for PostgreSQL it's called Navicat PostgreSQL http://pgsql.navicat.com/
Maybe a little more research would helped :D

Sorry about the "free" part, but Navicat is the best MySQL interface that I've seen to date, and I've tried quite a few (not all of them, obviously :)

Well if you're looking for good management tools, I can recommend two EXCELLENT ones that have all the support I need depending on budget:

Lower end budget - SQLYog
I heard about this bad boy from a review in phpArch and after spending a few days with the demo, shelled out the less than $100 dollars for the product. It's been a life saver.

Higher end budget - Navicat
They bill themselves as the most popular. While I'm not so sure about that, they do have the best cross platform management tool out there. My company is using this one.

Then again his original post has nothing to do with management and everything to do with client side - think LAMP but in an OS/X gui.

I've been struggling with this same question myself for the past few days. I've finally migrated all the disparate spreadsheets in our company into various mysql databases. Excel is pulling the data from mysql over odbc.

Now comes the point where I need to provide tools for various end-users of various end-user skill levels to modify the data. Short of writing my own application, there really isn't anything like FileMaker or Access in the opensource world. Everyone says to write a webapp but I simply don't have the time. I've got too many systems and a linux migration to deal with right now. Couple that with 1 hour internal help desk hold times and we stay busy.

The sad thing about it all is that I'm currently working on the previously disavowed LAMP application. The only thing saving me from pulling my hair out is that I've got an application framework that I always start with built around smarty and adodb. I just hate designing the frickin interface ;)

OpenOffice
Crimson Editor (programmer's editor; free, not open source)
Audacity (WAV editor)
CDex (ripper)
Firefox
Thunderbird
Navicat (MySQL admin tool)
MySQL Snap (MySQL backup tool)
Top Style (CSS Editor)
Photoshop (Gimp ain't ready for primetime yet. Sorry.)

That's 10. Next up: WinAmp, WS-FTP, AdAware, and 17 million IE/Win patches.