Big Data IDE (formerly Database Editor)
Database Editor is a handy application with a self-explanatory name. It is designed to assist administrators and software developers in browsing database contents, editing its structure, adding objects, building queries and generating reports.
The main interface is well organized, providing fast access to all the database connections and placing all the tools and options at your fingertips. The application provides support for multiple database types, including MySQL, Access, PostgreSQL, SQLite, SQL Server, Oracle, DB2, SQL Azure, Sybase and Interbase.
All the connections are stored in a single place and the 'Connection Wizard' is designed to guide you through all the necessary steps of creating new ones.
With Database Editor, you can easily generate SQL scripts and create objects for the database schema, such as procedures, sequences, tables, views, triggers, functions, schemes, indexes, synonyms, packages and more.
Designed to help you view and edit the database structure, the built in SQL editor features syntax highlighting, code completion, query history, enabling you to easily re-execute a query when necessary. The generated SQL queries can be saved as templates and used at a later time.
Database Editor provides you with a built-in database formatting and refactoring tool, which comes in handy for automatically making modifications in the code (for instance, locate unused parameters) in order to improve the overall database performance.
The built-in report creator can be used for generating simple reports from queries and save them to your computer, while the version control feature enables you to save SQL scripts into repositories, such as SVN, Bazaar, Git or Mercurial.
ODBC configuration tool, importing and exporting capabilities, DDL script creation and the SQL script testing tool are other advantages that this application comes with.
To conclude with, Database Editor includes all the necessary tools for managing databases and creating SQL queries. Providing support for multiple connection types, it is a must have tool for any database administrator, especially since its functionality can be enhanced using plugins.