15,041
edits
Database management tools: Difference between revisions
Jump to navigation
Jump to search
→Lists of database tools: + Data type of cell value
No edit summary Tags: Mobile edit Mobile web edit |
(→Lists of database tools: + Data type of cell value) |
||
| Line 8: | Line 8: | ||
* Engine supported: "MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MariaDB, Sybase, Teradata, Netezza, etc. Supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive" | * Engine supported: "MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MariaDB, Sybase, Teradata, Netezza, etc. Supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive" | ||
* Software licenses: Open source - Apache License Version 2.0<ref>[https://dbeaver.jkiss.org/about/ About | DBeaver]</ref>. Source code is available on [https://github.com/serge-rider/dbeaver github].{{Gd}} | * Software licenses: Open source - Apache License Version 2.0<ref>[https://dbeaver.jkiss.org/about/ About | DBeaver]</ref>. Source code is available on [https://github.com/serge-rider/dbeaver github].{{Gd}} | ||
* Data type of cell value: Need to convert string to number/date time type! {{exclaim}} | |||
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | * Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | ||
| Line 15: | Line 16: | ||
* Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica" | * Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica" | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | * Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | ||
| Line 22: | Line 24: | ||
* Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref> | * Engine supported: MySQL & MariaDB<ref>[http://sqlyogkb.webyog.com/article/166-what-is-sqlyog What is SQLyog - SQLyog Knowledge Base]</ref> | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | * Comments: Quick to export large data (rows count exceed 10,000 rows) {{Gd}} | ||
| Line 29: | Line 32: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref> | * Software licenses: Proprietary<ref>[https://dev.mysql.com/doc/workbench/en/wb-preface.html MySQL :: MySQL Workbench Manual :: Preface and Legal Notices]</ref> | ||
* Data type of cell value: | |||
* Comments: {{exclaim}} Excel Spreadsheet (XML) generated by MySql Workbench may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error". | * Comments: {{exclaim}} Excel Spreadsheet (XML) generated by MySql Workbench may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error". | ||
| Line 36: | Line 40: | ||
* Engine supported: "SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, '''Excel''', VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL" | * Engine supported: "SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, '''Excel''', VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL" | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: Need to convert string to number/date time type! {{exclaim}} | |||
* Comments: | * Comments: | ||
| Line 43: | Line 48: | ||
* Engine supported: MySQL ... | * Engine supported: MySQL ... | ||
* Software licenses: GNU General Public License version 2.0 (GPLv2) | * Software licenses: GNU General Public License version 2.0 (GPLv2) | ||
* Data type of cell value: | |||
* Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated! | * Comments: {{exclaim}} When I tried to export the query result set as XLS file but no file was generated! | ||
| Line 50: | Line 56: | ||
* Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref> | * Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2<ref>[https://www.jetbrains.com/datagrip/features/ Features - DataGrip]</ref> | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 57: | Line 64: | ||
* Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud<ref>[https://www.navicat.com/cht/products/navicat-premium Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫]</ref> | * Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud<ref>[https://www.navicat.com/cht/products/navicat-premium Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫]</ref> | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: No need to convert string to number/date time type! {{Gd}} | |||
* Comments: | * Comments: | ||
| Line 64: | Line 72: | ||
* Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | * Engine supported: MySQL, MSSQL, Oracle, PostgreSQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 71: | Line 80: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 79: | Line 89: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 86: | Line 97: | ||
* Engine supported: | * Engine supported: | ||
* Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}} | * Software licenses: GPL<ref>[https://www.heidisql.com/help.php#license License]</ref> {{Gd}} | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 93: | Line 105: | ||
* Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite" | * Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite" | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 100: | Line 113: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit! | * Comments: {{exclaim}} Excel file (XLS) has 65,536 rows limit! | ||
| Line 107: | Line 121: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
| Line 114: | Line 129: | ||
* Engine supported: MySQL | * Engine supported: MySQL | ||
* Software licenses: Proprietary | * Software licenses: Proprietary | ||
* Data type of cell value: | |||
* Comments: {{exclaim}} I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query. | * Comments: {{exclaim}} I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query. | ||
| Line 122: | Line 138: | ||
* Engine supported: | * Engine supported: | ||
* Software licenses: | * Software licenses: | ||
* Data type of cell value: | |||
* Comments: | * Comments: | ||
</pre> | </pre> | ||