Immudb version 1.11.0

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.

v1.11.0-RC2

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.

v1.10.0

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

File	SHA256
immudb-v1.10.0-darwin-amd64	8095b9aa306508a0a4c0e421295c656702b8ecf84ee7c0566b689ab366a02cf1
immudb-v1.10.0-darwin-arm64	6cc63a6fa44a008193c28728ea5a2a505c8376cb931b153b09914780667e6e46
immudb-v1.10.0-freebsd-amd64	bb10011be16951da6fce8533b0ee878324664a8f138c08796f0a5824bac79e33
immudb-v1.10.0-linux-amd64	670edf1ec9caae52e0d0ab4efba102517a6059ba87f944f813902c9c5e972ed5
immudb-v1.10.0-linux-amd64-fips	482060478ad0437b697e6155a58c26c2c3cb65b91ea0942a03776186330eea0d
immudb-v1.10.0-linux-amd64-static	0befc52f8d6d1933f6fc01e56dda04523f4cb07c79317cc55458800e29d6dd9e
immudb-v1.10.0-linux-arm64	c67d871c78fd3e77217fa20d462a1c7a1cf2e3ebc4ebb51a97f8153de8011153
immudb-v1.10.0-linux-s390x	de2f5adaf567d907d017a5c78aa63d856880560ff09c895ce91b4ecf0065b971
immudb-v1.10.0-windows-amd64.exe	18d326883f0b65797679e726802cce98f967d572f227e496e09f5d24f0f8f565

immuclient Binaries

File	SHA256
immuclient-v1.10.0-darwin-amd64	47adec5b49daf39af13c8125a73643cab81eeb687c70206f164280d5279223ed
immuclient-v1.10.0-darwin-arm64	f22c743b311b9c255c3dc6e1c7906d759b9c1134940fec95a0acd48f91cc7802
immuclient-v1.10.0-freebsd-amd64	1688349ff0224b4f146ed6ea4102920ebe9fa7cd9152cdcaa05c59f97d8afcfc
immuclient-v1.10.0-linux-amd64	8e1105e27ba2546d0f7a8b5cec2b493887fd71eddd37d7d01e03237e41c7c273
immuclient-v1.10.0-linux-amd64-fips	027f994746c72bce9afa9d4969e0f23fad8bc651e6ea54b8b2d7b533844dafb4
immuclient-v1.10.0-linux-amd64-static	248c633d77c9198a67398ae7f6d377ebcde703ff4b0c12eaa3532c161cf4a675
immuclient-v1.10.0-linux-arm64	0c23263bf75a3f17ee280c9e64c980435f662de05c142cb54a49401db43390f9
immuclient-v1.10.0-linux-s390x	e612dc2f1b05655a1a0576ddf3b55e2249474a3a439b0200274ca45045b08f75
immuclient-v1.10.0-windows-amd64.exe	40da067b287a744fa6d7d6b66d1c06722989625c740060a72899c077479e15ae

immuadmin Binaries

File	SHA256
immuadmin-v1.10.0-darwin-amd64	a2810c367f271933d437d80067e79bf92b5f0172c66d9522eb3d7daa43d80f0e
immuadmin-v1.10.0-darwin-arm64	55aebf32155acade25551052c7346337bdb43caec9c6eb0888ded638ebe05a35
immuadmin-v1.10.0-freebsd-amd64	3fcfdf147f2989fd6984a2e3d565b9048ca40ada22fec98872a7832574d353c9
immuadmin-v1.10.0-linux-amd64	c931ea6656448a6c55756ed2d2333178cb442aa131127134d5aaae82c8fc7b9c
immuadmin-v1.10.0-linux-amd64-fips	9f527b42142eddd0bec87763ac7979cd1fe41c343b435d0f1e0a41acbb086cdb
immuadmin-v1.10.0-linux-amd64-static	dd444d542d8efa8faf7e6f3bb2a2ebfaff86a745c27a52fb3f40db4b83000fc6
immuadmin-v1.10.0-linux-arm64	45673efee8eb3a19e59b8a5f276e4423b25852373442c91bd7f9b0f418e87fa8
immuadmin-v1.10.0-linux-s390x	f77387c0925780ccf92e392aac95af37e7e7e16f11ebb74d2dff2df72518558e
immuadmin-v1.10.0-windows-amd64.exe	cb4d49af509d017e657c6f3f60c4006923f01c5ba041ca5b07908038c151da2a

