Database Tools

From Visual Basic to GNU C, this is the place to talk programming.

Moderators: SecretSquirrel, just brew it!

Database Tools

Postposted on Tue Feb 24, 2009 11:35 am

Well, as I get deeper and deeper into Web site development, I keep finding neat little tools. Aside from Linux -- I bet you can't guess what my favorite distribution is --I've found nifty tools to manipulate the server so far that are within my budget: free. Also, they support my database of choice: PostgreSQL.

pgAdmin III is an excellent GUI for administrating a database. Now, I'm not an old hand at SQL, so this makes doing simple things very easy for me, but it still lets me know what SQLS it'll run or has run to do whatever operation. It wasn't so handy in the design of a database, and it's documentation is a bit lacking.

DbSchema is an excellent GUI for designing a database. Whereas I had been using pencil and paper because I haven't been able to find a single tool capable of doing things as neatly as I can on paper, this tool does a much better job than what I can do and it can create the whole database for me. There are some things that it does not do well. For instance, I have a a foreign key in table_2 that references table_1. DbSchema will, for some unknown reason, try to create table_2 before creating table_1. Obviously this will fail as PostgreSQL will raise a sign saying, "Um, I can't make this table refer to another table that doesn't exist." Also, there are some speling errros. (How is dinamically spelled wrong?) With a little ingenuity on my part, however, the work around is to just sync the elements individually to avoid any trouble. The documentation, however, is very thourough and easy to understand, even with its splliing erooors.

These two tools together create a complete package for me so far. I haven't gotten very far along in my database development, so I'll have to let you know of any further limitations I stumble upon. Really, though, it has been so difficult for me to find tools that utilize PostgreSQL instead of MySQL. (Google has been great at finding tools, just not within my budget.)

As for the actual Web site, Bluefish has been the best I've come across. It is closer to a glorified text editor than it is to a development environment. It has it's own limitation, such as not supporting multiple syntax highlighting schemes simultaneously completely and not so great documentation. For example, I may have in one file XHTML, CSS and PHP, with the CSS within the style tags. The XHTML and PHP will have proper highlighting, but the CSS will not. Bluefish is very fast and lightweight, however, which is what makes it closer to a text editor than the development environments I've had experience with so far. It will start within seconds on my aging Athlon XP-M 2400+. (NetBeans keeps crashing on me or won't start. Not a good work environment for me.)
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains

Re: Database Tools

Postposted on Tue Feb 24, 2009 11:38 am

Phpmyadmin is the only one that I've used personally with MySQL.
Usacomp2k3
Gerbil God
 
Posts: 21323
Joined: Thu Apr 01, 2004 4:53 pm
Location: Orlando, FL

Re: Database Tools

Postposted on Tue Feb 24, 2009 11:43 am

Usacomp2k3 wrote:Phpmyadmin is the only one that I've used personally with MySQL.

I've used that too. pgAdmin III, in my experience, is much quicker than Phpmyadmin, but I would say they're equally as useful.

What I would like is a tool similar to php-syslog-ng. Php-syslog-ng only works with MySQL, and I'm not confident enough to fiddle with it to make it work with PostgreSQL.
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains

Re: Database Tools

Postposted on Tue Feb 24, 2009 11:48 am

Another phpmyadmin user here. I haven't looked much at the alternatives.
lordT
Darth Gerbil
 
Posts: 7426
Joined: Fri Nov 25, 2005 2:11 pm
Location: Writing

Re: Database Tools

Postposted on Sun Mar 08, 2009 4:52 am

What's the best free SQL database management tool (for Microsoft SQL Server 2005) for Mac? I'm using Microsoft SQL Server Management Studio Express on my PC, I'm hoping there is a similar free tool I can get for my Mac.
kayanat
Gerbil In Training
 
Posts: 1
Joined: Sat Mar 07, 2009 2:21 am

Re: Database Tools

Postposted on Sun Mar 08, 2009 2:39 pm

kayanat wrote:What's the best free SQL database management tool (for Microsoft SQL Server 2005) for Mac? I'm using Microsoft SQL Server Management Studio Express on my PC, I'm hoping there is a similar free tool I can get for my Mac.

It depends on what sort of "management tasks" that you are talking about. For stuff like creating tables, running queries, etc. I would say a lot of database tools can do that. If you need more then I would suggest to use virtualization and put a guest copy of Windows on your Mac (VMware Fusion, Parallels). VirtualBox is free so other than the cost of the Windows licence, you just need the free SQL Server Management Studio Express and you are all set.
Image
The Model M is not for the faint of heart. You either like them or hate them.

Gerbils unite! Fold for UnitedGerbilNation, team 2630.
Flying Fox
Gerbil God
 
Posts: 24576
Joined: Mon May 24, 2004 2:19 am

Re: Database Tools

Postposted on Sun Mar 08, 2009 2:49 pm

MS SQL Server Manager for me. Does everything I want, and probably a lot more than I don't know or don't need - yet.
Corsair 600T | ASUS P8P67 PRO | Intel 2500k @ 4.4Ghz | EVGA 560 TI | G.SKILL Ripjaws Series 8GB | Corsair HX650 650W
steelcity_ballin
Gerbilus Supremus
Silver subscriber
 
 
Posts: 11924
Joined: Mon May 26, 2003 5:55 am
Location: Pittsburgh PA


Return to Developer's Den

Who is online

Users browsing this forum: No registered users and 1 guest