List of MySQL Sidu Features
MySQL Sidu has and planned to have all features which you found in phpMyAdmin or software like SQLyog.
In addition, sidu has some extra features that you might not find in other MySQL clients, such as:
Quick view of some of the features
- MySQL Sidu can group tables by first x chars of table names, and which you can control freely;
- Data result can be sorted in 1 column or 2 columns, which you can switch to your favorable mode;
- Table list of a database can also be sorted and filtered;
- Sidu can connect to MySQL servers locally and remotely, with the ability to save your connections on the server;
- As sidu is working on the web, there are several security controls to protect the data from un-authorized accesses;
- Sidu is working for multiple users and multiple sessions at the same time;
- Manage MySQL access tables easily with "GUI".
- Empty, drop, export or change engine of tables at one click.
- Smart data import to make your database admin merrily.
What's new in Sidu v2.4
- Sidu v2.4 improves css
- Left menu: you can now choose to click on table desc or table data
- Main window, data or SQL result window, now can be detached
- Fixed some broken hotkeys
MySQL Sidu Change Logs
MySQL Sidu now gets a handful list of features that make your web development or database admin job easier. Please also read the change log and screenshot pages for a quick view.
Full list of Main Features of MySQL Sidu
- DB tree view: tables can be grouped by first x chars of table name
- DB list can be filtered by last-updated for easy export
- DB list or table data can be sorted by 1 field or 2 fields
- DB list, table data or SQL result can be displayed in grid or text mode
- DB list can be displayed in brief or full info mode
- Table data can be filtered and columns can be disabled from displaying
- Table data column grid resize by click on the end of each column heading (This might be improved in the future version by mouse drag)
- Table data can be selected from a list if enum
- Table data display by limit or click on first|back|next|last page arrows
- Add multiple new data rows, or edit data, and then save at one click
- Delete multiple rows at one click
- Run selected SQL, or run all SQLs
- Show|Hide window pannels: DB tree, SQL window, or data result window
- View SQL history, then delete those un-wanted
- Connect to MySQL server remotely or locally
- IP blocking from un-authorised access - not mysql IPs
- Connection from file saved on server
- Connection from direct input
- Connection: new, switch, close
- Sidu user management - add, edit, delete, list user. Change password. Edit IP
- Sidu Globla IP Control
- Short-hand SQL templates
- Show mysql server system values, system variables
- Flush: logs, hosts, privileges, tables, status, cache, ...
- Export data from DB|Table|SQL to html|txt|sql -- powerful
- Table: create, drop, empty, export, analyze, change engine, optimize, ... at one click for bulk tables
- Easy to remember hotkeys provided to work without a mouse
- Import sql|csv data quickly into single table or tables of a DB, using bulk insert mode to speed up the transaction or use update mode to update tables in another DB
Brand new SIDU v3.0 in the future
- The following features currently run in SQL:
- DB: create, delete, copy
- Table columns: rename, reorder, delete, add
- Table index: edit, add, drop
- SIDU 3 PLAN
- Should Sidu support NULL value?
- Should Sidu support charset?
- Should Sidu support postgrel SQL?
- Should Sidu abandon folder /user and introduce USB connection?