v1.9.7

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

File	SHA256
immudb-v1.9.7-darwin-amd64	c672eebcd690dfe484b5248b70b5399e7ce752ab641fa6a1b18ba189626be8c2
immudb-v1.9.7-darwin-arm64	ff923dbf32d6fc903f45ac6f373d49e42e77b55e7860231d66122da3e8d7045d
immudb-v1.9.7-freebsd-amd64	be6801036a4f46980a8578071496352704d391c4834f2a17aa67bdd4f1069714
immudb-v1.9.7-linux-amd64	191769f8c3a175ef79e9f38036f60d65a43fc86d6a9d0518576ab7202ad367b4
immudb-v1.9.7-linux-amd64-fips	9cc21437aa4cb0bbdcd8bd0c568ea57b5907ac8587204505138b88edbfc91396
immudb-v1.9.7-linux-amd64-static	e3da19c67f8f1921d1f758557b137cf026ce10a10f4e9ee56d578c6e87b17e45
immudb-v1.9.7-linux-arm64	34eb0bb7e10de14308c7ee461f8bfbc7535f28fbf152cae3615d9731f045b9a9
immudb-v1.9.7-linux-s390x	10bec184b928ef547532a1e654559350d12a1a3895f23d48ab6e80d5306dd272
immudb-v1.9.7-windows-amd64.exe	679a03ba98b31cbab43462af12b42f667f48d5a2716cf0d31b7f3f261da4f57e

immuclient Binaries

File	SHA256
immuclient-v1.9.7-darwin-amd64	7b065f097463294a8d6089fa42693df55ee153f0898f4d98733fe187fded57cd
immuclient-v1.9.7-darwin-arm64	8daa705d78175354f8d4ec60ddfb4c6bb5db0d67e4af10a47dd7ac2810ee19ff
immuclient-v1.9.7-freebsd-amd64	e3c2ffd4bab5acf573c3cc39abc3d5e5e61ee183c0a1a71510a39b6e611ffd03
immuclient-v1.9.7-linux-amd64	c336220372f95282c1325e25ee789e7c565124f633c369598c335e1e42c2bb78
immuclient-v1.9.7-linux-amd64-fips	8419e029ed597af31425614f524875d104e21e99d8023108db7a6a50890999d8
immuclient-v1.9.7-linux-amd64-static	21d6666d863121a77b1d5dcf3be6bf3f24cfd822726a17c9a8e3c9ecff07dfe9
immuclient-v1.9.7-linux-arm64	7a3735beabbd85a00908122b61c5ca4fb9894c3c45338aa271eca62880d129e2
immuclient-v1.9.7-linux-s390x	c629d1514b7f4f733cefe6b9943210d70731e9c42c24c58f60b2620f48bbbdd9
immuclient-v1.9.7-windows-amd64.exe	95602b094749fd8b94a862ca1f71620988d40c55374b0883a99409965c961fe6

immuadmin Binaries

File	SHA256
immuadmin-v1.9.7-darwin-amd64	675e2d911dfaaec8284ea6ea3fc7d20819711c2f8903ded1da7d35a91efef730
immuadmin-v1.9.7-darwin-arm64	0f0a9bbbe9fd14967423c2984d31abc53ac37bcaf418d81e3de1b9b9360c9317
immuadmin-v1.9.7-freebsd-amd64	50576e01f10375a1e065e93793d7cdf8aebfddbc85166f0e42dd203b4e1f2dd3
immuadmin-v1.9.7-linux-amd64	93834d27b50adf3bfcfc4f23294c276916c2434b072ce5bc65200d8b24053fea
immuadmin-v1.9.7-linux-amd64-fips	945a028a5b82e90b146e32c3046ecca7cc8b85cfb6cb2136a473a6ec09c1b9a1
immuadmin-v1.9.7-linux-amd64-static	ed33f26de9b5354a4e2d89b46b20d9a6e6f352206e69a8006e6aca4150b81d32
immuadmin-v1.9.7-linux-arm64	854be07f9fb15109a1ab173934ea10d3fd3ddbd6a7a72365e315bb53760523c8
immuadmin-v1.9.7-linux-s390x	3006d2bf88951bded18064ea6af42270cfc0882348da0b49d675d64201978586
immuadmin-v1.9.7-windows-amd64.exe	1cf3272e5575d42af776579f32591ff9746c0af9f49e7c7400d148c86e8005d9

