14,983
edits
Database management tools: Difference between revisions
Jump to navigation
Jump to search
m
→64 bit OS architecture
| Line 3: | Line 3: | ||
== Lists of database tools == | == Lists of database tools == | ||
=== 64 bit OS architecture === | === 64 bit OS architecture === | ||
[https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 & Enterprise Edition v. | [https://dbeaver.jkiss.org/ DBeaver] Community Edition v. 4.2.1 & Enterprise Edition v. 5.2.2 (32bit & 64bit) for {{Win}}, {{Mac}} & {{Linux}} | ||
* Import format: Import file into table is not availabe. | * Import format: Import file into table is not availabe. | ||
* Export format: Export query result set as CSV, HTML, XML, JSON file <ref>[https://dbeaver.jkiss.org/docs/features/#Data_transfer_(export/import) Features | DBeaver]</ref>. More formats e.g. '''XLSX''' is available in the paid version <ref>[https://dbeaver.com/faq/ FAQ | DBeaver Enterprise Edition]</ref>. | * Export format: Export query result set as CSV, HTML, XML, JSON file <ref>[https://dbeaver.jkiss.org/docs/features/#Data_transfer_(export/import) Features | DBeaver]</ref>. More formats e.g. '''XLSX''' is available in the paid version <ref>[https://dbeaver.com/faq/ FAQ | DBeaver Enterprise Edition]</ref>. | ||
| Line 9: | Line 9: | ||
* 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/dbeaver/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/dbeaver/dbeaver github].{{Gd}} | ||
* Data type of cell value: Need to convert string to number/date time type! {{exclaim}} | * Data type of cell value: (1) Need to convert string to number/date time type! {{exclaim}} (2) Large number became string type. | ||
* 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}} | ||