MariaDB support

Applies to: 9.x (current) versions, Article available also for: 8.x, 7.x, 6.x, 5.x, 10.x

Supported versions

MariaDB Server 5.1, 5.2, 5.3, 5.5, 10.0, 10.1, 10.2, 10.3

MariaDB Columnstore

Some versions of MariaDB Columnstore may cause issues - we have tested and version 1.1.2-1 works properly.

If you do run into any issues please post here.

Supported schema elements and metadata

Dataedo reads following metadata from MariaDB databases.

  • Tables
    • Columns
      • Data type with length
      • Nullable
      • Default value
    • Primary keys
      • Columns
    • Unique indexes
      • Column
    • Foreign keys
      • Columns
    • Triggers
      • When triggered
      • Script
  • Views
    • Columns (see tables)
    • Script
  • Procedures
    • Script
    • Parameters (may not work on older versions of MariaDB)
  • Functions
    • Script
    • Parameters (may not work on MariaDB 5.1)
    • Returned value (may not work on MariaDB 5.1)

Comments

Dataedo reads MariaDB comments from following objects:

  • Tables
    • Columns
    • Primary keys
    • Unique indexes
  • Views
    • Columns
  • Procedures
  • Functions

Dataedo does not write comments back to MariaDB.

Limitations

Following schema/metadata elements currently are not supported:

  • Check constraints (vote)
  • Non unique indexes (vote)
  • Dependencies - are not presented by MariaDB

Connection:

  • SSL connection is not currently supported

Learn more

Connect to MariaDB

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.