v2.0.0-RC1

🚀 What's New in v2.0.0

immudb is a high-performance, tamper-evident database built for integrity and trust. Version 2.0.0 introduces major architectural advancements, performance enhancements, and simplification of the API for a more powerful and streamlined developer experience.

🧠 Indexing Layer Redesign

The indexing layer has been rebuilt using a low-level page abstraction model.

• Pages are fixed-size (4KB) byte arrays.
• Benefits:
  • Predictable memory consumption
  • Enhanced performance under high load
  • Improved in-memory resource control

🔀 Multi-Ledger Storage Architecture

immudb now supports a new storage layer that enables multi-ledger operation.

• Multiple databases (ledgers) can share:
  • Indexing resources
  • Page write buffers
  • Caches
• Benefits:
  • More efficient memory usage
  • Scalable for multi-tenant environments
  • Reduced resource overhead

💾 Storage Engine Improvements

• Higher read/write throughput
• Enhanced internal consistency mechanisms
• Optimized memory and resource management

---

💥 Breaking Changes

❌ Document Model Deprecated

The Document Model API has been removed in favor of SQL-based JSON support.

• Advantages:
  • Standards-compliant support for unstructured data
  • Advanced querying capabilities
  • Better alignment with immudb’s integrity guarantees

---

⚙️ Upgrade Notes

If you are using the deprecated Document Model, migrate your application to use the SQL-based JSON features.

---

📚 Documentation

Full documentation, migration guides, and API references are available at:
👉 https://docs.immudb.io

---

Full Changelog: v1.9.6...v2.0.0-RC1

Downloads

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

immudb Binaries

File	SHA256
immudb-v2.0.0-RC1-darwin-amd64	f586fbc8f290d831cddacc6f5326af38552eaab73df433d7fb9ce510053c4d42
immudb-v2.0.0-RC1-darwin-arm64	5fcc64069b12444aa5c410399518030a4e91588c8e28a043ec63a00d9018b6cd
immudb-v2.0.0-RC1-freebsd-amd64	aa9f87e13309e5c72de02a51defc4c029c189d0322e3a01f6ae58ab22308ea45
immudb-v2.0.0-RC1-linux-amd64	aa46fd4d2aa82446f6d1049690f6ec44e1dd4c40d85e0e1318258aef5a02ba4e
immudb-v2.0.0-RC1-linux-amd64-fips	3bbbae9f63d4c7ca7ccc5cd9e5d802fbdbeed4c8e7c5f1ca459748fc23d008ca
immudb-v2.0.0-RC1-linux-amd64-static	71f2bced0cf2d89e044361fc7522b977437e5f9dbf0d378d0b863ea4e7cdbbfa
immudb-v2.0.0-RC1-linux-arm64	ccc2c9d89e972e186d4fa696b4239c884c8513721ac0115831a22dddac924cca
immudb-v2.0.0-RC1-linux-s390x	3dd73b7ca4ad1d0da53e756441d431fdf8cc8f835f5dadfb325933ed38bc98dd
immudb-v2.0.0-RC1-windows-amd64.exe	6afb1f79057179f1d4787939de39d1f1e43e5bb4b4ccf7bb798bbc99a704e055

immuclient Binaries

File	SHA256
immuclient-v2.0.0-RC1-darwin-amd64	29a82e51d780bbf0ee061048552d96e7f8c5e716f983070f357a06c8e4c0e0bc
immuclient-v2.0.0-RC1-darwin-arm64	5bdf8461a723f158bb5e86c34caf6107172d7d6598482a507c49121b11725579
immuclient-v2.0.0-RC1-freebsd-amd64	c406f35c6248406d136e77f0cc69127679c87e2a15f0cb2505c6030d51eb2013
immuclient-v2.0.0-RC1-linux-amd64	7d53e8338dea3c89b48ba5d771872a557f508226f360bef12217cd6b3107e97c
immuclient-v2.0.0-RC1-linux-amd64-fips	69654b97bb9474ab7665aa7464f563058435d35755f8ad32ed53ceaacd0b06d5
immuclient-v2.0.0-RC1-linux-amd64-static	277f81fc7778c44d2efc111219131ccc3f0d09d152e33fc49d928f0e7bc5505c
immuclient-v2.0.0-RC1-linux-arm64	06dc35584706c38c5067c07d66c9aa83b39895d5e3b83dcf340de50b7aabea78
immuclient-v2.0.0-RC1-linux-s390x	7f5063defdb2c170681b0897b267e267684c7fc2276202261d1eba6e7a2191a1
immuclient-v2.0.0-RC1-windows-amd64.exe	190f9c25dcf99fe0154123872949fe5e8da0a326115115583099824cfc30f9ca

