外掛說明
WaffleDB is a no-code database management plugin for WordPress. You can define custom tables with any column structure directly from the admin dashboard, then create, read, update, and delete records through a built-in web interface or via REST API.
Features
- Create custom tables with a flexible column structure
- CRUD operations (create, read, update, delete) via web interface
- Role-based access control (read / write / update / delete per table)
- 19 column types: text, textarea, int, float, email, date, datetime, time, URL, image URL, image upload, file upload, YouTube, HTML text, Markdown, relation, radio, select (dropdown), checkbox
- CSV export
- REST API with API token authentication
- Block editor support: WaffleDB Table and WaffleDB Record blocks with a table picker
- Shortcode support:
[waffledb table_id="X"]and[waffledb_item table_id="X" item_id="Y"] - DataTables integration for large datasets (switches to AJAX for 1,000+ records)
Limits
- Up to 6 tables per site
- Up to 15 columns per table
適用於區塊編輯器
這個外掛提供 2 個可供 Gutenberg/區塊編輯器使用的區塊。
- WaffleDB Record Display a single WaffleDB record.
- WaffleDB Table Display a WaffleDB table with data management UI.
安裝方式
- Upload the
waffledbfolder to the/wp-content/plugins/directory, or install it directly through the WordPress plugin screen. - Activate the plugin through the Plugins screen in WordPress.
- Go to WaffleDB in the admin menu to create your first table.
- Add columns to define your data structure, then start entering records.
使用者評論
這個外掛目前沒有任何使用者評論。
參與者及開發者
變更記錄
1.8
- Added checkbox column type (multi-select from a configurable option list, shares storage/UI with radio and select)
- Reordered the column type picker: text, textarea, HTML text, Markdown, and relation now precede select/radio in the list
1.7
- Fixed fatal error when adding an email column (missing validate_data() method)
- Fixed fatal error on admin_init when migrating (waffle_migrate waffledb_migrate)
1.6
- Added HTML text column type (allowed tags: a, font, b, strong, i, em, span, p, br, ul, ol, li)
- Fixed column type allowlist to include mediumtext, preventing silent ALTER TABLE failures
- Fixed column metadata insert order so validation runs before the row is written
1.5
- Security: escaped shortcode/callback return values, including the WP_List_Table column callbacks rendered by WordPress
- Security: added a delete-permission check to the front-end detail view before deleting a record
- Security: hardened nonce and capability checks across admin AJAX handlers and form controllers
- Security: switched dynamic SQL identifiers to the %i placeholder with strict identifier/type allowlist validation, and parameterized values with prepare()
- Added email column type
- Fixed malformed SHOW TABLES queries (missing closing quote) in the activation/migration routine
1.2
- Added float (double) column type
- Fixed CSV download returning empty content
- Fixed CSV download encoding to UTF-8
- Fixed API syntax errors
- Improved component type display names
- Removed deprecated load_plugin_textdomain() call (auto-loaded since WordPress 4.6)
- Code and directory structure refactoring
1.1
- Corrections after review
1.0
Release Date – 30 March 2024
- First Release