Connect to your database from every language and runtime — drivers, connection strings, pooling, and the auth traps that actually bite.
Connect to Microsoft SQL Server from Rust with tiberius, bb8/deadpool pooling, or ODBC. Working code for connections, @P1 parameters, TLS encryption levels, named instances via SQL Browser, and the sqlx-removed-MSSQL trap.
Connect to MariaDB from Rust with the mysql crate, mysql_async, or sqlx. Working code plus the two genuinely MariaDB-specific issues: ed25519/PARSEC authentication plugin support (which varies by crate) and INSERT ... RETURNING.
Connect to Snowflake from Rust. There is no official Rust driver, so this covers the realistic paths: snowflake-connector-rs, snowflake-api, the ADBC driver, and the SQL REST API, plus key-pair authentication and the account-identifier trap.
Connect to BigQuery from Rust with gcp-bigquery-client or gcloud-bigquery. Auth with service account keys and ADC, parameterized queries, the google-cloud-bigquery renaming confusion, cost controls, and the dataset-location trap.
Connect to ClickHouse from Rust with the official clickhouse crate, klickhouse, or clickhouse-rs. Working code for connections, typed rows with serde, batch inserts, the 8123-vs-9000 port trap, and TLS for ClickHouse Cloud.
Connect to MongoDB from Rust with the official mongodb driver. Working code for async and sync APIs, typed collections with serde, connection pooling, Atlas SRV strings, TLS, and the lazy-connection trap.
Connect to SQLite from Rust with rusqlite, tokio-rusqlite, or sqlx. Working code for connections, the bundled-vs-system build choice, parameterized queries, WAL mode, busy_timeout, and the accidental-file-creation trap.
Connect to MySQL from Rust with the mysql crate, mysql_async, sqlx, or Diesel. Working code for connections, built-in pooling, parameterized queries, the named-parameter translation trap, TLS, and caching_sha2_password auth.
Connect to PostgreSQL from Rust with tokio-postgres, sqlx, or Diesel. Working code for connections, pooling with deadpool, parameterized queries, TLS, and the connection-task gotcha that trips up every new tokio-postgres user.
Clustered vs nonclustered indexes, included columns, key lookups, filtered indexes, and columnstore, with execution plan checks to verify indexes are used.
A practical guide to T-SQL JSON functions: JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, JSON_MODIFY, plus the native json type and JSON indexes in SQL Server 2025.
Connect to Microsoft SQL Server from Ruby with tiny_tds and FreeTDS, plus Sequel and ActiveRecord. Working code for connections, parameterized queries, the OUTPUT clause for generated keys, TLS/encryption on FreeTDS, named instances, and the errors you actually hit.
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 Snowflake from Ruby. There is no official Ruby driver, so this covers the realistic paths: ODBC with ruby-odbc, sequel-snowflake, and the SQL REST API, plus the account-identifier trap and the 2025 key-pair authentication change.
Connect to Google BigQuery from Ruby with the official google-cloud-bigquery gem. Covers Application Default Credentials, the billing-vs-data project split, named and positional query parameters, the dataset location trap, and dry-run cost caps.
Connect to ClickHouse from Ruby over the HTTP interface with click_house, the clickhouse gem, or clickhouse-activerecord for Rails. Covers the 8123-vs-9000 port trap, parameterized queries, batch inserts, and async_insert durability.
Connect to MongoDB from Ruby with the official mongo driver or Mongoid. Working code for connections, one-client reuse, CRUD, the replaceOne data-loss trap, SRV URIs, authSource, and connection pooling.
Connect to SQLite from Ruby with the sqlite3 gem, Sequel, or ActiveRecord. Working code for connections, parameterized queries, WAL mode, the busy_timeout lock fix, and the accidental-file-creation trap.
Connect to MySQL from Ruby with mysql2 or trilogy, plus Sequel and ActiveRecord. Working code for connections, pooling, parameterized queries, the utf8mb4 trap, and the caching_sha2_password authentication problem on MySQL 8.
Connect to PostgreSQL from Ruby with the pg gem, Sequel, or ActiveRecord. Working code for connections, connection pools, parameterized queries, prepared statements, and the sslmode and PostgreSQL 18 cancel-key traps.
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 Microsoft SQL Server from PHP with the official sqlsrv and pdo_sqlsrv drivers: ODBC Driver 18, the Encrypt-defaults-on TLS trap, prepared statements, transactions, the OUTPUT clause for generated keys, and the errors you actually hit.
Connect to Google BigQuery from PHP with the google/cloud-bigquery client: composer install, ADC authentication, running queries with parameters, the location trap, dry-run cost controls, and the errors you actually hit.
Connect to Snowflake from PHP with the official pdo_snowflake driver: building the C extension, the account-identifier DSN trap, key-pair auth after the 2025 password block, parameter binding, warehouse setup, uppercase identifiers, and the errors you actually hit.