Features

• immuadmin: sysadmin permission now accepted by user create and user permission CLI commands, enabling operators to bootstrap additional sysadmin accounts from the command line without relying solely on the default immudb account (#2052)
• auditor: new opt-in --audit-verify-values flag re-reads and SHA-256-verifies each committed value after the chain proof check; any on-disk tampering surfaces as a failed audit cycle without changing default (chain-only) behavior (#2091)

Performance

• embedded/sql: index-only COUNT(*) for indexed WHERE queries <80><94> SELECT COUNT(*) FROM t WHERE indexed_col = ? no longer fetches full rows, satisfying the count entirely from the secondary index (#2093)
• embedded/sql: reduceBool fast path avoids per-row heap-boxing of boolean expressions in the COUNT(*) hot path; combined with hoisting substitute and EncodeSelector out of the per-row loop, a 50k-row composite-index COUNT(*) drops from 20.87 ms to 14.92 ms and from 234k to 150k allocations/op
• embedded/store: hot-path allocation and lock-contention reductions on critical read/write paths
• embedded/appendable/remoteapp: range-fetch ReadAt <80><94> issues a bounded range request (~256 KiB window) instead of downloading the entire chunk; for a 4 MiB chunk with a 64 B tail read, bytes on the wire shrink from 4 MiB to ~256 KiB
• embedded/appendable/remoteapp: background prefetch pipelines the next read window to hide latency on sequential scans
• remote/s3 (Wave 4): drop upload-verify round-trips, parallel chunk prefetch, end-to-end compression

Bug Fixes

• embedded/sql: two server-crashing panics introduced in v1.11.0 (#2100):
  • Nil pointer dereference in the disk-spill sort path: large ORDER BY <E2><80><A6> OFFSET result sets that spill to disk panicked because projection-pushdown left unaccessed column slots as nil; the encode path now substitutes a typed NULL for nil slots
  • Index out-of-range in db.SQLQuery: empty or comment-only SQL input (accepted by the parser since v1.11.0) returned an empty statement slice, causing a crash; a len(stmts) == 0 guard now returns ErrExpectingDQLStmt
• embedded/sql: standalone COUNT(col) returned 0 for any non-empty table; CountValue.ColBounded() now returns true for both COUNT(col) and COUNT(DISTINCT col), preserving SQL NULL-skip semantics (#2042)
• embedded/sql: TIMESTAMP parameter binds with timezone suffixes (Z, <C2><B1>HH:MM) were rejected by the PG wire bind path; space-separated layouts are now accepted alongside RFC3339 (#1149)
• embedded/sql: parametrized SELECT WHERE col = $1 reused the first bound value on subsequent executions of a cached prepared statement; substitute() now returns fresh AST nodes instead of mutating the cached receiver (#1153)
• embedded/store: database permanently unrecoverable after ungraceful shutdown (e.g. OOMKill) that left more pre-committed transactions on disk than MaxActiveTransactions; the recovery path now grows the precommit buffer dynamically (doubling on overflow) instead of returning ErrBufferIsFull (#2086)
• embedded/store: hard 60-second ingestion freeze on every indexing error replaced with bounded exponential backoff (100 ms doubling to 60 s, reset on a fully successful iteration) (#2061)
• embedded/store: supplying different MaxValueLen, MaxKeyLen, MaxTxEntries, or FileSize values on store re-open was silently ignored; a warning is now emitted naming both the supplied and stored values (#1864)
• pkg/server: DatabaseListV2 failed entirely when any database was closed or unloadable; unloaded databases now appear in the listing with Loaded=false, NumTransactions=0 (#1997)
• docker: almalinux-8-minimal image failed to start with permission denied on /var/lib/immudb/immudb.identifier due to a UID/GID mismatch (directories owned by 65532, runtime user immu running as 3322); IMMU_UID/IMMU_GID are now consistently set to 3322 (#2098)

CI

• docker: official images are now built for linux/amd64 and linux/arm64 via docker buildx; Go cross-compiles natively on the build platform without QEMU (#2069)

Dependencies

• golang.org/x/crypto v0.48.0 <86><92> v0.52.0 (8 HIGH + 5 MEDIUM CVEs)
• golang.org/x/net v0.50.0 <86><92> v0.55.0 (7 HIGH + 1 MEDIUM CVEs)
• golang.org/x/sys v0.41.0 <86><92> v0.45.0 (CVE-2026-39824, required transitively)
• github.com/jackc/pgx/v5 v5.9.1 <86><92> v5.9.2 (CVE-2026-41889)
• github.com/sirupsen/logrus v1.8.1 <86><92> v1.9.3 (DoS via Entry.Writer())
• urllib3 (test/e2e) <86><92> v2.7.0 (CVE-2026-44432, GHSA-2xpw-w6gg-jr37)

Features

• immuadmin: sysadmin permission now accepted by user create and user permission CLI commands, enabling operators to bootstrap additional sysadmin accounts from the command line without relying solely on the default immudb account (#2052)
• auditor: new opt-in --audit-verify-values flag re-reads and SHA-256-verifies each committed value after the chain proof check; any on-disk tampering surfaces as a failed audit cycle without changing default (chain-only) behavior (#2091)

Performance

• embedded/sql: index-only COUNT(*) for indexed WHERE queries — SELECT COUNT(*) FROM t WHERE indexed_col = ? no longer fetches full rows, satisfying the count entirely from the secondary index (#2093)
• embedded/sql: reduceBool fast path avoids per-row heap-boxing of boolean expressions in the COUNT(*) hot path; combined with hoisting substitute and EncodeSelector out of the per-row loop, a 50k-row composite-index COUNT(*) drops from 20.87 ms to 14.92 ms and from 234k to 150k allocations/op
• embedded/store: hot-path allocation and lock-contention reductions on critical read/write paths
• embedded/appendable/remoteapp: range-fetch ReadAt — issues a bounded range request (~256 KiB window) instead of downloading the entire chunk; for a 4 MiB chunk with a 64 B tail read, bytes on the wire shrink from 4 MiB to ~256 KiB
• embedded/appendable/remoteapp: background prefetch pipelines the next read window to hide latency on sequential scans
• remote/s3 (Wave 4): drop upload-verify round-trips, parallel chunk prefetch, end-to-end compression

Bug Fixes

• embedded/sql: two server-crashing panics introduced in v1.11.0 (#2100):
  • Nil pointer dereference in the disk-spill sort path: large ORDER BY … OFFSET result sets that spill to disk panicked because projection-pushdown left unaccessed column slots as nil; the encode path now substitutes a typed NULL for nil slots
  • Index out-of-range in db.SQLQuery: empty or comment-only SQL input (accepted by the parser since v1.11.0) returned an empty statement slice, causing a crash; a len(stmts) == 0 guard now returns ErrExpectingDQLStmt
• embedded/sql: standalone COUNT(col) returned 0 for any non-empty table; CountValue.ColBounded() now returns true for both COUNT(col) and COUNT(DISTINCT col), preserving SQL NULL-skip semantics (#2042)
• embedded/sql: TIMESTAMP parameter binds with timezone suffixes (Z, ±HH:MM) were rejected by the PG wire bind path; space-separated layouts are now accepted alongside RFC3339 (#1149)
• embedded/sql: parametrized SELECT WHERE col = $1 reused the first bound value on subsequent executions of a cached prepared statement; substitute() now returns fresh AST nodes instead of mutating the cached receiver (#1153)
• embedded/store: database permanently unrecoverable after ungraceful shutdown (e.g. OOMKill) that left more pre-committed transactions on disk than MaxActiveTransactions; the recovery path now grows the precommit buffer dynamically (doubling on overflow) instead of returning ErrBufferIsFull (#2086)
• embedded/store: hard 60-second ingestion freeze on every indexing error replaced with bounded exponential backoff (100 ms doubling to 60 s, reset on a fully successful iteration) (#2061)
• embedded/store: supplying different MaxValueLen, MaxKeyLen, MaxTxEntries, or FileSize values on store re-open was silently ignored; a warning is now emitted naming both the supplied and stored values (#1864)
• pkg/server: DatabaseListV2 failed entirely when any database was closed or unloadable; unloaded databases now appear in the listing with Loaded=false, NumTransactions=0 (#1997)
• docker: almalinux-8-minimal image failed to start with permission denied on /var/lib/immudb/immudb.identifier due to a UID/GID mismatch (directories owned by 65532, runtime user immu running as 3322); IMMU_UID/IMMU_GID are now consistently set to 3322 (#2098)

CI

• docker: official images are now built for linux/amd64 and linux/arm64 via docker buildx; Go cross-compiles natively on the build platform without QEMU (#2069)

Dependencies

• golang.org/x/crypto v0.48.0 → v0.52.0 (8 HIGH + 5 MEDIUM CVEs)
• golang.org/x/net v0.50.0 → v0.55.0 (7 HIGH + 1 MEDIUM CVEs)
• golang.org/x/sys v0.41.0 → v0.45.0 (CVE-2026-39824, required transitively)
• github.com/jackc/pgx/v5 v5.9.1 → v5.9.2 (CVE-2026-41889)
• github.com/sirupsen/logrus v1.8.1 → v1.9.3 (DoS via Entry.Writer())
• urllib3 (test/e2e) → v2.7.0 (CVE-2026-44432, GHSA-2xpw-w6gg-jr37)

<a name="v1.11.0"></a>

v1.11.0 — PostgreSQL Compatibility and SQL Feature Expansion

• Structured audit logging: New --audit-log flag records all gRPC operations as tamper-proof JSON events in systemdb, filterable via --audit-log-events (all/write/admin).
• PostgreSQL ORM compatibility: Added pg_catalog and information_schema virtual table resolvers to support ORM introspection from Django, SQLAlchemy, GORM, and ActiveRecord.
• immudb verification functions via SQL: immudb_state, immudb_verify_row, immudb_verify_tx, immudb_history, and immudb_tx are now accessible as SQL functions over the PostgreSQL wire protocol.
• PostgreSQL compatibility functions: current_database, current_schema, current_user, format_type, has_table_privilege, and many others; plus SHOW statement emulation for common ORM config queries.
• Subquery support: EXISTS, NOT EXISTS, IN, and NOT IN subqueries now fully implemented in the SQL engine.
• New JOIN types: CROSS JOIN and FULL OUTER JOIN added.
• Set operations: EXCEPT and INTERSECT implemented.
• New SQL functions: Math (ABS, CEIL, FLOOR, ROUND, POWER, SQRT, MOD), string (REPLACE, REVERSE, LEFT, RIGHT, REPEAT, POSITION), and conditional (NULLIF, GREATEST, LEAST).
• ORDER BY enhancements: NULLS FIRST / NULLS LAST syntax supported.
• Upserts: INSERT ... ON CONFLICT DO UPDATE SET implemented.
• Views: CREATE VIEW / DROP VIEW (session-scoped, not persisted to catalog).
• CTEs: WITH clause (Common Table Expressions) materialized and referenceable in the main query.
• Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTILE, plus windowed aggregates (COUNT, SUM, MIN, MAX, AVG).
• EXPLAIN statement: Returns a human-readable query plan for any SELECT.

Features

• embedded/sql: DIFF OF SQL query — compare table state between two transaction points via SELECT _diff_action, ... FROM (DIFF OF t) SINCE TX N UNTIL TX M
• embedded/sql: FULL OUTER JOIN, LATERAL joins, CROSS JOIN, NATURAL JOIN, JOIN USING
• embedded/sql: EXISTS, IN, correlated subqueries, WITH CTEs including WITH RECURSIVE
• embedded/sql: window functions (LEAD, LAG, FIRST_VALUE, LAST_VALUE, NTILE) with per-query memory limit
• embedded/sql: EXCEPT and INTERSECT set operations
• embedded/sql: CREATE/DROP VIEW with persistence, partial indexes, TRUNCATE TABLE, DROP TABLE IF EXISTS CASCADE, ALTER COLUMN, SAVEPOINT/RELEASE/ROLLBACK TO, FOREIGN KEY, SEQUENCES, DEFAULT column values with persistence
• embedded/sql: RETURNING, ON CONFLICT DO UPDATE, FETCH FIRST N ROWS ONLY, LIMIT ALL, NULLS FIRST/LAST
• embedded/sql: hash-aggregate for unindexed GROUP BY, per-session SQL parse cache, cached Engine catalog reused via Clone, prefix-fingerprint read-set
• embedded/sql: COALESCE, NULLIF, GREATEST, LEAST, EXTRACT, BETWEEN AND, ILIKE, STRING_AGG, RANDOM, GEN_RANDOM_UUID, TO_NUMBER, CONCAT_WS, REGEXP_REPLACE, LPAD, RPAD, SPLIT_PART, INITCAP, CHR, ASCII, MD5, TRANSLATE, DATE_TRUNC, TO_CHAR, DATE_PART, AGE, CLOCK_TIMESTAMP
• embedded/sql: PG-style CASE arm widening (scalar ↔ VARCHAR coerce at plan time, runtime converter matrix applies at reduce time)
• embedded/sql: EXPLAIN output for plan inspection
• pkg/pgsql/sys: full pg_catalog system tables — pg_class, pg_attribute, pg_index, pg_namespace, pg_am, pg_type, pg_database, pg_roles, pg_settings, pg_constraint, pg_description, pg_proc, pg_tables, pg_indexes, pg_views, pg_sequences, pg_attrdef, pg_collation, pg_inherits
• pkg/pgsql/sys: information_schema tables, columns, schemata, key_column_usage, table_constraints as real system tables
• pkg/pgsql/server: pg_catalog functions — format_type, pg_get_indexdef, pg_get_constraintdef, current_schemas, quote_ident, array_to_string, pg_total_relation_size, pg_relation_size, col_description, obj_description, pg_get_userbyid, has_{table,schema,database,function}_privilege
• pkg/pgsql/server/rewrite: AST-based SQL rewriter (beta) with 14 AST-level rewrite rules; feature-flagged via --pg-rewriter=ast, off by default
• pkg/pgsql/server: COPY FROM stdin protocol support
• pkg/server: structured audit logger with immutable audit trail (reload path, async flush, persistence through crashes)
• perf: BenchmarkJoin and BenchmarkIPAddrFromContext baselines; perf-delta regression comparator for perf-test-suite JSON
• remote/s3: server-side encryption on PUT; request latency/error metrics; AWS request IDs in logs

Changes

• pkg/pgsql/server: psql backslash commands (\d, \dt, \di, \dv, \dn, \df, \dT, \l, \du) route to engine passthrough against real catalog data
• pkg/pgsql/server: end-to-end integration with Rails ActiveRecord, XORM, Gitea, SQLAlchemy, JDBC and pgAdmin drivers
• pkg/pgsql/server: retire legacy pgschema resolver layer and canned pgAdminProbe/pgTables/pgIndexes/infoSchemaColumns handlers (~1500 LOC net deletion)
• embedded/tbtree: nodeAt fast/slow path restructure, slow-path re-check removal, Close-while-reading race fix, Mutex→RWMutex on node fetch
• embedded/store: vLog fast path for MaxIOConcurrency==1; syncer single-tx fast path skips 5 ms accumulation sleep; commit buffer + cLog entry reuse
• embedded/multiapp: appendable cache refcounted to eliminate close-while-reading race
• pkg/pgsql/server: RWMutex in pgsrv.GetPort and session activity update paths
• pkg/server: RLock in getLoggedInUserDataFromUsername; mutex-guarded MetricsCollection compute* callbacks
• pkg/server: correct IPv6 handling in per-client metrics and local-client identification
• remote/s3: SigV4 path encoding fix; HTTP timeout propagation; request body leak fix
• embedded/sql: MaxKeyLen raised 512→1024 with new --max-key-length flag
• dependencies: grpc bumped to v1.79.3 across four modules
• tests: pgsql integration tests migrated from jackc/pgx/v4 to v5
• docs: README restructured with PostgreSQL compatibility matrix; SQL engine contributing guide added; DIFF OF query docs; ScanRequest.sinceTx=0 clarification

Bug Fixes

• pkg/pgsql/server: psql \d <table> segfault caused by extractColumnNames dropping anonymous SELECT items
• pkg/pgsql/server: CREATE VIEW name(col1,col2) AS column-list form for pg_dump / F1DB dumps
• pkg/pgsql/server: COLLATE "C" k3s/kine DDL compatibility
• embedded/sql: CASE … END mixed-type errors replaced with engine-level widening
• pkg/pgsql/server: LIKE wildcards, ORDER BY alias, COUNT(DISTINCT) in PG wire path
• pkg/pgsql/server: ILIKE operator bug, UNION subquery panic, UNION column resolution, alias propagation
• pkg/pgsql/server: two pgsql COPY handler regressions; session timeout during COPY bulk imports
• embedded/sql: file-sort temp-file race on JOIN + GROUP + ORDER + LIMIT
• pkg/pgsql/server: quoted identifier and reserved-word renaming for PG-dump imports
• pkg/client: immuclient scan now supports listing all keys without prefix
• pkg/replication: revert A4 pipelined fetch (wrong for poll protocol)
• pkg/server: audit logger reliability (reload path, async flush)
• tests: server interceptor tests no longer contend on ports; HW-stats prober passes on tmpfs

<a name="v1.10.0"></a>

v1.11.0 — PostgreSQL Compatibility and SQL Feature Expansion

• Structured audit logging: New --audit-log flag records all gRPC operations as tamper-proof JSON events in systemdb, filterable via --audit-log-events (all/write/admin).
• PostgreSQL ORM compatibility: Added pg_catalog and information_schema virtual table resolvers to support ORM introspection from Django, SQLAlchemy, GORM, and ActiveRecord.
• immudb verification functions via SQL: immudb_state, immudb_verify_row, immudb_verify_tx, immudb_history, and immudb_tx are now accessible as SQL functions over the PostgreSQL wire protocol.
• PostgreSQL compatibility functions: current_database, current_schema, current_user, format_type, has_table_privilege, and many others; plus SHOW statement emulation for common ORM config queries.
• Subquery support: EXISTS, NOT EXISTS, IN, and NOT IN subqueries now fully implemented in the SQL engine.
• New JOIN types: CROSS JOIN and FULL OUTER JOIN added.
• Set operations: EXCEPT and INTERSECT implemented.
• New SQL functions: Math (ABS, CEIL, FLOOR, ROUND, POWER, SQRT, MOD), string (REPLACE, REVERSE, LEFT, RIGHT, REPEAT, POSITION), and conditional (NULLIF, GREATEST, LEAST).
• ORDER BY enhancements: NULLS FIRST / NULLS LAST syntax supported.
• Upserts: INSERT ... ON CONFLICT DO UPDATE SET implemented.
• Views: CREATE VIEW / DROP VIEW (session-scoped, not persisted to catalog).
• CTEs: WITH clause (Common Table Expressions) materialized and referenceable in the main query.
• Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE, NTILE, plus windowed aggregates (COUNT, SUM, MIN, MAX, AVG).
• EXPLAIN statement: Returns a human-readable query plan for any SELECT.

docs(scan): clarify that ScanRequest.sinceTx=0 waits for latest commi…

What's Changed

Comprehensive Helm chart configuration:

• Full configuration support for immudb via environment variables, TOML files (ConfigMap), command-line arguments, S3 storage, and secure credentials (Kubernetes Secrets).
• Chart version bumped to 1.9.8.

SQL feature expansion:

• Added COALESCE function for null value handling.
• Implemented EXTRACT FROM TIMESTAMP expressions.
• Implemented BETWEEN AND expressions.

Parser improvements:

• Huge restructuring of the parser to better support unreserved keywords in table and column names.

Testing & maintenance:

General improvements to code quality and internal SQL handling.

Downloads

Docker image
https://hub.docker.com/r/codenotary/immudb

immudb Binaries

immuclient Binaries

immuadmin Binaries

Bug Fixes

• display actual config file path in startup logs

Changes

• embedded/sql: add COALESCE function
• embedded/sql: Implement EXTRACT FROM TIMESTAMP expressions
• embedded/sql: Implement BETWEEN AND expressions

Features

• helm: Add comprehensive configuration support for ImmuDB

<a name="v1.9.7"></a>

What's Changed

Bug Fixes:

• TBTree timestamps are now saved to a separate file on close. This prevents redundant rescans of empty or unchanged indexes and optimizes performance by allowing the system to quickly identify and skip previously processed data.

Downloads

Docker image
https://hub.docker.com/r/codenotary/immudb

immudb Binaries

immuclient Binaries

immuadmin Binaries

Bug Fixes

• embedded/tbtree: save timestamp to a separate file to avoid rescanning empty indexes

<a name="v2.0.0-RC1"></a>

What's Changed:

Changes

1. Very significant performance improvement:

• Enhanced the efficiency of the JOIN algorithm in the SQL layer.
• Optimized the evaluation of the ORDER BY clause.
• Huge memory usage reduction for multi-database use cases.

2. SQL feature expansion:

Several enhancements to SQL functionality, such as:

• Support for LEFT JOIN, CASE statements.
• SELECT FROM VALUES syntax.
• Support for generic expressions in ORDER BY.
• PRIMARY KEY constraints on individual columns.

3. Query handling improvements:

• Fixes to logical operator precedence and implementation of constant selection queries for better query execution.

4. Enhanced PostgreSQL compatibility:

• Added support for core PostgreSQL system catalog tables (pg_class, pg_namespace, pg_roles), improving compatibility with Postgres clients and metadata management.

5. Monitoring and metrics:

• New Prometheus metrics for indexing and replication lag tracking to improve observability.

6. Testing & maintenance:

• Additional tests for the indexer and general code quality improvements, including SonarQube warning suppression.

Full Changelog: v1.9.5...v1.9.6

Downloads

Docker image
https://hub.docker.com/r/codenotary/immudb

immudb Binaries

immuclient Binaries

immuadmin Binaries

Bug Fixes

• embedded/sql: correctly handle logical operator precedence (NOT, AND, OR)

Changes

• embedded/sql: Support PRIMARY KEY constraint on individual columns
• embedded/sql: Add support for core pg_catalog tables (pg_class, pg_namespace, pg_roles)
• embedded/sql: add support for LEFT JOIN
• embedded/sql: add support for SELECT FROM VALUES syntax
• embedded/sql: Allow expressions in ORDER BY clauses
• embedded/sql: Add support for simple CASE statements
• embedded/sql: Implement CASE statement
• pkg/replication: add replication lag metric

<a name="v1.9.5"></a>

What's Changed:

Changes

1. Enhanced Index Flushing Algorithm:

• Memory usage of buffered data now also triggers flushing to disk.
• The index node cache is now shared across multiple indices for greater efficiency.
• Writes are now stalled at times to prevent high memory consumption during very intense write operations.

2. SQL Layer Enhancements:

• Support for selecting generic expressions has been added.
• Refactored the FnCall implementation for improved clarity and performance.
• Added support for INSERT INTO SELECT statements.
• Expanded the catalog of core built-in functions significantly.

3. Database Management:

• Databases are now opened and closed on demand, up to the MaxActiveDatabases limit, to reduce memory consumption when managing a large number of databases.

4. Automatic HTTPS Certificate:

• Introduced an option to start the server with an automatically generated self-signed HTTPS certificate.

5. Improved Logging and Auditing:

• Added log rotation based on file size and age for better log management.
• Introduced an option to log all server access for enhanced auditing.

Bug Fixes:

• Resolved an issue where large store.MaxValueSize values caused excessive memory consumption.
• Fixed the "max active snapshots" issue encountered when running queries from PostgreSQL compatible clients.
• Addressed problems with AWS Signature V4 using IAM roles.
• Corrected the improper use of time.Since in a defer statement.
• Fixed security vulnerability CVE-2024-41262 by ensuring the metrics server runs under HTTPS.
• Fixed an issue with gRPC-Gateway when HTTPS is enabled.

Full Changelog: v1.9.4...v1.9.5

Downloads

Docker image
https://hub.docker.com/r/codenotary/immudb

immudb Binaries

immuclient Binaries

immuadmin Binaries

Bug Fixes

• time.Since should not be used in defer statement
• pkg/dabase: return error when attempting to access deleted database
• pkg/pgsql/server: close row readers to release resources
• pkg/server: run metrics server under HTTPS

Changes

• embedded/logging: improve file base logging.
• embedded/sql: improvements on SQL layer.
• embedded/store: improve index flush logic
• pkg/database: implement database manager
• pkg/server: implement automatic generation of self-signed HTTPS certificate

<a name="v1.9.4"></a>

What's Changed:

Changes

• Add support for a new JSON data type;
• Add support for SQL CHECK constraints;
• Introduce SQL privileges to enable fine-grained control over statement execution;
• Add automatic injection of request information to transaction metadata to improve auditing;
• Introduce _tx_metadata reserved column to allow retrieving transaction metadata in SQL tables;
• Implement table import/export through immuadmin command;
• Add creation time and creator to database details listed by immuadmin;

Fixes:

• Fix startup error when S3 remote identifier is enabled;
• Fix immudb crash when updating same table twice in same transaction;

Full Changelog: v1.9.3...v1.9.4

Downloads

Docker image
https://hub.docker.com/r/codenotary/immudb

immudb Binaries

immuclient Binaries

immuadmin Binaries

Bug Fixes

• set mattermost payload

<a name="v1.9.3"></a>

Bug Fixes

• standard syntax for drop index
• embedded/sql: fix sql temporal range evaluation

Changes

• embedded/document: count with limit in subquery
• embedded/sql: expose subquery creation
• pkg/api: set optional parameters
• pkg/api: set optional parameters

<a name="v1.9.0-RC1"></a>

Bug Fixes

• insertion ts for key-values should not be equal to the current root ts
• correct immudb name in readme
• allow the local id to be used if present even if remote flag is on
• apply fixes discussed in PR
• Makefile: remove webconsole tag from immuclient/immuadmin builds
• embedded/appendable: explicit freebsd build clauses
• embedded/document: avoid waiting for tx to be committed
• embedded/document: ensure multi-indexing is enabled
• embedded/sql: advance position when decoding value at deleted column
• embedded/store: precommitted transaction discarding recedes durable state
• embedded/store: use correct index path
• embedded/store: handle transient key update
• embedded/store: read lock when fetching indexer
• embedded/store: read lock when pausing indexers
• embedded/tbtree: proper _rev calculation
• embedded/tbtree: snapshot validation
• embedded/tbtree: consider offset for history count calculation
• pkg/server: buffer reuse

Changes

• use copy instead of a loop
• build with swaggerui
• unnecessary use of fmt.Sprintf
• align covered packages when pulling and merging
• unnecessary use of fmt.Sprintf
• cmd/immuclient: display raw column selector in table header
• deps: bump golang.org/x/net from 0.10.0 to 0.12.0
• deps: bump google.golang.org/grpc from 1.55.0 to 1.56.2
• deps: bump golang.org/x/crypto from 0.13.0 to 0.14.0
• deps: bump golang.org/x/net from 0.14.0 to 0.15.0
• deps: bump google.golang.org/grpc
• deps: bump google.golang.org/grpc in /test/e2e/truncation
• deps: bump google.golang.org/grpc
• deps: bump golang.org/x/crypto from 0.12.0 to 0.13.0
• deps: bump golang.org/x/crypto from 0.10.0 to 0.11.0
• deps: bump golang.org/x/sys from 0.9.0 to 0.10.0
• deps: bump golang.org/x/net from 0.15.0 to 0.17.0
• deps: bump golang.org/x/sys from 0.11.0 to 0.12.0
• deps: bump golang.org/x/net from 0.12.0 to 0.13.0
• deps: bump golang.org/x/sys from 0.10.0 to 0.11.0
• deps: bump golang.org/x/crypto from 0.7.0 to 0.10.0
• deps: bump golang.org/x/net from 0.13.0 to 0.14.0
• deps: bump securego/gosec from 2.15.0 to 2.17.0
• deps: bump github.com/grpc-ecosystem/grpc-gateway/v2
• embedded/document: encoded document using valRef
• embedded/document: register username when applying a change
• embedded/document: attach username when auditing document
• embedded/document: enable multi-indexing in doc engine tests
• embedded/sql: support parenthesis as datatype constraint delimiter
• embedded/sql: multi-snapshop mvvc
• embedded/sql: deletion of primary index path
• embedded/sql: historical queries over primary index
• embedded/sql: dynamic indexing
• embedded/sql: post-commit physical index deletion
• embedded/sql: improve internal index naming
• embedded/sql: uuid decoding
• embedded/sql: unique index creation supported on empty tables
• embedded/sql: temporal queries with multi-indexing
• embedded/sql: transactional drops
• embedded/sql: use declared constant for fixed ids
• embedded/sql: insertion benchmark
• embedded/store: injective index mapper
• embedded/store: history returning value refs
• embedded/store: history with rev count
• embedded/store: ensure index is erased from disk
• embedded/store: indexer alloc its tx
• embedded/store: remove metastate
• embedded/store: multi-indexing
• embedded/store: key reader including historical entries
• embedded/store: ensure snapshot up to date
• embedded/store: indexing callbacks
• embedded/store: wip multi-indexing
• embedded/store: indexing prefix
• embedded/store: entry mapper
• embedded/tbtree: value-preserving history
• embedded/tbtree: fetching historical values
• embedded/tbtree: wip value-preserving history
• embedded/tbtree: context propagation
• embedded/tbtree: value-preserving history
• embedded/tbtree: hcount serialization
• pkg/api: adjust doc serializations to match verification
• pkg/api: endpoint improvements
• pkg/client: add setAll to immuclient mock
• pkg/client: use buf for msg exchange
• pkg/database: increase delay when tx is not present
• pkg/database: fix remote storage paths
• pkg/database: mandatory wait with async replication
• pkg/database: kv count
• pkg/database: doc audit without retrieving payloads
• pkg/database: context propagation
• pkg/database: context propagation
• pkg/database: multi-indexing database
• pkg/database: fix remote storage paths
• pkg/database: register username when applying a change
• pkg/database: keept reading from specific tx
• pkg/server: register username when applying a change in doc apis
• pkg/server: minor code adjustment
• pkg/stdlib: non transactional ddl stmts
• pkg/truncator: use embedded/logger package
• pkg/verification: minor doc verification improvements
• swagger: use embedded logger package
• tests: Tests cleanup

Code Refactoring

• pkg/logger: move logger from pkg to embedded

Features

• add flag for using external id as a main one
• update readme
• prevent identifier from creation when use external id option
• pass logger to heartbeater
• embedded/document: register user when creating collection
• embedded/document: doc audit without retrieving payloads
• embedded/document: add field to collection
• embedded/document: remove field from collection
• embedded/sql: dynamic multi-indexing
• embedded/sql: wip uuid datatype support
• embedded/sql: include _rev column in historical queries
• embedded/sql: drop index and table stmts
• embedded/sql: table history
• embedded/sql: query including historical rows
• embedded/sql: extra metadata when creating tx
• embedded/sql: async multi-indexing
• embedded/sql: drop column stmt
• embedded/store: getBetween
• embedded/store: use index attribute in kv metadata
• embedded/store: extra tx metadata
• embedded/store: transactionaless multi-indexing
• embedded/tbtree: getBetween
• embedded/tbtree: key reader supporting historical values
• pkg/api: include username in document audit response
• pkg/api: re-enable swagger ui
• pkg/api: docAudit returning timestamp and possibility to omit payloads
• pkg/api: add field and remove field endpoints
• pkg/database: add user when creating collection
• pkg/server: add user when creating collection

Reverts

• chore: remove initial swagger support

<a name="v1.5.0"></a>