ArcadeDB v25.7.1 Release Highlights

We are excited to announce the general availability of ArcadeDB version 25.7.1!

This is a significant maintenance release that focuses on improving stability, enhancing SQL query functionality, and introducing powerful new capabilities for users running ArcadeDB on Kubernetes. Thank you to our dedicated community and contributors for making this release possible.

✨ What's New

Dynamic Kubernetes Storage with Helm: For our users leveraging Kubernetes, our Helm chart now supports the dynamic allocation of Persistent Volumes. This makes scaling your database with multiple replicas simpler and more automated, especially in cloud environments.

We temporary removed the recent "hidden properties" feature for a back compatibility issue with sql query using *, we're going to add it again in the future with better test coverage.

🐛 Key Bug Fixes & Improvements

This release addresses several bugs to improve the reliability and consistency of the database.

SQL Query Engine Fixes: A significant number of fixes have been applied to the SQL engine to improve consistency and correctness.

The behavior of graph traversal functions like $inE()$, $outE()$, and $bothE() has been standardized for consistency (#1590, #2371). The $size() function now provides the correct output when used with chained graph functions (#2372). Addressed inconsistencies in $SELECT$ queries to ensure predictable results, regardless of whether a wildcard (*) is used (#2378).

Data Integrity and Stability

Addressed a critical issue with unique indexes to ensure data integrity constraints are correctly enforced (#2345). Improved the reliability of creating and updating edges when using a remote database connection, ensuring smoother operations in distributed setups (#1578, #2351). Resolved NullPointerException errors that could occur when the database directory has incorrect file permissions, improving startup resilience (#2362).

Operational Improvements

Failed backup operations performed via HTTP will now correctly return an error status code for better automation and error handling (#2244). The official Docker image now includes curl to make diagnostics and scripting easier (#2373).

🛠️ Other Notable Changes

Improved Testing Framework: Our end-to-end (e2e) test suite has been migrated to use Testcontainers, leading to more robust and reliable automated testing. This internal improvement helps us ensure higher quality releases.

Dependency Updates: This release also includes numerous dependency updates to incorporate the latest security patches and improvements from upstream libraries.

Full Changelog: 25.6.1...25.7.1

ArcadeDB v25.6.1 Release Highlights

We're excited to announce ArcadeDB v25.6.1!

This release brings significant improvements in stability, performance, and developer experience.

We've focused on enhancing remote transaction handling, providing more robust server-side retry mechanisms, and updating our dependency management for a smoother development process.

For those leveraging ArcadeDB Studio, you'll find new end-to-end tests ensuring a more reliable experience.

We've also addressed several important bug fixes and made notable changes to the Docker image and Helm chart for easier deployment and management.

We highly recommend upgrading to take advantage of these enhancements!

✨ New Features

• Tx explicit lock (#2292)
• Migrate Docker image to Temurin-alpine (#2319, closes #2316)
• [Helm] Allow multiple replicas by addressing hardcoded serverList (#2325, closes #2324)
• Add extra environment variables to Helm chart (#2308, closes #2307)
• Improve Studio: add package manager and update third-party libraries (#2260, closes #2259)
• Remote property types enhancements (#2247)
• Add end-to-end tests for ArcadeDB Studio database creation and management (#2290)
• Add server-side retry configuration for remote database commands (#2255, closes #2236)
• Add performance testing for single server load in ArcadeDB (#2305, closes #2304)
• Enhance load testing with increased user and friendship counts (#2321)

🐛 Bug Fixes

• Support for remote transaction retry on the server side (#2254)
• Refactor notification system to use Notyf, fixing Studio notification display (#2327, closes #2323)
• Incorrect field type retrieved on RemoteDatabase with get(<prop>) resolved (related to #2246)
• Issue with RemoteDatabase.reload() addressed (related to #2243)
• Remote database no longer automatically converts Float to Double (related to #1700)
• Edge case of partial written record resolved (related to #2282)
• Concurrent modification on page issue fixed (related to #2187)
• Massive insertion (multiple threads/buckets + non-unique index) timeout/excessive retries addressed (related to #2258)
• Concurrent modification error on the same bucket (@v25.3.2) resolved (related to #2236)
• Error reported in the log during performance testing addressed (related to #2175)

🛠️ Other Notable Changes

• Update entity type references for consistency across importer formats (#2245)
• Security Fix: Upgraded the commons-beanutils library to version 1.11.0 to resolve a security vulnerability identified by a Meterian security scan (#2288)
• Add Docker as dependency to developer guide (#2331)
• Refactor load test implementation to use DatabaseWrapper and enhance parameters (#2329)
• Dependency Updates: Numerous dependencies have been bumped to their latest versions, including junit.jupiter.version, github/codeql-action, io.netty, org.postgresql, io.micrometer, jest, docker/setup-buildx-action, pg, de.bwaldvogel:mongo-java-server, lucene.version, testcontainers.version, org.sonatype.central:central-publishing-maven-plugin, and org.apache.tomcat:tomcat-jdbc.

Full Changelog: 25.5.1...25.6.1

ArcadeDB v25.5.1 Release Highlights

This release of ArcadeDB brings exciting new features, important bug fixes, and several under-the-hood improvements to enhance performance and developer experience.

✨ New Features

• Encrypted Backup and Restore: Secure your data with the new encrypted backup and restore functionality ( #2222).
• SQL ifempty Function: A new SQL function ifempty has been introduced for more flexible data handling ( #2185).
• Iterable Graph Java API: Vertex and Edge types now return a new Iterable Graph Java API, offering more convenient ways to work with graph data ( #2228).
• Improved SQL Backup: The BACKUP DATABASE SQL command has been enhanced for better functionality and logging ( #2198, #2200).

🐛 Bug Fixes

• Cypher Parametric Queries over JDBC: Refactored Cypher to properly support parametric queries when using JDBC ( #2169).
• Postgres Driver CPU Usage: Fixed an issue causing the Postgres driver to consume 100% CPU on idle connections ( #2229).

🛠️ Other Notable Changes

• Adopted more Java 21 idiomatic code for modernization ( #2143).
• Improved SQL function implementations and added more tests ( #2186).
• The nightly builds link in the README has been updated ( #2220).
• Test workflow speed has been improved ( #2201).
• Deployment of Maven artifacts has been migrated to the Central portal ( #2197, #2218).
• Numerous dependencies have been updated to their latest versions, enhancing security and stability.

Full Changelog: 25.4.1...25.5.1

Summary

ArcadeDB version 25.4.1 introduces significant modernizations, most notably migrating the core dependency from Java 17 to Java 21 and enabling HTTP/2 support. Key new features include an improved connection strategy for High Availability setups, the ability to define unidirectional edges in the schema, an improved space reclaim, and the adoption of Java's modern HttpClient for remote operations.

This release also addresses numerous bugs, enhancing stability and performance. Critical fixes were applied to resolve issues with the HTTP serializer, asynchronous index rebuilding, SQL behavior (including default values and INSERT/UPDATE logic), edge deletion, GraphQL documents, Studio login, HTTPS connections, and several problems within the Postgres driver concerning null values and query results. Additionally, the release incorporates various miscellaneous improvements to builds, documentation, testing, and updates numerous dependencies.

New Features

• Migration from Java17 to Java21 #2081
• RemoteDatabase in HA using a HTTP Proxy - implemented new connection strategy "FIXED" #2101
• Unidirectional edges should be defined at schema level #2093
• Wipeout freespace by @lvca in #2125
• Enable HTTP/2 support in HttpServer for both HTTP and HTTPS listeners by @ExtReMLapin in #2122
• Replace httpUrlConnection with HttpClient on RemoteHttpComponent by @robfrank in #2123

Bugs fixed

• HTTP Serializer is slow when using long arrays of floats #2126
• SQL REBUILD INDEX deletes indexes when used via async HTTP-API #2097
• SQL: Mandatory property is not using default value instead errors #1919
• SQL INSERT vs UPDATE for a Vertex Type using JSON payload and @cat Behavior for Remote API #2060
• Delete of edge uses wrong index if many edges are present #2092
• GraphQL Embedded Document Bug #2103
• Login is not working in studio #2160
• Java RemoteDatabase class doesn't accept HTTPS protocol #2077
• Postgres driver column is omitted when all values are null #2110
• Postgres driver @Rid and @type are null for cypher queries #2111
• Postgres driver returns nothing with INSERT INTO .... RETURN @Rid but RID with RETURN @rid.asString() #2038
• fix cypher psycopg rid and types being returned as null, closes #2038 and #2111 by @ExtReMLapin in #2112
• Fixes columns with null values not being returned by pg driver | closes #2110 by @ExtReMLapin in #2113
• Async rebuild index by @lvca in #2118

Misc

• Nightly Snapshots are the "headless" release variant but should be "general" variant #1996
• #2081 fix readme by @robfrank in #2095
• Add Bluesky logo to README by @gramian in #2131
• Add note about docker image rebuilding by @gramian in #2147
• fix #2160 (studio login) by @gramian in #2162
• Fix doc links in studio by @gramian in #2166
• Refactor REUSE part 2 by @gramian in #2142
• #2119 test: add parameterized query tests for JdbcQueries and psycopg2 by @robfrank in #2146
• #1996 feat: add maven deploy plugin configurations for full, minimal,… by @robfrank in #2148
• Add globalConfiguration.resetAll in tests by @robfrank in #2115
• Fix JSONTest by @gramian in #2129
• Make repo REUSE compliant by @gramian in #2130
• Refactor REUSE by @gramian in #2140

Dependencies Updated

• build(deps): bump lucene.version from 9.12.1 to 10.1.0 by @dependabot in #1983
• build(deps): bump org.codehaus.mojo:javacc-maven-plugin from 3.1.0 to 3.1.1 by @dependabot in #2137
• build(deps): bump actions/setup-node from 4.3.0 to 4.4.0 by @dependabot in #2173
• build(deps): bump io.micrometer:micrometer-core from 1.14.5 to 1.14.6 by @dependabot in #2172
• build(deps): bump graalvm.version from 24.2.0 to 24.2.1 by @dependabot in #2171
• build(deps): bump io.micrometer:micrometer-registry-prometheus from 1.14.5 to 1.14.6 by @dependabot in #2170
• build(deps): bump lucene.version from 10.1.0 to 10.2.0 by @dependabot in #2157
• build(deps-dev): bump @testcontainers/postgresql from 10.24.0 to 10.24.2 in /e2e-js by @dependabot in #2158
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.5 to 11.0.6 by @dependabot in #2153
• build(deps): bump actions/setup-java from 4.7.0 to 4.7.1 by @dependabot in #2151
• build(deps): bump github/codeql-action from 3.28.13 to 3.28.15 by @dependabot in #2152
• build(deps): bump com.google.code.gson:gson from 2.12.1 to 2.13.0 by @dependabot in #2155
• build(deps): bump io.fabric8:docker-maven-plugin from 0.45.1 to 0.46.0 by @dependabot in #2156
• build(deps): bump junit.jupiter.version from 5.11.4 to 5.12.2 by @dependabot in #2154
• build(deps): bump org.mockito:mockito-core from 5.15.2 to 5.17.0 by @dependabot in #2159
• build(deps): bump org.apache.maven.plugins:maven-failsafe-plugin from 3.5.2 to 3.5.3 by @dependabot in #2138
• build(deps-dev): bump @testcontainers/postgresql from 10.23.0 to 10.24.0 in /e2e-js by @dependabot in #2139
• build(deps): bump org.jacoco:jacoco-maven-plugin from 0.8.12 to 0.8.13 by @dependabot in #2132
• build(deps): bump org.apache.maven.plugins:maven-surefire-plugin from 3.5.2 to 3.5.3 by @dependabot in #2135
• build(deps): bump io.netty:netty-all from 4.1.119.Final to 4.2.0.Final by @dependabot in #2136
• build(deps): bump io.netty:netty-transport from 4.1.119.Final to 4.2.0.Final by @dependabot in #2134
• build(deps): bump actions/setup-python from 5.4.0 to 5.5.0 by @dependabot in #2105
• build(deps): bump github/codeql-action from 3.28.12 to 3.28.13 by @dependabot in #2104
• build(deps): bump com.mycila:license-maven-plugin from 4.6 to 5.0.0 by @dependabot in #2108
• build(deps-dev): bump @testcontainers/postgresql from 10.21.0 to 10.23.0 in /e2e-js by @dependabot in #2109
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.22 to 3.0.23 by @dependabot in #2106

Full Changelog: 25.3.2...25.4.1

Summary

Hello community! This is the second release of March 2025 containing important fixes and improved the check database fix command.

Note: All ArcadeDB releases are 100% compatible with the previous ones in terms of database format, so there is no need to upgrade the database or export/import it for the upgrade, but please make a backup/copy of your database before upgrading.

New Features

• Java RemoteDatabase now accepts HTTPS protocol #2077

Misc

• Return exit status from console if error occurs in bulk mode by @gramian in #2078
• #2061 enhance type mapping form ArcadeDB to Postgres protocol by @robfrank and @ExtReMLapin in #2074
• Add toJson and toMap to Remote Vertex and Edge by @robfrank in #2056
• cleanup tests by @robfrank in #2054

Bugs fixed

• DuplicatedKeyException: Duplicated key [zone1, device1] found on index 'zone_device[from_id,to_id]' already assigned to record #2089
• Remote Vertex and Edge type is "d" rather than "v" or "e" #2055

Dependencies Updated

• build(deps): bump github/codeql-action from 3.28.10 to 3.28.11 by @dependabot in #2044
• build(deps-dev): bump testcontainers.version from 1.20.5 to 1.20.6 by @dependabot in #2050
• build(deps): bump org.apache.maven.plugins:maven-install-plugin from 3.1.3 to 3.1.4 by @dependabot in #2045
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.4 to 11.0.5 by @dependabot in #2046
• build(deps): bump docker/login-action from 3.3.0 to 3.4.0 by @dependabot in #2071
• build(deps): bump dorny/test-reporter from 1.9.1 to 2.0.0 by @dependabot in #2072
• build(deps): bump io.micrometer:micrometer-registry-prometheus from 1.14.4 to 1.14.5 by @dependabot in #2069
• build(deps): bump io.micrometer:micrometer-core from 1.14.4 to 1.14.5 by @dependabot in #2068
• build(deps): bump pg from 8.13.3 to 8.14.0 in /e2e-js by @dependabot in #2066
• build(deps-dev): bump @testcontainers/postgresql from 10.18.0 to 10.20.0 in /e2e-js by @dependabot in #2065
• build(deps): bump pg from 8.14.0 to 8.14.1 in /e2e-js by @dependabot in #2076
• build(deps-dev): bump @testcontainers/postgresql from 10.20.0 to 10.21.0 in /e2e-js by @dependabot in #2075
• build(deps): bump com.mycila:license-maven-plugin from 4.6 to 5.0.0 by @dependabot in #2088
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.17 to 1.5.18 by @dependabot in #2087
• build(deps): bump graalvm.version from 24.1.2 to 24.2.0 by @dependabot in #2086
• build(deps): bump github/codeql-action from 3.28.11 to 3.28.12 by @dependabot in #2085
• build(deps): bump actions/setup-node from 4.2.0 to 4.3.0 by @dependabot in #2084

Full Changelog: 25.3.1...25.3.2

Summary

Hello community! We're excited to announce the release of ArcadeDB 25.3.1 early in the month. This release contains a MAJOR CHANGE in the storage engine: fully reusage of the deleted space in the database and recycling of record ids (RIDs). All ArcadeDB releases are 100% compatible with the previous ones in terms of database format, so there is no need to upgrade the database or export/import it for the upgrade, but please make a backup/copy of your database before upgrading.

New Features

• Reuse of RIDs of deleted records #1391
• New check database compress sql command to compress the database pages by @lvca in #2022
• Default date and datetime implementation now use new Java classes by @lvca in #2021
• Initial impl of helm chart by @milesgranger in #2037
• perf: use the first space found instead of the best by @lvca in #2035

Misc

• Enhance PostgresType to support array types (serialization, not deserialization) by @ExtReMLapin in #2017
• Move python test to dedicated module #1997
• test: add test for postgres driver handling of generic lists and ARRAY_OF_FLOATS by @ExtReMLapin in #2039
• #1997 add end-to-end Python tests and setup in CI workflow by @robfrank in #2034

Bugs fixed

• Incorrect Date storage #2020
• Triple quote in cypher string + multiline = error #1780 by @ExtReMLapin
• replace test identities with Albert Einstein by @gramian in #2040
• Update tests by @gramian in #2042

Dependencies Updated

• build(deps): bump docker/setup-buildx-action from 3.9.0 to 3.10.0 by @dependabot in #2032
• build(deps): bump docker/setup-qemu-action from 3.4.0 to 3.6.0 by @dependabot in #2031
• build(deps): bump org.apache.groovy:groovy from 4.0.25 to 4.0.26 by @dependabot in #2030
• build(deps): bump io.netty:netty-all from 4.1.118.Final to 4.1.119.Final by @dependabot in #2029
• build(deps): bump org.apache.maven.plugins:maven-deploy-plugin from 3.1.3 to 3.1.4 by @dependabot in #2028
• build(deps): bump io.netty:netty-transport from 4.1.118.Final to 4.1.119.Final by @dependabot in #2024
• build(deps): bump slf4j.version from 2.0.16 to 2.0.17 by @dependabot in #2023
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.16 to 1.5.17 by @dependabot in #2025
• build(deps): bump org.apache.maven.plugins:maven-install-plugin from 3.1.3 to 3.1.4 by @dependabot in #2027
• build(deps): bump org.mockito:mockito-core from 5.15.2 to 5.16.0 by @dependabot in #2036

New Contributors

• @milesgranger made their first contribution in #2037

Full Changelog: 25.2.1...25.3.1

Summary

Hello community! We're excited to announce the release of ArcadeDB 25.2.1 which contains many bug fixes and general improvements. In the next release (25.3.1), we're going to introduce a MAJOR CHANGE in the storage engine: the long time needed reuse of the deleted space in the database. All ArcadeDB releases are 100% compatible with the previous ones in terms of database format, so there is no need to upgrade the database or export/import it for the upgrade.

Bugs fixed

• LSM Tree index optimization #1988
• Fix studio db tabs sync | fixes #1979 by @ExtReMLapin in #1980
• #1956 fix PGSQL when used with JS/npm pg driver by @robfrank in #1959
• In STUDIO, if there is 4 or less character selected, ignore it and just send the whole editor query by @ExtReMLapin in #1978
• refactor setDatabaseSetting for step-by-step decoding by @robfrank in #2014
  fixed notify usage in JS | fixes by @ExtReMLapin #1976 #1977
• Improve Fetch-From-Type Warning in Log #1940

Misc

• Update contributing guide (#1960) [skip ci] by @gramian in #1960
• refactor test reporting in CI workflow for unit and IT tests by @robfrank in #2015
• fix testSQLMath() by @robfrank in #1935
• #1937 fix content type of prometheus endpoint to text/plain by @robfrank in #1938
• #1974 add js e2e tests using pg driver by @robfrank in #1975
• Fix inconsistent naming HSNW to HNSW by @gramian in #2003
• #1989 fix failing IT tests by @robfrank in #1990

Dependencies Updated

• build(deps): bump jline.version from 3.28.0 to 3.29.0 by @dependabot in #1942
• build(deps): bump actions/setup-python from 5.3.0 to 5.4.0 by @dependabot in #1946
• build(deps): bump github/codeql-action from 3.28.1 to 3.28.8 by @dependabot in #1945
• build(deps): bump actions/setup-java from 4.6.0 to 4.7.0 by @dependabot in #1944
• build(deps): bump com.google.code.gson:gson from 2.11.0 to 2.12.1 by @dependabot in #1943
• override versions of groovy and netty to solve security issues by @robfrank in #1955
• build(deps): bump docker/setup-buildx-action from 3.8.0 to 3.9.0 (#1950) [skip ci] by @dependabot in #1950
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.20 to 3.0.21 (#1953) [skip ci] by @dependabot in #1953
• build(deps): bump github/codeql-action from 3.28.8 to 3.28.9 (#1951) [skip ci] by @dependabot in #1951
• build(deps): bump docker/setup-qemu-action from 3.3.0 to 3.4.0 (#1952) [skip ci] by @dependabot in #1952
• #1439 fix properties mapping on Projection by @robfrank in #1954
• build(deps): bump io.netty:netty-all from 4.1.117.Final to 4.1.118.Final by @dependabot in #1968
• build(deps): bump org.apache.groovy:groovy from 4.0.24 to 4.0.25 by @dependabot in #1965
• build(deps): bump io.micrometer:micrometer-registry-prometheus from 1.14.3 to 1.14.4 by @dependabot in #1967
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.2 to 11.0.3 by @dependabot in #1964
• build(deps): bump io.micrometer:micrometer-core from 1.14.3 to 1.14.4 by @dependabot in #1966
• build(deps): bump io.netty:netty-transport from 4.1.117.Final to 4.1.118.Final by @dependabot in #1963
• build(deps): bump pg from 8.13.1 to 8.13.3 in /e2e-js (#1986) [skip ci] by @dependabot in #1986
• build(deps-dev): bump @testcontainers/postgresql from 10.17.2 to 10.18.0 in /e2e-js (#1987) [skip ci] by @dependabot in #1987
• build(deps-dev): bump jest-junit from 12.3.0 to 16.0.0 in /e2e-js (#1984) [skip ci] by @dependabot in #1984
• build(deps): bump github/codeql-action from 3.28.9 to 3.28.10 by @dependabot in #2012
• build(deps): bump org.apache.maven.plugins:maven-compiler-plugin from 3.13.0 to 3.14.0 by @dependabot in #2011
• build(deps-dev): bump testcontainers.version from 1.20.4 to 1.20.5 by @dependabot in #2009
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.3 to 11.0.4 by @dependabot in #2008
• build(deps-dev): bump org.awaitility:awaitility from 4.2.2 to 4.3.0 by @dependabot in #2007
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.21 to 3.0.22 by @dependabot in #1994
• build(deps): bump org.yaml:snakeyaml from 2.3 to 2.4 by @dependabot in #1993

Full Changelog: 25.1.1...25.2.1

Summary

Hello community! We're pleased to announce the release of ArcadeDB 25.1.1.

The main news of this release are:

• New JSONL importer, able to import ArcadeDb exports in JSONL format
• Added support for Micrometer + Prometheus for metrics
• You can now define hidden properties that won't show up when you execute a select * ...
• New types (documents, vertices and edges) are created with 1 bucket by default

What's New

• New Import/Export components for JsonL #1922
• Replace internal metrics with Micrometer #1850
• Add "hidden" property attribute by @gramian and @robfrank in #1847
• Improve console batch mode by @gramian in #1692
• Changed default buckets per type to 1 by @lvca in #1903
• SelectCompiled from Native-Select - add method size() by @robfrank #1724

Bugs fixed

• Big result set are not serialized using Postgres wrapper #1871
• SQL: Out-of-memory when CREATE EDGE ... IF NOT EXISTS for existing edges with array of destination vertices #1763
• Inconsistent behavior between Cypher vs SQL query with one field indexed while other not #1898
• Neo4J JSONL import allows NULL on node but not on relationship properties #1904
• CSV Importer is limited to max 4096 chars per column #1873
• #1515 fix date formatting in JSONObject, add tests by @robfrank in #1887
• #1922 fix failing neo4j import test by @robfrank in #1932
  pull/1914

Misc

• chore: anonymize data by @robfrank in #1872
• chore: use @EnabledOnOs and @DisabledOnOs annotations in tests by @robfrank in #1862
• chore: more idiomatic java 17, remove "i" prefix by @robfrank in #1916
• #1922 JSONL: importer, tests, fixes to exporter by @robfrank in #1930
• Fix code scanning alert no. 157: Insecure randomness by @robfrank in #1917
• Potential fix for code scanning alert no. 115: Insecure randomness by @robfrank in #1921
• chore: fix after anonymization by @robfrank in #1915
• #1898 complete review of SelectExecutionPlanner by @robfrank in #1900
• #1873 update 'Copyright 2021" to "Copyright 2021-present" by @robfrank in #1891

Dependencies Updated

• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.17 to 3.0.18 by @dependabot in #1868
• build(deps): bump github/codeql-action from 3.27.6 to 3.27.9 by @dependabot in #1867
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.1 to 11.0.2 by @dependabot in #1866
• build(deps): bump jline.version from 3.27.1 to 3.28.0 by @dependabot in #1865
• build(deps): bump github/codeql-action from 3.27.9 to 3.28.0 by @dependabot in #1883
• build(deps): bump actions/setup-java from 4.5.0 to 4.6.0 by @dependabot in #1882
• build(deps): bump docker/setup-buildx-action from 3.7.1 to 3.8.0 by @dependabot in #1881
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.12 to 1.5.15 by @dependabot in #1880
• build(deps): bump junit.jupiter.version from 5.11.3 to 5.11.4 by @dependabot in #1879
• build(deps): bump io.micrometer:micrometer-core from 1.13.6 to 1.14.2 by @dependabot in #1876
• build(deps-dev): bump org.assertj:assertj-core from 3.26.3 to 3.27.0 by @dependabot in #1878
• build(deps): bump io.netty:netty-transport from 4.1.115.Final to 4.1.116.Final by @dependabot in #1875
• build(deps): bump io.micrometer:micrometer-registry-prometheus from 1.13.6 to 1.14.2 by @dependabot in #1874
• build(deps): bump mockito-core.version from 5.14.2 to 5.15.2 by @dependabot in #1894
• build(deps-dev): bump org.assertj:assertj-core from 3.27.0 to 3.27.2 by @dependabot in #1893
• build(deps): bump org.mockito:mockito-core from 5.14.2 to 5.15.2 by @dependabot in #1896
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.18 to 3.0.19 by @dependabot in #1897
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.15 to 1.5.16 by @dependabot in #1895
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.19 to 3.0.20 by @dependabot in #1907
• build(deps): bump docker/setup-qemu-action from 3.2.0 to 3.3.0 by @dependabot in #1909
• build(deps): bump github/codeql-action from 3.28.0 to 3.28.1 by @dependabot in #1908
• build(deps-dev): bump org.assertj:assertj-core from 3.27.2 to 3.27.3 by @dependabot in #1923
• build(deps): bump io.netty:netty-transport from 4.1.116.Final to 4.1.117.Final by @dependabot in #1924
• build(deps): bump org.postgresql:postgresql from 42.7.4 to 42.7.5 by @dependabot in #1925
• build(deps): bump io.micrometer:micrometer-core from 1.14.2 to 1.14.3 by @dependabot in #1926
• build(deps): bump io.micrometer:micrometer-registry-prometheus from 1.14.2 to 1.14.3 by @dependabot in #1927
• build(deps): bump graalvm.version from 24.1.1 to 24.1.2 by @dependabot in #1931
• build(deps): bump de.bwaldvogel:mongo-java-server from 1.45.0 to 1.46.0 by @dependabot in #1885

Full Changelog: 24.11.2...25.1.1

Summary

Hello community! We're pleased to announce the release of ArcadeDB 24.11.2 just in time for the holidays. This is expected to be our final release for 2024, barring any critical updates, and we're already looking ahead to 2025 with plans for the 2025.1.1 release.

This release contains 2 main optimizations you should consider when upgrading:

• Shared Memory Page Manager: now pages are collected on a centralized Page Manager to easily manage hundreds of databases open on a single JVM. Before 24.11.2, each database had its own PageManager with page cache + flush thread. Now both the page cache and the flush thread are shared across all the databases.
• If you're executing a massive insertion, especially post database creation, you can disable the backup lock increasing insertion speed of +30% in multi-threads. On a 2019 MacBook Pro we tested 4.3M/s records inserted (simple schema, 1 unique indexed property)

Special thanks to all the usual contributors and the new ones. This month ExtReMLapin (handle on GitHub) made his first contribution.

What's New

• Shared Memory Page Manager: centralized cache for page manager to support hundreds of databases on a single JVM by @lvca in #1853
• Disable backup lock for embedded massive insertion gaining +33% insertion speed by @lvca in #1852
• Support inverse iteration of records at bucket level #1854
• Add version number to Studio sidebar by @gramian in #1820
• #1832 add support for unidirectional edge creation on remote database by @robfrank in #1834

Bugs fixed

• fix: return value of CREATE PROPERTY for DEFAULT attribute by @gramian in #1831
• Fixed html injection based on node content by @ExtReMLapin in #1849
• fix: supported SQL size() on records #1855 by @lvca in #1856
• fix: supported IPV6 in HA configuration by @lvca in #1860
• remove npe on closing in TomcatConnectionPoolPostgresWJdbcTest #1845

Misc

• Remove "UpdateEdge" and "DeleteEdge" SQL Commands by @gramian in #1784
• replace StringBuilder and string concatenation with text block by @robfrank in #1840
• cleanup quorum configuration by @robfrank in #1833

Dependencies Updated

• build(deps): bump github/codeql-action from 3.27.0 to 3.27.1 by @dependabot in #1824
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 11.0.0 to 11.0.1 by @dependabot in #1823
• build(deps): bump io.netty:netty-transport from 4.1.114.Final to 4.1.115.Final (#1826) [skip ci] by @dependabot in #1826
• build(deps): bump github/codeql-action from 3.27.1 to 3.27.4 (#1827) [skip ci] by @dependabot in #1827
• build(deps): bump org.codehaus.mojo:versions-maven-plugin from 2.17.1 to 2.18.0 by @dependabot in #1828
• build(deps): bump github/codeql-action from 3.27.4 to 3.27.5 by @dependabot in #1838
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.16 to 3.0.17 by @dependabot in #1837
• build(deps-dev): bump testcontainers.version from 1.20.3 to 1.20.4 by @dependabot in #1836
• build(deps): bump github/codeql-action from 3.27.5 to 3.27.6 by @dependabot in #1858
• build(deps): bump org.apache.maven.plugins:maven-javadoc-plugin from 3.11.1 to 3.11.2 by @dependabot in #1857

New Contributors

• @ExtReMLapin made their first contribution in #1849

Full Changelog: 24.11.1...24.11.2

What's New

• Switched to Java17 as minimum requirement by @robfrank in #1806
• Implemented ALTER TYPE oldName NAME newName operation by @daffodilistic in #1501

Bugs fixed

• Fixed issue on creating a replicated database by @lvca in #1794
• Fixed operators in, contains, containsany and containsall by @lvca in #1796
• Fixed "NULL IN [NULL]" by @gramian in #1805
• Fixed return value of ALTER PROPERTY for DEFAULT attribute by @gramian in #1802
• Minor speedup with iterator by @gramian in #1791
• Refactor "map2json" by @gramian in #1790

Misc

• fix: re-enable pre-commit by @robfrank in #1758
• Fix code scanning alert no. 45: Implicit narrowing conversion in compound assignment by @robfrank in #1768
• Add upload SARIF to workflow by @robfrank in #1767
• fix: remove meterian token and add oss true flag by @robfrank in #1747
• pre-commit reconf (#1748) [skip ci] by @robfrank in #1748
• #1753 add opens module to all scripts by @robfrank in #1754
• Fix code scanning alert no. 86: Client-side cross-site scripting by @robfrank in #1769
• #1764 migrate form Junit5 Assertions to AssertJ by @robfrank in #1765
• #1756 migrate build and runtime in docker file to java 17 by @robfrank in #1757
• #1781 remove CodeQL workflow in favor by @robfrank in #1782
• fix: fixed broken HA test, reduced errors in console on HA replication by @lvca in #1795
• use maven wrapper instead by @robfrank in #1783
• Revert "use maven wrapper instead" by @robfrank in #1797
• Review and improve some tests by @robfrank in #1798
• #1761 fix coverage report: run always by @robfrank in #1799
• #1761 fix jacoco configuration by @robfrank in #1800
• improve security: add sha to gihub actions by @robfrank in #1804
• fix: add version 1.9.1 to test-report by @robfrank in #1807
• Review Codacy and Jacoco Configuration by @robfrank in #1808
• #1624 fix missing dependencies of plugins (gremlin, postgreswl...) by @robfrank in #1818
• Add empty argLine property by @robfrank in #1801

Dependencies Updated

• build(deps): bump mockito-core.version from 5.13.0 to 5.14.1 by @dependabot in #1752
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 10.1.30 to 11.0.0 by @dependabot in #1751
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.8 to 1.5.10 by @dependabot in #1750
• build(deps-dev): bump org.apache.tomcat:tomcat-jdbc from 10.1.30 to 11.0.0 by @dependabot in #1777
• build(deps): bump org.mockito:mockito-core from 5.14.1 to 5.14.2 by @dependabot in #1774
• build(deps): bump jline.version from 3.27.0 to 3.27.1 by @dependabot in #1772
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.10 to 1.5.11 by @dependabot in #1770
• build(deps): bump io.undertow:undertow-core from 2.3.17.Final to 2.3.18.Final by @dependabot in #1773
• build(deps): bump mockito-core.version from 5.14.1 to 5.14.2 by @dependabot in #1779
• build(deps): bump junit.jupiter.version from 5.11.2 to 5.11.3 by @dependabot in #1786
• build(deps-dev): bump testcontainers.version from 1.20.2 to 1.20.3 by @dependabot in #1787
• build(deps): bump graalvm.version from 22.3.5 to 24.1.1 by @dependabot in #1776
• build(deps-dev): bump ch.qos.logback:logback-classic from 1.5.11 to 1.5.12 by @dependabot in #1788
• build(deps): bump actions/setup-python from 5.2.0 to 5.3.0 by @dependabot in #1789
• build(deps): bump gremlin.version from 3.7.2 to 3.7.3 by @dependabot in #1803
• build(deps): bump actions/checkout from 4.2.1 to 4.2.2 (#1813) [skip ci] by @dependabot in #1813
• build(deps): bump zgosalvez/github-actions-ensure-sha-pinned-actions from 3.0.15 to 3.0.16 (#1812) [skip ci] by @dependabot in #1812
• build(deps): bump org.apache.maven.plugins:maven-failsafe-plugin from 3.5.1 to 3.5.2 (#1811) [skip ci] by @dependabot in #1811
• build(deps): bump org.apache.maven.plugins:maven-javadoc-plugin from 3.10.1 to 3.11.1 (#1809) [skip ci] by @dependabot in #1809
• build(deps): bump org.apache.maven.plugins:maven-surefire-plugin from 3.5.1 to 3.5.2 (#1810) [skip ci] by @dependabot in #1810

Full Changelog: 24.10.1...24.11.1