Firebird: Showing constraints / Client for Mac OS X

Dev Shed Forums Sponsor:

May 31st, 2011, 12:37 PM

polarpro

Registered User

Join Date: May 2011

Location: Munich, Germany

Posts: 3

Time spent in forums: 27 m 17 sec
Reputation Power: 0

Firebird: Showing constraints / Client for Mac OS X

Hey,

I am looking for an SQL client that works with Firebird on Mac OS X.

I tried RazorSQL, and it works quite well; unfortunately, constraints are not displayed in full detail. Or am I missing something? I only get the names of the constraints, but not the details like check(Field01 > 0)

Under Windows I use IBExpert, but this doesn't run under Mac OS X.

Thank you for your input,
Mike

May 31st, 2011, 01:13 PM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,684

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 42 m 19 sec
Reputation Power: 284

Check out SQL Workbench, it's Java based and runs well under MacOS

http://www.sql-workbench.net/

May 31st, 2011, 05:11 PM

polarpro

Registered User

Join Date: May 2011

Location: Munich, Germany

Posts: 3

Time spent in forums: 27 m 17 sec
Reputation Power: 0

Hey Shammat,
Thank you for your response.

I managed to get SQL Workbench going, but it seems as if it provides the same information like RazorSQL. As for constraints e.g., I cannot gather all the information that has to do with the constraint (mainly the name is provided).

June 1st, 2011, 01:04 AM

shammat

Contributing User

Join Date: Oct 2003

Location: Germany

Posts: 2,684

Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 42 m 19 sec
Reputation Power: 284

Quote:

Originally Posted by polarpro

I managed to get SQL Workbench going, but it seems as if it provides the same information like RazorSQL. As for constraints e.g., I cannot gather all the information that has to do with the constraint (mainly the name is provided).

It does display the name of the constraint for me, e.g. for the following table

Code:

CREATE TABLE CHECK_TEST
(
   ID  INTEGER
   ,CONSTRAINT CHECK_POSITIVE check (id > 0)
);

Maybe you should post that question to the support forum that's listed on the homepage

June 1st, 2011, 06:41 PM

polarpro

Registered User

Join Date: May 2011

Location: Munich, Germany

Posts: 3

Time spent in forums: 27 m 17 sec
Reputation Power: 0

Yes, it displays the name, but not the actual details that build a constraint (e.g. the calculation that defines allowed values).

Well, I decided to use PostgreSQL instead. With PostgreSQL comes an interface that lists all I need, and it runs well on a Mac.

Thanks again for your help;
Mike

Firebird: Showing constraints / Client for Mac OS X

Developer Shed Advertisers and Affiliates