Results for “tmdb”

Explains MariaDB-specific SET TRANSACTION behavior, including scope rules, isolation levels, and innodb_snapshot_isolation conflict detection, to help write correct transaction statements and retry logic.

Bulk-load text files into MariaDB tables using the mariadb-import client, covering table-name-from-filename rules, TAB defaults, --local vs server-side reads, duplicate handling, and parallel loads.

Provisions disposable TiDB Cloud Zero databases via API and CLI, returning connection strings for immediate SQL use.

Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.

Explains MariaDB-specific TRUNCATE TABLE semantics: DROP privilege, implicit commit, AUTO_INCREMENT reset, trigger and FK behavior, and restrictions on system-versioned tables and sequences.

Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.

Explains MariaDB-specific defaults and traps of the mariadb-dump client for dev workflows, including consistent backups, routines/events flags, diffable dumps, idempotent seeding, and restore via the mariadb client.

Indexes local files and searches them with BM25, vector, and hybrid queries, plus MCP mode.

Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.

Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.

Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.

Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.

Manage biological datasets and models with LaminDB, an open-source lineage-native lakehouse. Covers setup, artifact registration, query/search, lineage tracking, validation, ontology-backed annotation, collections, branches, storage, and workflow integrations.

Documents MariaDB-specific GRANT behavior, including privilege scope levels, implicit account creation, MariaDB-only privileges, roles, proxy grants, resource limits, and TLS options, to help write accurate GRANT statements.

Analyzes TiDB cluster topology, slow queries, hot regions, and SQL performance using read-only database and API queries.

Use DuckDB from MATLAB via Database Toolbox (R2026a+) as a non-math operations engine on large tabular files (CSV/Parquet/JSON) and as a zero-config embedded database. Use when connecting to DuckDB, querying CSV, Parquet, and JSON files directly with SQL, reducing or profiling large data before MATLAB analysis, creating portable development databases, or installing DuckDB extensions. Triggers on: DuckDB, duckdb(), large CSV/Parquet/JSON, file too large for readtable, filter/aggregate at source, deduplicate, reduce before analysis, profile large file, persistent file import, analytical engine, SQL on CSV, SQL on Parquet, SQL on JSON, query CSV with SQL, query Parquet with SQL, run SQL on files, SQL queries on files, query files directly, SQL without database, in-process SQL.

Covers MariaDB-specific behavior of the mariadb command-line client, including batch mode output, delimiter handling, safe-updates, charset detection, and TLS defaults, for writing or reviewing shell commands and scripts.

Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.