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: https://github.com/codenotary/immudb/compare/v1.9.5...v1.9.6

Downloads

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

immudb Binaries

File | SHA256 ------------- | ------------- immudb-v1.9.6-darwin-amd64 | 4f9005be10055debd26c563f7f240b4043db7edd01fd854b9eafb076599624df immudb-v1.9.6-darwin-arm64 | 67a2cee2cc2952615435baeb5a60010a697c1ff6eb1bcd2a48700fbfda4d5bd2 immudb-v1.9.6-freebsd-amd64 | 428251185b9ffe5de904557d18997cc7c174244e1f4a5c214f099da20fe623a3 immudb-v1.9.6-linux-amd64 | 26a26b68c02a86b3464e669710bd77fb06ccdbbaca03f481c4706c3526c2c5f8 immudb-v1.9.6-linux-amd64-fips | b96c09654bef0208c48d4faf39f11d08c0ab9420b8584b32356cbfbd77dcd4bb immudb-v1.9.6-linux-amd64-static | b4eece2787d2ef77834bd966f821ecce937a5e4cc33b4f684dff480184740bda immudb-v1.9.6-linux-arm64 | 5db18862ca4ab53d60271c3e832369b477ad87a1ff32ef56b1cedf16250638d4 | 56516e93e21cc8a200e4629760ca8e7555c9e2b676aa49448bf5bb78ddec7511 | 53ed5e21233324e268f30d72cbd2976e1f3300c26d0a5c165b132e8e98b90b15

immuclient Binaries

File | SHA256 ------------- | ------------- immuclient-v1.9.6-darwin-amd64 | 28cf1b3b511554c0294e7925ed4dc489e7f68666a37cf6f1396bc6e04e764acc immuclient-v1.9.6-darwin-arm64 | 4f4555bf36d9fb014f48f44bd1322f19b27c4b01c822d54c328c9bebd1c6cf1e immuclient-v1.9.6-freebsd-amd64 | ef9e25bb30cef8ff4da49f6115b921e532954d4e0575844a24141aa7381c5203 immuclient-v1.9.6-linux-amd64 | 16e0d8e67253f253dc3ae1220f4aee84b3634eaa5c018e2b0729df0b03d4c11b immuclient-v1.9.6-linux-amd64-fips | a2018682860341ac98e477cb0172cb316dc3bf956ea731bbfee049547f1aaad2 immuclient-v1.9.6-linux-amd64-static | 3bce691e9ca5c88492fdba106c3692a8a521a38e2a85fcf97f3e25619fb761c6 | 49f162ce5ca9a073dcdc50ae18869eafb014507fcb6af5ad111e5b195596a2d6 | 75ab3fb7bb1a02d585b12fa006555161ed1a99c2373254121d99e9d88c8a7e40 | 905643944685c1ff6e84ac4efc6d0df57946537f6991b7a84ae91e7576c50663

immuadmin Binaries

File | SHA256 ------------- | ------------- immuadmin-v1.9.6-darwin-amd64 | ff59bbfa6ba5b227f1eb3c44b91abbd95bb73274595cae8b3a8be2612b321903 immuadmin-v1.9.6-darwin-arm64 | 4497202c41f12457209f3c6528fadac951a8700503acf4c14406b4e531be396d immuadmin-v1.9.6-freebsd-amd64 | 8153d68d02e37294f8763018b2a3af7073fb560e4bb234bd4e12060f1aacc751 immuadmin-v1.9.6-linux-amd64 | f8aa9d07342236a46eff49677d6b5dea11710ba7996a494b64fd3ce1a0e36b39 immuadmin-v1.9.6-linux-amd64-fips | c18f3633ed7efc1d32d9e9c6dd2b207707225b1a873af1085e84e875ac3f0ea5 immuadmin-v1.9.6-linux-amd64-static | c4166d2b26f55c204e4d8c0c7df62b70e5e4c0fcbad08966fe5f85c6626ef244 | 82ae3e80387b0c7a24a88da4acd0cda043d3361b2fbe46478683a8815092fe90 | 20b8d88e82bddb0b68c64a8ff6b5511fda01905117497a1417e28d0e9c50c294 | 89eb32f78a9c2e7bfa787b242956e6b181cb6f127d6e4bc5db2a6a67ce20e008