Links
- Metadb 1.4 Documentation: https://metadb.dev/doc/1.4/
- Metadb 1.4 Release: https://github.com/metadb-project/metadb/blob/main/CHANGELOG.md
New Features and Functionality
JSON Transformations
- Use create data mapping command to turn on data transformation for specific objects and arrays (https://metadb.dev/doc/1.4/#_create_data_mapping).
- Use drop data mapping command to turn off data transformation (https://metadb.dev/doc/1.4/#_drop_data_mapping).
- Use list data_mappings command to determine what transformations are active (https://metadb.dev/doc/1.4/#_list).
- Note: JSON transformation is disabled by default in new installations.
- Please see this spreadsheet for examples of JSON extractions that are now enabled
User Management
- More granular user permissions that allow administrators to grant and revoke privileges. This allows individual users to be granted access to, or have access removed from, specific tables within Metadb. More details are available here: https://gist.github.com/nassibnassar/9e8e63383db1dac0634b0cf371254dec.
- The ability to register an existing user to another database within the database system. Details about how to use register user and deregister user can be found here: https://gist.github.com/nassibnassar/4175271850d8bdb67baedd730071e335
- The drop user command supports removing users.
- The create schema command supports creating a user schema for an existing user.
- The new function mdbusers() will list registered users.
Data Management
- New commands create data mapping and drop data mapping can be used to define or disable transformation of objects and arrays at specific JSON paths.
- New command list data_mappings shows configured mappings.
- New commands alter system and list config support defining and viewing server configuration parameters.
- New command purge data supports removing tables.
Configuration & Settings
- The new configuration parameters checkpoint_segment_size and max_poll_interval can be used to configure the operation of the stream processor. Changing these requires a server restart.
- The “folio-analytics” or “folio-reshare” tags are no longer set in new installations. The commands external_sql_folio and external_sql_reshare let you specify which version of external reports to run from a repository using the alter system command.
- A new data source option is available, map_public_schema, which supports changing the schema name of tables that originate in the “public” schema.
- The command create data origin no longer requires restarting the server before it takes effect.
- The compilation script build.sh has been renamed to build.
- Go 1.24 is now required to build Metadb.
Closed Issues
- Support Granular User Permissions (https://github.com/metadb-project/metadb/issues/27)
- Transform: Support Full JSON Transformation (https://github.com/metadb-project/metadb/issues/22)
- Disable JSON transform for tables with more than one jsonb column (https://github.com/metadb-project/metadb/issues/58)