What's new / TODO
Download SIDU 2023.0707 - 2023.07.07
sidu2023.zip - 271k (276,490 bytes): Download now
md5: b0b1191455e76ee5cdbbdf0c5b319d25
Available languages: English, Chinese (中文)
What's new in SIDU 2023.0707
- Fixed: PHP8 compatible
- Added: PgSQL icon on browser tab
- Added: Abbr name of each connection on browser tab
Download SIDU 2023.beta - 2023.03.03
This is a testing version only
sidu2023beta.zip - 270k (276,471 bytes): Download now
md5: d7ada17a57dd6f7ae9621d1c90a892a5
Available languages: English, Chinese (中文)
Download SIDU 6.3 - 2021.09.19
sidu63.zip - 272k (277,668 bytes): Download now
md5: 4cdb2e2b4c96633f68cba73f64d65749
Available languages: English, Chinese (中文)
What's new in SIDU 6.3
- Added : MySQL tab data foreign key click to go to reference table
Download SIDU 6.2 - 2021.09.09
sidu62.zip - 271k (277,409 bytes): Download now
md5: 1931dd7673651b815e054d25521f38e1
Available languages: English, Chinese (中文)
What's new in SIDU 6.2
- Upgraded : menu group eg users and user_ to be user
- Upgraded : Topnew\Chart v 2019 plugin
- Fixed: DB/table name etc contains dot need quoted
- Fixed: SQLite3 SQL result no table head
- Fixed: SQLite3 tab default value remove quote
- Fixed: PostgreSQL 12.3 sequence values not complete
- Fixed: PostgreSQL 12.3 col stat bug for odd types
- Fixed: PostgreSQL 12.3 col default value missing
- Fixed: PostgreSQL 12.3 tab header missing
- Fixed : SQL Chart serial name missing bug
- Fixed : MySQL 8 user management
- Fixed : MySQL 8 user grants -- seems SQL-92 no longer valid for grant all previleges?
- Fixed : MySQL 8 Flush All bug -- remove 2 not supported by My8
- Added : Click on history to copy to clipboard, or to run
- Added : SQL run json into table result started with /*SIDU_JSON*/
- Added : SQL run CSV into table result started with /*SIDU_CSV*/
- Added : Memory usage for each SQL
- Added : Bulk remove col default charset collate per table
- Added : Bulk alter table default charset collate per db
- Added : MySQL tab desc SQL helper alter charset collate
- Added : Homepage sum of storage etc stats
- Added : Export custom file name
- Added : MySQL login add utf8mb4 support
Download SIDU 6.1 - 2019.09.09
sidu61.zip - 276k (275,810 bytes): Download now
md5: 3a0283bdb4eaa02b1c586f988ec27da6
Available languages: English, Chinese (中文)
What's New In SIDU 6.1
- Fixed Login Cookie crashes - otherwise you can also clear cookies
- Improved UI Data Select scrollbar-x CSS
- Add MySQL tinyint(4) cleanup in Table Desc
Download SIDU 6.0 - 2018.06.06
sidu60.zip - 277k (276,788 bytes): Download now
md5: ffc30e7b0317a6b42baf47c7116ca7e0
Available languages: English, Chinese (中文)
What's New In SIDU 6.0
- ADDed MySQL Foreign Key maps
- ADDED tree for menu db names. i.e. db name now be grouped eg 1_db1, 1_db2 ...
- ADDED mysql.information_schema.tables click on table name goto table directly
- ADDED support for SQL keyword as column name
- Fixed SQL result table header hover no column name
- Fixed tab add row keyword col broken eg `key`
Download SIDU 5.5 - 2017.05.05
sidu55.zip - 272k (272,754 bytes): Download now
md5: 6a7192962ee08ab9e0ca08be0fdaa0bd
Available languages: English, Chinese (中文)
What's New In SIDU 5.5
- Tab data edit add multiple select for set datatype, and datepicker for date
- Data add json view mode, export to json format.
- Export add js to show dynamic conditions on selection.
- Add SIDU log to table features
- Improved MySQL user management
- MySQL 5.7 user.Password, sys.view.$view in menu tree.
- Fix some warning msg in PHP 7.0 and 7.1
Download SIDU 5.5 beta - 2017.02.28
sidu55.beta.zip - 275k (275,004 bytes): Download now
md5: 76d71f1c5d9abc6e11c1f8a32f9cc8de
Available languages: English, Chinese (中文)
What's New In SIDU 5.5
- All code re-write and GUI re-designed
- SIDU 5.5 only support MySQL, PostgreSQL and SQLite
- Removed iframes, div frames are both click and drag resizable.
- Mobile friendly, no need to select SQL to run, will run SQL at cursor block.
- Run all / selected SQL as one SQL.
- Save history to sidu_log table.
- Apart from existing web hotkeys. There are new SIDU fn keys (Shift or Alt or Ctrl, no matter which you love) + click on menu tree object will open object in new window / tab.
- In database mode, click on search will search database object; in table mode, click on search will search table column within a database.
- Different database engine / host / etc, synchronise.
- Improved data import / export, adding new json format to export. Download unzipped files if zip driver not available. Increased export file size to roughly 50MB depending on actually server settings.
- Improved data grid more user friendly.
- Default to data text mode to improve speed.
- And too many more, discovered by yourself.
Download SIDU 5.4.3 - 2016.12.28
sidu54.3.zip - 285k (285,164 bytes): Download now
md5: 9210166d6ddda28bf49d47cfe8be594b
Available languages: English, Chinese (中文)
What's New In SIDU 5.4.3
- Fixed: keywwords contains hyphen or number all need quoted
- Added: Menu tree, active desc show red highlighted as well
- Added: Table data text view mode, add basic json view
- 修正: 数据库名,表格名等含有 - 或者数字,一律加引号
- 增加: 目录树对当前表格等对象显示红色
- 增加: 表格数据可以显示 JSON 格式
Download SIDU 5.4.2 - 2016.05.28
sidu54.2.zip - 282k (282,147 bytes): Download now
md5: 98bf6253828f2a22d57e68a655a6eb07
Available languages: English, Chinese (中文)
What's New In SIDU 5.4.2
- Fixed Bug in menu tree for PHP5.3: mysqli
Download SIDU 5.4 - 2016.05.24
sidu54.zip - 282k (282,109 bytes): Download now
md5: 32a4a4caf871824c5a6a098e6aaac022 sidu54.zip
Available languages: English, Chinese (中文)
What's New In SIDU 5.4
- Show menu tree by default
- Menu tree link on click show color
- Menu tree removed deprecated MySQL 5.0 version check
- MySQL connect default to utf8
- Table desc add {null} info if default is null
- Add automatical login so that you can goto your target page without connection page, eg:
http://mysite.com/sidu54/conn.php
?conn[host]=localhost
&conn[user]=dbuser
&conn[pass]=dbpwd
OR &conn[pass]=xh45...EncrypedPassword..xldl&conn[penc]=1
&conn[dbs]=mydb
&conn[eng]=PDO_mysql
&conn[char]=utf8
&cmd=Connect
&url=tab.php
&id=1,mydb,0,r,mytab
will bypass the connection page and goto table data page directly, which can be iframed into your webpage for special use.
- Since chrome has fixed a bug, SIDU conn page use js-encrypt password by default
- Deprecated two hotkey: LoadSQL Temp, which will be removed from 5.5 as they are not supported by Ubuntu + Firefox
- Show server, PHP, database info on homepage
- SQLite Export in multiple inserts instead of one insert per line.
- SIDU 5.4 using Topnew SVG Chart instead of Topnew bChart
- Upgrade export csv: double quote no need if there is no comma in data, and double double quote when needed.
- Licence changed to MIT
- 默认显示数据库列表,加亮显示选择
- MySQL 默认 utf8 链接
- 表单字段默认值 {null} 显示
- 自动登入 SIDU 功能
- 首页显示服务器基本参数
- SQLite 每行导出多行数据
- SIDU 5.4 使用 Topnew SVG 图表
- 数据导入更新
- 改用 MIT 授权
Download SIDU 5.3 - 2015.05.25
sidu53.zip - 315k (315,609 bytes): Download now
md5sum: bd597fc5082dc668a2b633ac641a6464 sidu53.zip
Available languages: English, Chinese (中文)
What's New In SIDU 5.3
- Fixed possible hole for XSS attacker
- 修补 XSS 攻击漏洞
Download SIDU 5.2 - 2015.05.02
sidu52.zip - 315k (315,741 bytes): Download now
md5sum: 417aa398e678142cc705e98d1d3e4f7d sidu52.zip
Available languages: English, Chinese (中文)
What's New In SIDU 5.2
- Change: connection: turn off salt time limit at 8sec checking as some server does not keep salt cookie at all?
- Change: seperate MySQL and PostgreSQL keywords
- Add: sort by Field name or column Type for table desc
- Fix: count(*) not shown for some table stat, not sure if it is a php bug
- Add: menu tree sort: wp_ and drupal_
- Export as csv: always one line per row; always double-quoted data if it is text; turn off some commends
- Import: ignore x lines at head, y lines at foot
- Import: use str_getcsv() to import csv correctly, original import remains when delimiter is more than 1char
- Turn off toolbar rotate, as tablet not ready yet
- Turn off big toolbar
- MySQL view def, clean basic schema name if within same.
- History display in text mode instead of table to fit well in smaller screen. also able to re-run the sql in history
- CodeMirror plugin for SQL keyword highlighter
- Save and download contents in SQL window
- Fixed: XAMPP inc.page.php $lang
- Fixed: MSSQL connect using dblib
- Fixed: PDO pgsql pg_attribute.attnotnull=1/ instead of t/f
- Add: Import/Export clean data:
\r\n,\\r\\n,\n,\\n » newLine
\t,\\t » TAB
\",\\\",\\\\\\" » "
\",\\\",\\\\\\" » "
- 数据库结构可以按照字段名字或类型排序
- 更新数据导出导入CSV模式
- 点击历史重新运行SQL
- SQL窗口关键字加亮显示
- 改进SQL加载保存
- 更多更新请看英文版说明
What's New In SIDU 5.1 - 2013.10.15
sidu51.zip - 303k (303,158 bytes): Download now
md5sum: 15c38410729613fc6e203fe2a4c4cfec sidu51.zip
Available languages: English, Chinese (中文)
What's New In SIDU 5.0 - 2013.10.13
sidu50.zip - 303k (303,114 bytes): Download now
md5sum: 22325793cebba012f1068b04605d75cb sidu50.zip
Available languages: English, Chinese (中文)
- SIDU starts to add PHP PDO to support more database engines
- New: Database/table/data compare between 2 hosts or even 2 engines
- Fixed: menu tree list bug for 4.0 in CUBRID
- Fixed: PDO::rowCount() to display correct rows affected
- Removed: SQLite 2
- SIDU 开始采用 PHP PDO 支持更多的数据库引擎
- 新增: 不同主机,数据库引擎之间的数据库/表/数据对比
- 修复: 4.0 CUBRID 目录数显示问题
- 修复: PDO::rowCount() 无法正确显示结果
- 取消: SQLite 2 支持
What's New in SIDU 4.0 - 2012.12.22
sidu40.zip - 298k (298,018 bytes): Download now
md5sum: c84fe50e9b4ea6b080ea533591a5595a sidu40.zip
Available languages: English, Chinese (中文)
- Mobile/Tablet friendly: frame changed to iframe
- js dynamic password encrypted for http sites connection
- conn.php: dropped button: test, open conn file
- Fancy tool bar for tablet: rotate and size
- Improved tree view for log_y_m and pg_ objects
- 使用 iframe 确保平板电脑显示正常
- 使用js动态加密,保证 http 网站安全链接
- conn.php: 删除以下功能: test, open conn file
- 工具条可以旋转90度,以及放大缩小
- 改良目录树显示:log_y_m 以及 pg_
What's New in SIDU 3.7 - 2012.09.09
sidu37.zip - 211k (211,078 bytes): Download now
md5sum: 1edd16c88be1f48ee2cf0fc431788cb0 sidu37.zip
Available languages: English, Chinese (中文)
- Fixed: Chrome show DB object checkbox too small
- Fixed: cPanel: hide PHP warning MSG for MySQL admin user
- Fixed: Opera: SQL load window z-index not top enough.
- Plugin: disable SIDU admin for common users
- Plugin: save SIDU log into file
- Add: PostgreSQL show process list
- This is season 3 final as SIDU plan to go for tablet in 4.0
What's New in SIDU 3.6 - 2012.07.06
sidu36.zip - 210k (210,473 bytes): Download now
md5sum: 646aedde16caa1f23227c6ccd4024cb5 sidu36.zip
Available languages: English, Chinese (中文)
- Fixed: MySQL keyword used in column name, table desc mode stucked
- Fixed: IE9: table data add new row JS not working
What's New in SIDU 3.5 - 2012.05.05
sidu35.zip - 210k (210,481 bytes): Download now
md5sum: 94fca5a478703ef37a03e2bff231f09d sidu35.zip
Available languages: English, Chinese (中文)
- Core Code re-built ready to plugin any database engine listed on: http://au.php.net/manual/en/refs.database.vendors.php
- CUBRID is successfully plugged into SIDU 3.5
- SQL reserved keywords plugged into SIDU safety list
- Removed file size limits (max 2MB) for SIDU import and export, you can import/export any file size supportted by your server setup
- Upgraded sidu_fk table to handle meta tables
- Fixed a bug in object search in PostgreSQL
- Backslash issue fixed for any db any version
What's New in SIDU 3.4 - 2012.03.04
sidu34.zip - 202k (202,282 bytes): Download now
md5sum: af29b81b76ea54c03b5d71288b07fdca sidu34.zip
Available languages: English, Chinese (中文)
- SIDU 3.4 successfully connected to SQLite 3+
- SIDU 3.4 hides support for SQLite 2.* which is not deleted.
- SIDU 3.4 for postgresql 9.0 vs 9.1 -- \n to be or not to be
- SIDU 3.4 select fkey values: MySQL, Postgres, SQLite
- SIDU 3.4 speedup more on menu-tree for MySQL 5.0.2+
- FIXED -- Bug: data cbox can not uncheck
Download SIDU 3.3 - 2011.09.09
sidu33.zip - 195k (199,666 bytes): Download now
md5sum: 7fe43aa13a4e22253f90e13173bf2533 sidu33.zip
Available languages: English, Chinese (中文)
- Add MySQL user management GUI
- Add Enum select in data edit
- Start to use jQuery, and reduced 30% html code
- Improve menu tree loading speed, no scan by default
- To make SQLite understand \n \" \" etc same way as other database
- There have always been some bugs fixed
- Some GUI enhancements
- Improved blob editting screen
- Add object search for: table, column, view, function, etc
Download SIDU 3.2 - 2010.05.02
sidu32.zip - 145.3k (148,775 bytes): Download now
md5sum: b9c927c298d939c9a139961e0f2ab073 sidu32.zip
Available languages: English, Chinese (中文)
* Bug fixed: no database selected
* Bug fixed: postgres connection for normal user
2010.02.28 - SIDU 3.1
2010.01.30 - SIDU 3.0 for MySQL + Postgres + SQLite
SIDU was called MySQL SIDU
- 2009.09.24 - MySQL SIDU 2.4 Season 2 Final
- 2008.02.16 - MySQL SIDU 2.3 speaks Italiano
- 2007.10.23 - MySQL SIDU 2.3 speaks Chinese: Ni Hao!
- 2007.09.22 - MySQL SIDU 2.2 best wishes and good luck
- 2007.09.02 - MySQL SIDU 2.1 shining in the world
- 2007.08.18 - MySQL SIDU 1.8 season one final
- 2007.08.07 - MySQL SIDU 1.7 introduces new features
- 2007.07.16 - MySQL SIDU 1.6 manages MySQL users
- 2007.07.05 - MySQL SIDU 1.5 becomes professional
- 2007.07.04 - MySQL SIDU 1.4 imports and exports data
- 2007.06.23 - MySQL SIDU 1.3 ranks #48 in sf.net
- 2007.06.12 - MySQL SIDU 1.2 becomes handy and stable
- 2007.05.11 - MySQL SIDU 1.1 was released with smiles
- 2007.04.25 - MySQL SIDU 1.0 was born in happiness
- 2007.03.25 - MySQL SIDU project started from scratch