18

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.

jcollum
  • 43,623
  • 55
  • 191
  • 321
  • all: it'll take me a while to come up with an answer for this one, be patient. – jcollum Jan 29 '09 at 16:52
  • https://www.ibphoenix.com/download/tools/admin this is from the firebird official site. there are 15 ide with their capability described shortly . some can do backup restore. some can modify table scheme – bh_earth0 Apr 10 '19 at 07:49

9 Answers9

17

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
  • 6,755
  • 3
  • 34
  • 59
  • To complemlement the list. HQBird Enterprise is said ti include some "SQL Studio" https://ib-aid.com/en/hqbird-features and there is one from SQLLY https://www.sqlly.com/ and there is RedExpert at https://reddatabase.ru/en/products/ – Arioch 'The May 05 '23 at 12:39
  • Official (?) IDEs list - https://firebirdsql.org/en/third-party-tools/ – Arioch 'The May 05 '23 at 12:40
14

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

Ray
  • 45,695
  • 27
  • 126
  • 169
  • 1
    The only one that's complete at this time and worked. But I didn't test it thoroughly because I decided against FB. – jcollum Feb 04 '09 at 22:34
10

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
  • 32,028
  • 6
  • 87
  • 129
7

Databaseworkbench - does everthing - SQL Developer's heaven

3

I guess you are looking for AnySQL Maestro

  1. Freeware
  2. Able to work with Firebird and SQLite databases at the same time

The producer also offers a tool for SQLite (SQLite Maestro) that SUPPORTS FOREIGN KEYS (with referential integrity triggers) but it has only 30-day free trial (costs about $70).

3

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
  • 36,306
  • 34
  • 114
  • 197
  • 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 Feb 01 '09 at 18:54
  • 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 Feb 01 '09 at 18:55
3

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
  • 2,241
  • 1
  • 14
  • 19
3

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
  • 2,310
  • 2
  • 18
  • 18
2

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

Cyprus106
  • 5,722
  • 6
  • 40
  • 48