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.
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
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.
Databaseworkbench - does everthing - SQL Developer's heaven
I guess you are looking for AnySQL Maestro
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).
I like IBExpert for Firebird (or Interbase). They have a free personal edition.
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.