immuadmin Binaries

File	SHA256
immuadmin-v2.0.0-RC1-darwin-amd64	a92e80f1e64f86fa74d8548d15c50111f459509e21e82b09db7b3804eb058822
immuadmin-v2.0.0-RC1-darwin-arm64	dd525362b65f29f4501d11bad7fa77f7ac78c529fabbb2fb4c777400297f21e9
immuadmin-v2.0.0-RC1-freebsd-amd64	8afcee05c0ef911c49c46028374ad095f94989edc9a9c766afec0968fbc8a021
immuadmin-v2.0.0-RC1-linux-amd64	61951b39c8c36e0e5ecf3ef38966da45e75c8477e40c6437d847bf505ccd4e57
immuadmin-v2.0.0-RC1-linux-amd64-fips	5a1d2daf2ea238c1167e703c9636ff8f36c79726a888f4444afcc442a8eb7d2a
immuadmin-v2.0.0-RC1-linux-amd64-static	0eb4b723b8c06f966a43142bb32dd023757a22b4f24f6a947dad44e6c6f4c3ef
immuadmin-v2.0.0-RC1-linux-arm64	8173b2ad12ffd4b3efd4c9c88340613fc962a1c06c4fb41023033d368dfcb9c5
immuadmin-v2.0.0-RC1-linux-s390x	aebfb4b4406146f5a46136cae7778186a60069992c37e80eeaf2f43f3330c35b
immuadmin-v2.0.0-RC1-windows-amd64.exe	78b7a619857089359276c4922f278bd691016069ac427592bb7982673c888149

v1.9.6

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

v1.9.5

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

File	SHA256
immudb-v1.9.5-darwin-amd64	156d0d748b2700a800aa1744ea8e59f5e281196418535ca25f991877901fadf8
immudb-v1.9.5-darwin-arm64	19636722efb1448a679dc9036200af1375bc7329336cd232db8b915f14702f38
immudb-v1.9.5-freebsd-amd64	5b8365c287f70d05112ae405302281822e693a2be525ffa0093c6b35d68a9325
immudb-v1.9.5-linux-amd64	9e79a23676c4841fc4c324ae2577c777c91020647b01458ef9897154027d2922
immudb-v1.9.5-linux-amd64-fips	d3b6e402fdaa6aa7231b834bac346c7dec4a8a80d73d8d6b8e3357e02b5af4cd
immudb-v1.9.5-linux-amd64-static	7087115bba86e49524b69e71ca17074513fffaafacf7948e10ac6d9e907106c6
immudb-v1.9.5-linux-arm64	e2aa69a6625d6a0ac69ea93ed6a59b9f6a4fd4ff3b5b95df06d869e65b73a710
immudb-v1.9.5-linux-s390x	83ef859f8e201bacbf7931cadabe38969fa5283c25f4dad05cd5452885483f39
immudb-v1.9.5-windows-amd64.exe	855b44b3f5822ada5f60f831e08a99a53a3c07bbc655960979db1586a774cf2a

immuclient Binaries

File	SHA256
immuclient-v1.9.5-darwin-amd64	251f8379aeaa72534191272e7b1762c4fe9fd69e1b0250401269331de3abe072
immuclient-v1.9.5-darwin-arm64	869f0a4e8269c653235fb31596fb5f89d1fc99ff29cfd3fde77d8e97e45f08c0
immuclient-v1.9.5-freebsd-amd64	f43f726cc66f18babec94dca662836690f96b6406e3a0c61be2f9b34cadf246f
immuclient-v1.9.5-linux-amd64	f64e7a64c6d3ddc9ed42395b3edaed5956eb48bd689d6df120d351396a5f6e90
immuclient-v1.9.5-linux-amd64-fips	5ca385b34c0523ea59c49bfb92ec089847d17ceeea493eee8b8656b7e72b9209
immuclient-v1.9.5-linux-amd64-static	bb16d090be5290ec6cbec5d6a06f4c46663dee8dfcb64e281dfaa61475cd7c0d
immuclient-v1.9.5-linux-arm64	92f43e21b80790f2ade2b13920f043b54586dd59ca155fd2287e91a03a12f044
immuclient-v1.9.5-linux-s390x	1b1c73b5a997de23b96ec127f9586c28f7929c3e78dc2844118705d5207626c4
immuclient-v1.9.5-windows-amd64.exe	95e5a13c424e47a6e4436f4d1c702afaeb0ecd44fe2b2a3b4b34ad2b34e86c24

