AeroSQL 0.9.2

AeroSQL

AeroSQL is an open source (GPLv3) web based tool for managing MySql servers written in PHP. AeroSQL is a professional PHP database project. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications.

The grid is editable: you can update cells and save the changes to the backend database server. For now, the query browser represents the main functionality. Additional features will be added in the next versions: administration tools (backup, restore), database object management (create tables).

Key Features of AeroSQL:
- Multiple servers administration;
- Live Queries: if a SELECT is performed on a single table and the result contains a unique index, AeroSQL will let you update the result set, i.e. the result is not read-only; (The unique index with the mininum number of columns is used. If a table doesn’t have a unique index at all, ALL the columns are used as an index.)
- Sql Monitor: view all SQL commands issued by the server side script;
- Multi query execution: you can run a batch of sql queries delimited by a semicolon;
- Correct handling of NULL values;
- The user can select which columns to display while editing a database table. Subsequent navigation through table rows will fetch only visible columns, thus minimizing network traffic;
- AeroSQL will provide column editors based on mysql data type:
. ENUM columns are represented by a combobox;
. TEXT column editor is a separate window with a TextArea and a WYSIWYG HTML editor;
. Numeric columns will not allow you to enter letters. Even negative numbers are disallowed if the column was defined as UNSIGNED.
- Easy to use web interface based on ExtJS framework.

License type: GPL
Date added: 3 years, 5 months 29 days ago | Last updated: 3 years, 4 months 6 days ago

More popular Database Management

Listing Files

i
  • logo_php.gif
  • 1.6 KB
  • 04/27/2009 10:47:22
  • null.png
  • 140 Bytes
  • 03/31/2009 12:23:06
ico
  • gear.png
  • 721 Bytes
  • 01/16/2009 13:25:00
  • disk_blue.png
  • 470 Bytes
  • 03/30/2009 23:18:28
  • table_off_lighting.png
  • 703 Bytes
  • 04/13/2009 15:37:48
  • table_medium.png
  • 386 Bytes
  • 03/08/2009 21:28:34
  • database_medium.png
  • 359 Bytes
  • 03/08/2009 21:19:04
  • key_lg_exclamation.png
  • 708 Bytes
  • 03/08/2009 23:59:10
  • document_lighting.png
  • 603 Bytes
  • 04/12/2009 20:41:34
  • table_medium_lighting.png
  • 544 Bytes
  • 04/13/2009 10:15:00
  • globe.png
  • 849 Bytes
  • 01/29/2009 11:55:00
  • pencil.png
  • 487 Bytes
  • 01/16/2009 13:25:00
List All Files