Tag: debian

[See remaining text…] 

• Create and drop database entities like tables, views, procedures, indices, domains, constraints, triggers, generators, etc.
• Powerful SQL Editor
• Perform SQL queries and view results in Unicode-aware GUI. Queries can be built by drag-and-dropping table columns in the SQL editor.
• Manage several server connections
• Perform queries on system tables RDB$xxxx (system tables)
• Manage database rights
• Get the DDL as text for automated table creation.
• Event monitoring. You can subscribe to one or multiple events and control when and how many of each event happened in the database.
• Create all the TABLES, DOMAINS, CONSTRAINTS, USERS, TRIGGERS, PROCEDURES etc, needed for database functionality.
• FlameRobin always displays the SQL statement it’s going to run, so you always know what is happening in your database and no under-the-hood mechanism obscures your actions.
• Editable data grid, you can modify existing data inside the grid and also add and remove rows. Blob values can be updated from files.
• FlameRobin can have multiple log files for a given database, one for each statement, making it easy to build update scripts for production databases.

Using Firebird and FlameRobin included in Debian it is possible to backup a database from Windows, restore it on Linux and take off SQL server load from workstation. This is the only way to move database between 32-bit and 64-bit architecture. It is a feature of Firebird (or maybe bug). On the same architectures database files can be simply copied.

The SQL Editor has syntax highlighting and auto-completion. SQL statements can be entered, load, saved and executed. You can prepare a query and view the execution plan without executing it.

Availability

FlameRobin is available in Debian since Etch and in Ubuntu since feisty.