immuadmin Binaries

File	SHA256
immuadmin-v1.9.5-darwin-amd64	64137011000d71356e4b61c0b7cab059256d75dd93e309d856fa5ed58f45e2e9
immuadmin-v1.9.5-darwin-arm64	fcb647aa666872803ec3884b0954e4de30007c5ed3f04940f45969241e4ad4eb
immuadmin-v1.9.5-freebsd-amd64	bdc3ccab782f611ac6c314713b80e613b9dad739f16ea88b2fd9cb64baa6678c
immuadmin-v1.9.5-linux-amd64	33af8a8f4add8ec21246bb7fa3b9abf32fe8520a2254a317e848dd759298f6cb
immuadmin-v1.9.5-linux-amd64-fips	29260a0c2a130efcef50f12b141f70ef4f09784fd5d0f5262af3feacf43f8c53
immuadmin-v1.9.5-linux-amd64-static	acdddadd011ac06638190645f2adcc1e7d1b4cbd8cf20be5411d7877fad137f6
immuadmin-v1.9.5-linux-arm64	da43b1db55793760d90a40d081cba0c9283a3ca47ff020dc81a2374f9bfc1013
immuadmin-v1.9.5-linux-s390x	60b4d3374cff6bc79079d5f846f5f8a789b7bb2edd2e50c0e6ef2545b3038872
immuadmin-v1.9.5-windows-amd64.exe	2a971c1b1dcf8a062add8ebc75da9907d8ef91b963edbe7362248190638693f2

v1.9.4

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

File	SHA256
immudb-v1.9.4-darwin-amd64	6f54f39ab83e51d591cafa1291fb5d866b34bf8d489f197ec669fead76ba88e8
immudb-v1.9.4-darwin-arm64	59cba57196beefcd610380fa7191e3eb915bded3ee35676ea3b9506df3cff896
immudb-v1.9.4-freebsd-amd64	e77318675dfc8f7d294c49d40d4eb2b27347ed720f3d9e7293fd0a9741977b3d
immudb-v1.9.4-linux-amd64	8512e1d3e042e88081b66a5feca26dc0d70cc57ae807e626349e3886c16016be
immudb-v1.9.4-linux-amd64-fips	066fcfdf463978a3da0e59036c81bdb0d82a3664a08c6cf1ca947f7ffaddbf95
immudb-v1.9.4-linux-amd64-static	7203e749f08315e7d9013f8f2bb2df3e7234117925e16e386b53dc5a1b58f0c7
immudb-v1.9.4-linux-arm64	8726cd650461ac172bc8945a0c88e24e37018a877458f33dad1fe7a51dddd807
immudb-v1.9.4-linux-s390x	c18cb5e2a5cd83348643f6329198629c2a916ff09f03fa3fb7b1bd7291c90560
immudb-v1.9.4-windows-amd64.exe	fda0a81f8b69a8bf417c81eadad300af5d8e14c880e819f9db71a2dfd4750537

immuclient Binaries

File	SHA256
immuclient-v1.9.4-darwin-amd64	454b2df932dbd316fa2d72f361bfbdd6e7fe8e23156632d8aeab90d75ac76bc7
immuclient-v1.9.4-darwin-arm64	ea66c9e0be0dacbacb48722c17a31e8a4848d0ded5bdfebbefcdbff1004705fa
immuclient-v1.9.4-freebsd-amd64	ab1b7c1494b113d58c4530df2f2211cb29e17d5d9fb3082d03e2564bedf74f82
immuclient-v1.9.4-linux-amd64	8e11ef6de72787edd7bd2ebe630ec081d9d4a03106a9ae9a51536dc172e29604
immuclient-v1.9.4-linux-amd64-fips	fce65df00999b8de9d3c399e9b6f959deb02f27204414aae52dba206f7a9408c
immuclient-v1.9.4-linux-amd64-static	9c64dd9fc490f9f4a2c5bf80903ea2d0298c5f813ef1e292a029d6d910fb2fd1
immuclient-v1.9.4-linux-arm64	c912a6021c4e04916bc400f64fd8ca5b5a143bb4e73474bd97360370b8ab6322
immuclient-v1.9.4-linux-s390x	060317fe65f47223f0b00f38daca6ae088ae90db49ee11e1be9f2324252f9baf
immuclient-v1.9.4-windows-amd64.exe	e10155ca8b1479c1845e6f126e832a74bccb5e7fb147fba1b60bd584019db97c

