Everything we've written about MariaDB: connections, SQL patterns, imports, clients, and comparisons.
Connect to MariaDB from Ruby with mysql2 or trilogy, plus Sequel and ActiveRecord. Working code for connections, pooling, parameterized queries, INSERT...RETURNING, the utf8mb4 trap, and the ed25519 authentication gotcha that is genuinely MariaDB-specific.
Connect to MariaDB from PHP with PDO and mysqli: why the MySQL drivers work, the utf8mb4 charset trap, the ed25519 authentication gotcha, RETURNING, transactions, SSL, and the errors you actually hit.
Connect to MariaDB from C# with MySqlConnector: ADO.NET basics, async queries, parameters, connection pooling, Dapper and EF Core, SSL, and the auth and encoding traps that actually bite.
Connect to MariaDB from Java with the official MariaDB Connector/J: JDBC URL, HikariCP pooling, the MySQL-driver compatibility question, ed25519 auth, RETURNING, and the errors you actually hit.
Connect to MariaDB from Go with go-sql-driver/mysql. Working code for the database/sql interface, the parseTime trap, the ed25519 auth plugin, RETURNING support, connection pooling, and where MariaDB differs from MySQL.
Connect to MariaDB from Node.js using the official mariadb driver. Working code for connection pools, promise vs callback APIs, the named-pipe and socket traps, and how it differs from mysql2.
Connect to MariaDB from Python with the official mariadb connector, mysqlclient, or PyMySQL. Working code, the qmark vs %s parameter difference, the C build dependency trap, and when a MySQL driver is the better choice.
Four methods to import CSV files into MariaDB: LOAD DATA INFILE, LOAD DATA LOCAL INFILE, mariadb-import CLI, and Mako. Covers permissions, encoding, and type conversion.
Four ways to import Excel data into MariaDB: convert to CSV and use LOAD DATA INFILE, Python with pandas, HeidiSQL's import tool, and Mako. Covers character sets, date handling, and the CONNECT engine.
Three ways to import JSON data into MariaDB: LOAD DATA INFILE with LONGTEXT columns, a Python script, and Mako. Covers MariaDB's JSON alias, functions, and differences from MySQL.