Lightning Admin

Lightning Admin is a 32 bit IDE for MySQL 4.1+ and PostgreSQL 7.4.x and higher. Its interface allows access to the complete set of MySQL/PostgreSQL features.

Features include:

- Administer MySQL/PostgreSQL databases on any OS including Solaris, BSD, Linux, Win32

- IDE style editors for functions, queries and views

- Function version control

- Tabbed MDI (multiple document interface) style interface that works similar to a word processor

- The editors feature full code completion, parameter hints, and full syntax highlighting

- The editors have full drag and drop editing, and will accept drag and drops from the databases schema tree view

- Tabbed based enterprise manager, each database and its schema is opened in its own tab

- Built in SSH tunnel capability

- Filtering MDI tabs. When a database is selected/opened, the MDI task bar only shows open objects associated with that particular tab

- Full backup and restore capabilities

- Query Editor is threaded and allows long running queries to be canceled

- GUI Query Builder, accessed from the Query Editor's menu bar

- Query Editor keeps a log/history of executed SQL queries

- Query Editor saves its contents and restores the next time you open the editor

- Query Editor has a temp table watch window

- Full printing of DDL/Metadata and results sets

- Print preview allows the displayed data to be printed or exported as PDF, Word, Excel etc.

- All Data grids are sortable and show a sort arrow in the column header

- All Data grids have a form view

- All Data grids have full import/export capabilities such as comma/custom separated, tabbed or fixed width. You may export to the clipboard or a file

- The query data grid allows the result set to be filtered

- Quick View table view which will bring the the top rows of a table or all rows

- Grid based Grant Manager that supports the with grant option

- Server status monitor that allows queries running through the backend to be captured (command string must be enabled)

- Environment options allow many features to be customized by the user

- Field names can be copied to the clipboard

- Dependency viewer

- View and edit the postgresql.conf and pg_hba.conf files

- Remotely reload the server's configuration files

- Blob Viewer (bytea)

- Import/Export Wizard

- Unicode enabled query and function editors