immuadmin Binaries

File	SHA256
immuadmin-v1.9.4-darwin-amd64	a4455d69327fd19e560ac9fb0a335587f1446433212aa9753cd8d5a87b8b888f
immuadmin-v1.9.4-darwin-arm64	1daa6a652634a6b8dcdaa1ff632b61b81b359e4275ee80ea3e04e478d51f5d27
immuadmin-v1.9.4-freebsd-amd64	307847507535d909fb3c87527d6a6a3cfe43d37510bdf1df8964447836673cf0
immuadmin-v1.9.4-linux-amd64	8d0d58183f7f1f3051cd425438b81603a118da83bd6485cbea550d252726a708
immuadmin-v1.9.4-linux-amd64-fips	aeb61ee2e64bd77da69adacbd2feef43ba507002ea06cd3188c1e9a971a313d7
immuadmin-v1.9.4-linux-amd64-static	8904719120cb6b7c5ffda2c0032faaea5d5a7baf0e2a2917bdbb1abcdeca762f
immuadmin-v1.9.4-linux-arm64	98a2d8e9487e1d3ccafa2598a5ee9279b437fff4a0ac8fb66c5337c3e9a0d2bf
immuadmin-v1.9.4-linux-s390x	f2c409dda1508d2c0d76b33449ef8f1a89b8ce2dc85687c204f38a6d167d2a4b
immuadmin-v1.9.4-windows-amd64.exe	dc4f4b7de3beef95c9c654cdcaa1c722e96e970e3b8096ba5525714e5d84dd20

v1.9.3

What's Changed

Changes

• Replaced LRU (least recently used) caching policy with SIEVE algorithm, resulting in improvement of caching efficiency by up to 60%;
• Significantly reduced memory consumption of indexes by using pooling and by bounding the byte size of the cache, by up to 48%;
• Support compaction of indexes when S3 storage is enabled;
• Way more instrumentation reported by immuadmin database and status subcommands;
• Relaxed password hassling of user;
• Significantly improved coverage of SQL GROUP BY and ORDER BY clauses;
• Indexes are no more required on the GROUP BY/ORDER BY fields:
  • Arbitrary number of fields are now supported;
  • Index selection has been optimised to reduce query times;
• Support streaming in SQLQuery/TxSQL rpcs to allow fetching arbitrary number of query results from:
  • client SDKs;
  • PG compatible clients;
  • Golang database/sql std package;

Fixes

• Fix off by one error when LIMIT clause is used;
• Add missing constraint checks that prevent indexer from getting stuck;
• Prevent replication between different immudb versions;

Full Changelog: v1.9DOM.2...v1.9.3

Downloads

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

immudb Binaries

File	SHA256
immudb-v1.9.3-darwin-amd64	fd725a8837b4e03e2a6ea9ef8a3a37d6f172a2798cbd2f26da338100388ae132
immudb-v1.9.3-darwin-arm64	0be357f17dd3ef7c67fee07a1ffd441fd9400bb40dc05c3bbd12d69e28920a5a
immudb-v1.9.3-freebsd-amd64	193adae5b203860127ef3a0aef32760d5ddc4cc9671d57d310ed29d4c80765b5
immudb-v1.9.3-linux-amd64	33babff774077ec239972071016d357def6dd9d49b0a77b6cb9f3845b9a37f9d
immudb-v1.9.3-linux-amd64-fips	2e656c67f2ba8d858ee0d98df818635ae5fd376f2862768a337e80ae53eed93d
immudb-v1.9.3-linux-amd64-static	367b513073cf513de992ee9e67bf3b700b0dea9512598f3df71ddf9b7160f68c
immudb-v1.9.3-linux-arm64	56ff6f8a16296fdd844025766245ab0b0903341411137c006334ffa80a8747ec
immudb-v1.9.3-linux-s390x	f21572edaaa75f139115332db4a35155ef06d3cbd9c53ba08335bdc4a19ac4bf
immudb-v1.9.3-windows-amd64.exe	2393fc2e41c31eec064a74ece1670dfc306da56f2136a616c90ece0a775b80cc

