3 ms·
The idea is good, but without database software versions and links to sources, a bit useless. MySQL supports several database engines, the former default engine
by frik 12y ago
The idea is good, but without database software versions and links to sources, a bit useless. MySQL supports several database engines, the former default engine was ISAM (now outdated), the newer default engine is InnoDB.
Such a comparison table would fit to Wikipedia.
- thorin 12y agoI also like the idea, however a quick perusal of Oracle (which I know best - I know the others a little, especially SQLServer) would suggest that at least 50% of the "nos" can be done or have an easy workaround. So it's good from an overview perspective but not really a definitive guide. Agree on the comment above re: versions.
- Alupis 12y agoAnd I believe there are features MariaDB 10.x supports that MySQL 5.x does not... this comparison seems to lump both MySQL and MariaDB together (or excludes MariaDB?).
- SloopJon 12y agoIt makes complete sense to me that the maintainer of a multi-DB tool would collect a table of features like this. My impression is that SQL Workbench/J does not try to hide differences between database systems. The fact that a cell in the table is red is a heads up that the straightforward way won't necessarily work out of the box. There are notes for some of the cells like "since 3.8.3" and "MariaDB 10.1 supports ...". If you have more specific information, I'm sure the author would be happy to get an email.
- frik 12y agoThe notes aren't accessible on touch devices like iPad.