Implement, debug, and migrate WordPress custom database tables using BerlinDB 3.x.
npx skills add https://github.com/berlindb/core --skill berlindb-berlindb
Please help me install this Agent Skill. Skill: berlindb Source: https://github.com/berlindb/core/tree/main/skills/berlindb Command: npx skills add https://github.com/berlindb/core --skill berlindb-berlindb
allow_null, sortable, in/not_in), string table versions, and upgrade callbacks. - Relationships and meta tables: Declare belongs_to/has_many relationships (single, composite, and conditioned), prime caches with with, filter via relation, and build custom meta tables with the Meta preset. - Debugging and migration: Diagnose silent insert/update failures, wrong primary-key usage, stuck table upgrades, and migrate BerlinDB 2.x code to 3.x namespaces and APIs. - Use Case: A plugin developer's add_item() call returns false with no SQL error. The Skill walks through checking allow_null flags, capability reduction (wp_set_current_user(1) in tests), and the structured get_logs() output to find the rejected column. ## Quick Start Ask the assistant to help you define a BerlinDB Schema, Table, Row, and Query for a new WordPress custom table, or to debug a failing BerlinDB insert or migration.High-intent search queries and answers about installing and using this skill.
Define four classes: a Schema subclass with $columns and $indexes, a Table subclass with $name, $version, and $schema, a Row subclass with public properties, and a Query subclass with $table_schema and $item_shape. Then call maybe_upgrade() on the Table from an activation path.
Validation usually stopped the write before SQL ran. Common causes are passing null to a column without 'allow_null' => true, an invalid value for the column type, or capability reduction stripping fields. Inspect $query->get_logs() and $wpdb->last_error to find the rejected column.
Update namespaces to BerlinDB\Database\Kern\Schema, Table, Query, and Row instead of the old BerlinDB\Database paths. Replace Table::set_schema() overrides with a $schema class property, use get_create_table_string() instead of to_string(), and note PHP 8.1 is now required.
Yes, version 3.1.0 supports belongs_to and has_many relationships declared in a column's relationships array, including composite keys and conditioned polymorphic relationships. Use get_related() to fetch related rows, with to prime caches, and the relation query var to filter.
The no_found_rows query var defaults to true, so no separate COUNT(*) query runs and get_found_items() returns only the current page count. Pass 'no_found_rows' => false explicitly to get the true total for pagination.
Composite primary keys are intended for junction tables only. Item meta is unsupported, get_item() and copy_item() work with single-column keys only, and add_item() uses the first key column for its returned ID. Prefer a single-column key plus a composite UNIQUE index.
nanasi-appsPort WordPress plugin concepts to EmDash using TypeScript and EmDash APIs.
sanruizAutomates and standardizes PHPUnit testing for WordPress components.
jdevalkGenerate GitHub Actions workflows for WordPress plugin CI/CD.
hekivoCreate Eloquent ORM models, migrations, and relationships for Acorn projects.