immuclient Binaries

File	SHA256
immuclient-v1.9.3-darwin-amd64	e52aad338b41304de182a82d52e5b3981f32b1e64ffd7a50a6364fe3a40d30ca
immuclient-v1.9.3-darwin-arm64	cd691c724d7f6bc56082fb008fefed6eaefba85c1439caf17faa53b7fbe9589e
immuclient-v1.9.3-freebsd-amd64	f7d0953eab7b773edcdbb713835aedacbd49be7ca9d0b3301642062c89452b5b
immuclient-v1.9.3-linux-amd64	55936da403d049c668d46d9629d3b6c7b9b9f0bb0c35f0bfb711ff4ec001623f
immuclient-v1.9.3-linux-amd64-fips	52c3d998e7efabd00f60539674c7cd5127f97d9137933abb728969a3a958a263
immuclient-v1.9.3-linux-amd64-static	1ffa1c554a506fad5d4883738c013157497c0a170d3ab9082cbc8872adb2fdad
immuclient-v1.9.3-linux-arm64	51b77825e92dc4fd53a92e5f1ecfde290edef3d715621510f239f779a630a9d5
immuclient-v1.9.3-linux-s390x	8254d295f0cf47eaa5088fb5afe7f662228c4c754ccb2fb6100600e2eaff83ef
immuclient-v1.9.3-windows-amd64.exe	9e744e09a87de969ac2542c5d9abde79c960c64ef9a44244eef100e506317a56

immuadmin Binaries

File	SHA256
immuadmin-v1.9.3-darwin-amd64	b4b6641f028262784f65a97235e1be510c541dd81301ededa2fc5f8b07bb2931
immuadmin-v1.9.3-darwin-arm64	43291a9f823d019d33c36f766b1b406fba630625b23f96042100b76bf57333eb
immuadmin-v1.9.3-freebsd-amd64	7e9b372df412ac32a57d1792065b82a9b492282bcdbfef3b6eef898d568b573c
immuadmin-v1.9.3-linux-amd64	e7366ec7187820021596e837c81065120b539f1fa36b8c3c28c873514ea38ac2
immuadmin-v1.9.3-linux-amd64-fips	61a52028291998f5cff2c9e2c021cce1ef11f0ff9366b93b575e3cced8258e46
immuadmin-v1.9.3-linux-amd64-static	912f807a418c84f876e4a15a5c68a09240c4962b03e8721aa4e99786b0b0be34
immuadmin-v1.9.3-linux-arm64	a56f4cb84f183688f24ef9f8caa9a51d3863982873ebb9962fa66514793062c1
immuadmin-v1.9.3-linux-s390x	0ad389823401a6d0cd4ab036e7987c72484e46afc9fd97cdf9d6ea43422ab873
immuadmin-v1.9.3-windows-amd64.exe	44bf20cb0963669f4902239c16ccdfd00f0a6c41423607b20709e3d9160837c0

v1.9DOM.2

What's Changed

Fixes:

• fix: source /etc/sysconfig/immudb on AWS EC2 startup by @SimoneLazzaris in #1875
• fix: apply fix for CVE-2023-44487 by @SimoneLazzaris in #1908

Changes:

• Update README.md by @jeroiraz in #1874
• feat: automatically convert uuid strings and byte slices to uuid values by @tauu in #1870
• feat s3role rebased by @jeroiraz in #1876
• chore(deps): bump golang.org/x/crypto from 0.14.0 to 0.17.0 by @dependabot in #1893
• license update to BSL by @SimoneLazzaris in #1905
• chore(deps): bump google.golang.org/protobuf from 1.31.0 to 1.32.0 by @dependabot in #1909
• chore(deps): bump google.golang.org/grpc from 1.57.0 to 1.57.1 in /test/e2e/truncation by @dependabot in #1903
• chore(deps): bump actions/download-artifact from 3 to 4 by @dependabot in #1892
• chore(deps): bump actions/upload-artifact from 3 to 4 by @dependabot in #1891
• chore(deps): bump actions/setup-go from 3 to 5 by @dependabot in #1887

