view release on metacpan or  search on metacpan

share/skills/dbio-mysql-database/SKILL.md  view on Meta::CPAN

---

MySQL/MariaDB for Perl DB driver development.

## DBD::mysql

Handles both MySQL and MariaDB. Connection:
```perl
DBI->connect("dbi:mysql:database=mydb;host=localhost", $user, $pass)
```
Critical flags: `mysql_enable_utf8mb4 => 1` (Unicode), `mysql_auto_reconnect => 0` (transactions).

## MySQL vs MariaDB

| Feature | MySQL | MariaDB |
|---------|-------|---------|
| JSON type | Native `JSON` | Alias `LONGTEXT` (<10.5) |
| CTEs | 8.0+ | 10.2+ |
| Window functions | 8.0+ | 10.2+ |
| Sequences | No | 10.3+ |
| System versioning | No | 10.3+ |