0.9.27
LibreDB Studio v0.9.27 adds a Redis database provider, a complete code-verified reference doc set for all seven providers, and a major PostgreSQL schema-introspection performance fix. Changes since v0.9.25.
Highlights
- New Redis database provider.
- Reference documentation for every database provider, kept in sync with the code.
- PostgreSQL schema introspection no longer times out on large schemas.
- Broad documentation accuracy and cleanup pass.
Features
- Redis provider (
ioredis): plain-command and JSON query formats, key-pattern schema mapping,INFO/SLOWLOG/CLIENT LISTmonitoring, clear error handling, and full integration tests. (#7)
Fixes
- PostgreSQL: schema introspection on large schemas no longer hits the statement timeout. CTEs are now
MATERIALIZED(about 295s down to about 2.6s on a 122-table schema) and schema loading is split into a fast table list plus an async relations merge, so a slow relations query can never block the tree. - PostgreSQL: cross-schema foreign keys now resolve correctly (join on
constraint_schema). - SQL: schema-qualified identifiers are quoted per segment.
- Schema Explorer: the select action label is now "Select Top 50".
- E2E: admin-dashboard tests are seed-state-independent.
- CI: restored the
test:ciscript used by the npm publish gate.
Documentation
- New per-provider reference set under
docs/providers/(postgres, mysql, oracle, mssql, sqlite, redis, mongodb) with an index, each section verified against the source. DATABASE_PROVIDERS.mdslimmed into the cross-cutting architecture and "adding a new provider" guide; a provider code/docs/tests tri-sync rule added toCLAUDE.md.API_DOCS.mdsynced to the current routes and corrected auth model; drift fixes acrossFEATURES,ARCHITECTURE,OIDC,STORAGE, and the Helm chart docs; editor/UI docs grouped;CLAUDE.mdslimmed with a path-scoped platform-integration rule and a pre-commit hook.
Install and upgrade
- Docker (GHCR):
ghcr.io/libredb/libredb-studio:0.9.27(also:latest) - npm package:
@libredb/studio@0.9.27
Full changelog: v0.9.25...v0.9.27