Full Changelog: v1.9DOM.1...v1.9DOM.2

Downloads

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

immudb Binaries

File	SHA256
immudb-v1.9DOM.2-darwin-amd64	443cad5a177b5f35ddc377bcd3a67bfbc8c1a60385aee9c5f30ead5d83809505
immudb-v1.9DOM.2-darwin-arm64	6f1227cffd777abc4452763c5a4987c42465c68b6e4b2effd7c03bbd9bb2972e
immudb-v1.9DOM.2-freebsd-amd64	9b1100c1948ac23f19426d816566b6886db2ce473a00d6c51b6bd22fb81ce627
immudb-v1.9DOM.2-linux-amd64	3e675fa8a6f6cbe72c529343e94a5440172800825db022e9f61686e6e23e3623
immudb-v1.9DOM.2-linux-amd64-static	d06db1641d968c6ba3dd891373e51f29d20052fd2cd67c63d86b48e43a966a32
immudb-v1.9DOM.2-linux-arm64	1d99fb69519c1119dfd23deb6487d703cc2965289c1064fe534b973c5942228a
immudb-v1.9DOM.2-linux-s390x	fafac16fc8e4c922f2a53fb97f6b5dd280a28cdf13ffa09f8895d94a3b18ce6d
immudb-v1.9DOM.2-windows-amd64.exe	9892b795e0f54207e5e847a8319708c09e1aeb8c67d7a254e1ea1f72248795b6

immuclient Binaries

File	SHA256
immuclient-v1.9DOM.2-darwin-amd64	56ab0ce11d2951dc74fd84970bceba5f03473434fa1238f9d1aa5672bc276e3c
immuclient-v1.9DOM.2-darwin-arm64	cb34c3c9dd529d4c17d20b8ae74029d8550b7fe8ad230aba26f70e783beaec68
immuclient-v1.9DOM.2-freebsd-amd64	231c4d7660f6a2ab18e788b5d38cba288cfc3013e4f4f4913e6cc3d1640dbb45
immuclient-v1.9DOM.2-linux-amd64	5445b4a41590e630d5d416f82ff0315e7f579b27e216820a972ea5d1b8617102
immuclient-v1.9DOM.2-linux-amd64-static	ff30fed639ad137b50c4eb29be78c3cfbadd994914bbb2d510d1d3900edb19fa
immuclient-v1.9DOM.2-linux-arm64	8ccc615cf2d906981081fa012dbcd443f9928c36e81144b5c8174b95cc1ba4be
immuclient-v1.9DOM.2-linux-s390x	5a647b6e7b3af4f0acd91a23b0b9045b56cde830ae1af9961762aa4217d07d25
immuclient-v1.9DOM.2-windows-amd64.exe	9453aeea10ff1fe8df943fac726f4fc258b7427390c5308fc878b71fa9c830d0

immuadmin Binaries

File	SHA256
immuadmin-v1.9DOM.2-darwin-amd64	7feb1415ba0d3c8a2f61b0da0fc85c212b63dd3d0a6ac5ecb0177b6d867371e4
immuadmin-v1.9DOM.2-darwin-arm64	e274ebe58b68179b4d9f7c8b2f54e2e3b8a23ffbb75641fbe55b70975710d636
immuadmin-v1.9DOM.2-freebsd-amd64	afc72d4ad49af90829dcab9c81d26c0c36fe29892276b97c24ae0c57138a0e62
immuadmin-v1.9DOM.2-linux-amd64	0c1c188644d751d9b485baf522fb65e93a3e791a01a29bfc4b80990d29feb86a
immuadmin-v1.9DOM.2-linux-amd64-static	faa227cfcef270db6f0908d3ee4823e0f9c4e3d65caef255fffefe81a51b9fe8
immuadmin-v1.9DOM.2-linux-arm64	d59290dd1037cebc05a2b89a119361772375e5bff94fc5fdfb2fd7799c914820
immuadmin-v1.9DOM.2-linux-s390x	22d3e7b5c6f446ed4cfb9d2d1f166b2e9c027c89df3f1a58c38ae1ec9c2138f1
immuadmin-v1.9DOM.2-windows-amd64.exe	26e61484ab2714700d2e95aa4fadf78011d2c931e17c0b12eb0433da43b99130