v0.5.49Install

Release notes

dlake v0.5.42

NewSkills

Housekeeping for the database itself. Row-change history from the DML audit triggers now has a retention window, 90 days by default, that dlake audit retention shows and sets, and dlake audit purge reports or removes the entries outside it. A weekly storage sweep measures every database file and releases free space, because deleting rows does not make a database smaller and storage is billed per gigabyte. This version is documented in the release notes; no separate GitHub release was published for it.

npm install -g @commercient/dlake
dlake skills install
  • New: dlake audit retention show and dlake audit retention set <days>. Row-change history is recorded by the DML audit triggers, which store a full copy of every affected row, so it grows with how much is written. Retention gives it a floor: 90 days by default, anything from 7 to 3650 days, and 0 to turn the purge off and keep rows indefinitely. show says which window is in force and whether it was chosen or is the default. A change applies on the next daily sweep, and sync-fed and platform tables are never audited at all, so it governs your own tables’ history.
  • New: dlake audit purge and dlake audit purge --run. A bare purge reports how many row-change entries are outside your retention window and how many megabytes they hold, and deletes nothing; --run removes them now instead of waiting for the nightly sweep, with the same batches and time limit. A purge is refused while retention is 0.
  • New: dlake storage show, dlake storage sweep [--shrink] and dlake storage shrink-enabled on|off. Deleting rows does not make a database smaller, and storage is billed per gigabyte, so a weekly storage sweep now measures every database file and releases the free space: data files are trimmed to what they hold plus headroom (and the indexes a trim fragments are rebuilt), and the transaction log is shrunk firmly because Data Lake databases use simple recovery. show prints each file’s size, used and free space, autogrowth and what a sweep would do; sweep measures now and reports, and --shrink releases the space once the platform has armed the sweep; shrink-enabled off excludes your database. The sweep reports by default and never changes autogrowth.
  • Upgrade: npm install -g @commercient/dlake (or npm install -g datalake), then run dlake skills install to refresh the bundled agent skills.