views:

1615

answers:

10

Simple question. I'm considering Firebird and SQLite for an upcoming project. SQLite has SQLite Administrator, which is pretty good but gets +1M because it has autocomplete. But Firebird supports FKs, so I'm more comfortable with it. I'm leaning toward Firebird right now.

What is your favorite Firebird IDE and why?

Edit: Personally, I'll be gravitating toward the free ones because I'm not making much on this project. But I'll leave the question as is.

+2  A: 

I have used the free version of EMS SQL Manager. It is a great IDE with all the features I ever need and compares with something like Management Studio for SQL Server. Link

Craig
I spent about 20 mins looking at this one, stopped when it couldn't create a database: "can't find procedure isc_dsql_execute_immediate fbclient.dll". Not saying it's bad, but if it encounters a critical issue that soon, I'm gonna move on to the next one.
jcollum
That error message isn't exact, it's what i typed in to google when I hit the fault. Didn't find anything on google about it. Tried the other dll and got the same fault.
jcollum
+2  A: 

I can suggest you Firebird Maestro. It's not free but what you get for the price of a license is a very good product, especially because you can perform most of your tasks visually.

Stefano Driussi
+10  A: 

I like IBExpert for Firebird (or Interbase). They have a free personal edition.

Ray
The only one that's complete at this time and worked. But I didn't test it thoroughly because I decided against FB.
jcollum
+2  A: 

Aside from an IDE for Firebird, you may want to take a look at Sinática Monitor for Firebird.
It's great for finding bottlenecks.

Douglas Tosi
+8  A: 

I would not want to enter it into a contest for best Firebird IDE (yet), but you could look into FlameRobin for a free multi-platform administration program for Firebird. It has auto completion, starts as fast as no other GUI tool I know of, and the price should be right for you.

mghie
FlameRobin ins't better than IBExpert.
O Engenheiro
+1  A: 

FlameRobin is simple, easy to use, and has a small footprint. Additionally, it's free.

Cyprus106
+5  A: 

Databaseworkbench - does everthing - SQL Developer's heaven

+2  A: 

Test all this !

For me the best is IBExpert and after Database Workbench because they have stored procedure debugger

(*) means free or have free version (personal...)

Hugues Van Landeghem
A: 

wow these ar new to me fireface and kevora , i will add them to firebirdnews.org

you're new, so i'll give you a tip: if you can answer the question, put it in an answer; if you just have a comment, put it in the comments section. You'll get downvotes for answers that aren't.
jcollum
A: