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
| 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 |
| immudb-v1.9.6-linux-s390x | 56516e93e21cc8a200e4629760ca8e7555c9e2b676aa49448bf5bb78ddec7511 |
| immudb-v1.9.6-windows-amd64.exe | 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 |
| immuclient-v1.9.6-linux-arm64 | 49f162ce5ca9a073dcdc50ae18869eafb014507fcb6af5ad111e5b195596a2d6 |
| immuclient-v1.9.6-linux-s390x | 75ab3fb7bb1a02d585b12fa006555161ed1a99c2373254121d99e9d88c8a7e40 |
| immuclient-v1.9.6-windows-amd64.exe | 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 |
| immuadmin-v1.9.6-linux-arm64 | 82ae3e80387b0c7a24a88da4acd0cda043d3361b2fbe46478683a8815092fe90 |
| immuadmin-v1.9.6-linux-s390x | 20b8d88e82bddb0b68c64a8ff6b5511fda01905117497a1417e28d0e9c50c294 |
| immuadmin-v1.9.6-windows-amd64.exe | 89eb32f78a9c2e7bfa787b242956e6b181cb6f127d6e4bc5db2a6a67ce20e008 |