eXtremeDB Skills

eXtremeDB Skill: Python Application Development

Provides guidance for developing, configuring, and troubleshooting Python applications using the eXtremeDB embedded/in-memory database. Covers schema definition and compilation, database lifecycle management, transactional CRUD operations via the native object API or Embedded SQL, and working with advanced data types such as sequences, vectors, and nested structs.

eXtremeDB Skill: Sequence Fields and Iterators in C

Provides guidance for developing, explaining, reviewing, and troubleshooting native C applications that use eXtremeDB sequence fields and the public iterator API from an installed eXtremeDB SDK. Covers generated sequence-field functions, mcoseq.h pipelines, nullable values, analytics, linking, and plain or RLE sequence libraries. Does not cover SQL-only sequence questions.

eXtremeDB Skill: Database Configuration and Storage Media

Provides guidance for choosing, explaining, and reproducing eXtremeDB database configuration and physical media settings. Covers runtime modes, transaction managers (EXCLUSIVE/MURSIW/MVCC), in-memory, shared-memory, persistent, and hybrid storage, mco_device_t arrays, mem_page_size/disk_page_size, cache and database sizes, persistent .dbs files, .log files, multifile and RAID layouts, db_params/mode_mask/db_log_type/log_params, encryption (cipher_key) or compression settings, opening existing .dbs/.log media, snapshot, image, transaction-log, and backup compatibility, and dictionary and schema compatibility. Covers only C/C++ (mco_*) API configuration questions; for xSQL, use the corresponding xSQL configuration .cfg option names.

eXtremeDB Skill: Database Lifecycle Management

Provides guidance for the eXtremeDB database lifecycle: runtime start/stop, device configuration, mco_db_params_t, and open/connect/disconnect/close patterns.

eXtremeDB Skill: Schema Definition and DDL Compilation

Provides guidance for creating and modifying an eXtremeDB schema definition file (.mco extension), generating database dictionary files, and working with mcocomp DDL compiler output. Covers creating a complete .mco schema from scratch and generating mcocomp-compatible .c/.h API files by writing the implementation that contains the _get_dictionary() function and all wrapper functions declared in <db>_h.h.

eXtremeDB Skill: Storage Devices and Database Parameters

Provides guidance for configuring eXtremeDB storage devices (mco_device_t) and database parameters (mco_db_params_t) for embedded C applications.

eXtremeDB Skill: Error Handling and Diagnostics

Provides guidance for using the eXtremeDB Error Handling API in C applications. Covers return codes (status, non-fatal error, fatal error), error handler registration (mco_error_set_handler, mco_error_set_handler_ex), error message translation (mco_strerror), last transaction error retrieval (mco_get_last_error), and related debugging patterns.

eXtremeDB Skill: Generated C Accessor APIs

Provides guidance for using generated accessor APIs produced by the mcocomp DDL compiler for C applications. Covers scalar accessors (_get/_put), numeric, string, and vector accessors, fixed_get/fixed_put, class-level new/delete/checkpoint, cursor-based access (from_cursor, list_cursor), structure handles, and linking with the dictionary function.

eXtremeDB Skill: Indexes and Cursors

Provides guidance for using eXtremeDB indexes and cursors in C applications. Covers tree, hash, patricia, rtree, kdtree, trigram, hnsw, user-defined, oid, and autoid indexes; generated accessors; cursor navigation (first, last, next, prev, close, store, check); and search patterns (equal, contain, overlap, neighborhood, range, exact match, nearest neighbor, prefix/longest/exact match).

eXtremeDB Skill: Application Linking on Linux with GCC

Provides guidance for configuring, reviewing, and troubleshooting native C/C++ application linking with eXtremeDB on Linux using GCC and GNU binutils. Covers library selection and ordering, Makefile/CMake integration, static archives and shared libraries, debug/release and direct-pointer variants, undefined references, duplicate definitions, ABI mismatches, and runtime loader failures. Does not cover Windows, other toolchains, or building the database engine itself.

eXtremeDB Skill: Backup and Restore

Provides guidance for using eXtremeDB backup and restore APIs in C applications. Covers incremental online backup (mco_backup_create/mco_backup_restore/mco_backup_verify), file backup (mco_disk_backup), database save/load (mco_db_save/mco_db_load, BSE), asynchronous backup, and related structures and error handling.

eXtremeDB Skill: Runtime Initialization and Shutdown

Provides guidance for using the eXtremeDB Runtime Start/Stop API in C applications. Covers runtime initialization or shutdown, mco_runtime_start, mco_runtime_start_ex, mco_runtime_stop, runtime options, multi-process shared memory, multi-threaded applications, dynamic library loading, feature detection, and related troubleshooting.

eXtremeDB Skill: SQL Access via JDBC

Provides guidance for building, reviewing, and debugging Java applications that use eXtremeDB SQL through JDBC. Covers writing eXtremeDB JDBC examples, adapting generic JDBC code to eXtremeDB, explaining eXtremeDB JDBC connection strings, driver URL/property options, xSQL/RSQL server startup, eXtremeDB SQL dialect details, supported data types, DDL/DML syntax, built-in SQL functions, transactions, statements, ResultSet behavior, SQL Array/vector bindings, batch inserts, metadata limitations, and diagnosing SQLException messages from the eXtremeDB JDBC driver.

eXtremeDB Skill: Tracing Configuration and Hooks

Provides guidance for configuring and using eXtremeDB native C tracing (mcotrace) APIs: synchronous/asynchronous delivery, custom appender handlers, severity/module filtering, format strings, file rotation, environment variables, and safe tracing hooks in embedded C applications.

eXtremeDB Skill: Transaction Logging

Provides guidance for developing, explaining, reviewing, and troubleshooting native C applications that use the eXtremeDB Transaction Logging (TL) API from an installed eXtremeDB SDK. Covers log start/stop/apply/iterate/query/label/truncate/flush/db_save/play/play_ex, log flags (MCO_TRANSLOG_*), stream/pipe/dual-output modes, checkpoint recovery, MVCC logging, and TL integration with transactions, indexes, cursors, and devices.

eXtremeDB Skill: Uniform Database Access (UDA)

Provides guidance for developing, explaining, reviewing, and troubleshooting native C applications that use eXtremeDB Uniform Database Access (UDA) from an installed SDK. Covers mcouda.h, runtime schema discovery, metadictionaries, type-erased objects and values, UDA cursors/indexes/events/collations, and mco_uda_seq_*. Does not cover generated-C-only or SQL-only requests.

eXtremeDB Skill: XML Import and Export

Provides guidance for using the eXtremeDB XML API in C applications. Covers XML export/import (mco_db_xml_export/mco_db_xml_import), XML policy (mco_xml_policy_t), generated XML accessors (*_xml_create/put/get/schema), stream callbacks, XML-related error handling, serializing database data to XML, and loading XML into an open database.

eXtremeDB Skill: xSQL Configuration and Usage

Provides guidance for using the eXtremeDB xSQL utility. Covers starting xSQL as an interactive SQL console, batch runner, RSQL server, RSQL client, HA master/replica process pair, cluster node topology, or database utility; opening or inspecting existing disk databases such as .dbs/.log media created by embedded applications; writing or checking eXtremeDB SQL dialect statements for xSQL; running .sql scripts with -f; configuring xsql.cfg; inspecting schema, indexes, metatables, and statistics; import/export, backup, database images, transaction logging workflows, and troubleshooting xSQL startup or connection issues. Does not cover eXtremeDB/rt or JDBC application code except when explaining the xSQL/RSQL server side.