Skip to content

Releases: ArcadeData/arcadedb

23.7.1

14 Aug 22:44
Compare
Choose a tag to compare

What's New

  • Vector Embeddings

    • Support for Vector API from Gremlin #1181
  • Engine

    • Speedup count of records #1182
    • Constraints for edges #1174
    • Support for before/after read of record events #1175
  • SQL

    • New SQL method asRecord() to return a record from an identifiable object (RID) #1170
  • Studio

What We Fixed

  • Fail to replicate after creation of a new database in Leader #1207
  • Postgres driver does not return metadata such as @Rid and @type #1173
  • When showing the schema in Studio, labels with ':' aren't shown #1169
  • ArcadeDB Studio java.lang.ArrayIndexOutOfBoundsException #1165
  • Vector: Server hangs after vector import and restart #1162
  • Ensure distance functions have only first letter in upper case #1160

Misc

Dependencies Updated

  • [Snyk] Fix for 6 vulnerabilities by @arcade-player in #1178
  • build(deps): bump MeterianHQ/meterian-github-action from 1.0.13 to 1.0.15 by @dependabot in #1197
  • build(deps-dev): bump ch.qos.logback:logback-classic from 1.4.8 to 1.4.11 by @dependabot in #1205

Full Changelog: 23.6.1...23.7.1

23.6.1

05 Jul 04:02
Compare
Choose a tag to compare

What's New

  • Vector Model

    • New Vector Model to manage embeddings - implementation preview by @lvca in #1148
  • Gremlin

    • Support Query Profiler for Gremlin (and Cypher) #1128
  • Studio

    • Display all property features under schema panel #1153
    • New Server Errors/Warnings panel #1134
    • New Summary dashboard in Server Tab #1130
    • Highlight the text to execute

What We Fixed

  • SQL

    • Order by on an indexed property does not work anymore after the sequence of insert -> delete -> insert #1152
    • Executing a query with a condition on an embedded object results in an error unless detailed profiling is enabled. #1117
    • LSMTreeIndexAbstract throws NPE during the select after the update of an indexed property #1127
    • Nested Projection * wildcard does not include metadata #1131
    • Composite Index corrupted after UPDATE #1113
  • Operations

    • OrientDB Importer doesn't save the correct inheritance tree #1132
    • OrientDB Importer requires too much RAM to run #1142
    • SQL IMPORT DATABASE fails for CSV #1061
    • SQL EXPORT DATABASE only works from the console, not via HTTP API #649
  • Java API

    • Index creation hinders async record creation #310
  • Gremlin

    • GremlinServer DatabaseOperationException: Found active instance of database './databases/graph' already in use #1107
    • Gremlin "group" and "groupCount" only work with strings. #1116

Dependencies Updated

  • build(deps): bump versions-maven-plugin from 2.15.0 to 2.16.0 by @dependabot in #1123
  • build(deps): bump undertow-core from 2.3.6.Final to 2.3.7.Final by @dependabot in #1122
  • build(deps): bump maven-failsafe-plugin from 3.1.0 to 3.1.2 by @dependabot in #1120
  • build(deps): bump maven-surefire-plugin from 3.1.0 to 3.1.2 by @dependabot in #1119
  • build(deps-dev): bump logback-classic from 1.4.7 to 1.4.8 by @dependabot in #1139
  • build(deps-dev): bump mockito-core from 5.3.1 to 5.4.0 by @dependabot in #1141
  • build(deps): bump maven-shade-plugin from 3.4.1 to 3.5.0 by @dependabot in #1140
  • build(deps): bump graalvm.version from 22.3.2 to 23.0.0 by @dependabot in #1137

Full Changelog: 23.5.1...23.6.1

23.5.1

09 Jun 01:09
Compare
Choose a tag to compare

What's New

  • Docker

    • Native Docker Image for Apple Silicon #894
  • Java API

    • Refactoring of schema API to create new types by using Builders intefaces #1102

What We Fixed

  • SQL

    • Error with adding edges on the same vertex from multiple threads on a replica server by using SQL Script #1114
    • COMMIT with RETRY does not work #1097
    • Cannot INSERT into Type.LINK a rid value returned from a nested SELECT #1096
    • Average difference between datetime values is always NULL #1103
    • INSERTing null into full-text indexed properties causes null-pointer exception error #1063
    • Inserting multiple records in a transaction with ThreadBucketSelectionStrategy causes LSMTreeIndexCursor to throw java.util.NoSuchElementException during SELECT #1079
    • BACKUP DATABASE default backup directory missing? #1069
    • Update SQLFunctionDuration.java (Fix typo) by @gramian in #1087
    • Refactor SQL Functions and Methods Trees by @gramian in #1084
  • Operations

    • Database backup command no longer works after 23.5.1 update #1115
  • Java API

    • Error on creation of new edge with remote database API (NullPointerException) #1068
  • Misc

Dependencies Updated

  • [Snyk] Upgrade io.netty:netty-transport from 4.1.86.Final to 4.1.92.Final by @arcade-player in #1082
  • [Snyk] Security upgrade io.undertow:undertow-core from 2.3.5.Final to 2.3.6.Final by @arcade-player in #1083
  • build(deps-dev): bump testcontainers.version from 1.18.0 to 1.18.1 by @dependabot in #1077
  • build(deps): bump docker-maven-plugin from 0.42.1 to 0.43.0 by @dependabot in #1092
  • build(deps): bump maven-failsafe-plugin from 3.0.0 to 3.1.0 by @dependabot in #1072
  • build(deps): bump maven-gpg-plugin from 3.0.1 to 3.1.0 by @dependabot in #1073
  • build(deps): bump maven-assembly-plugin from 3.5.0 to 3.6.0 by @dependabot in #1090
  • build(deps): bump maven-source-plugin from 3.2.1 to 3.3.0 by @dependabot in #1091
  • build(deps): bump maven-surefire-plugin from 3.0.0 to 3.1.0 by @dependabot in #1074
  • build(deps-dev): bump testcontainers.version from 1.18.1 to 1.18.3 by @dependabot in #1112
  • build(deps): bump metrics.version from 4.2.18 to 4.2.19 by @dependabot in #1111
  • build(deps): bump undertow-core from 2.3.5.Final to 2.3.6.Final by @dependabot in #1093

Full Changelog: 23.4.1...23.5.1

23.4.1

03 May 20:39
Compare
Choose a tag to compare

What's New

  • SQL

  • Engine

    • Configurable tx isolation level in #1008
  • Gremlin

    • Support embedded documents in Gremlin #1044
    • Support for buckets with Gremlin #1041
  • Studio

  • Misc

What We Fixed

  • SQL

    • Boolean operators with null argument #895
    • ORDER BY alters result type (in sub-query) #1046
    • Default constraint for STRING and DATETIME #905
    • Methods called on expand() return values are ignored #1004
  • Misc

    • GlobalConfiguration.DATE_TIME_FORMAT incompatible with GlobalConfiguration.DATE_TIME_IMPLEMENTATION #1050

Deprecated

  • HTTP /databases API. Use /server using list databases as payload instead.

Dependencies Updated

  • build(deps-dev): bump mockito-core from 5.2.0 to 5.3.1 by @dependabot in #1053
  • build(deps-dev): bump logback-classic from 1.4.6 to 1.4.7 by @dependabot in #1052
  • build(deps): bump graalvm.version from 22.3.1 to 22.3.2 by @dependabot in #1051
  • build(deps-dev): bump testcontainers.version from 1.17.6 to 1.18.0 by @dependabot in #1020
  • build(deps-dev): bump mongo-java-driver from 3.12.12 to 3.12.13 by @dependabot in #1022
  • build(deps): bump undertow-core from 2.3.4.Final to 2.3.5.Final by @dependabot in #977
  • build(deps): bump MeterianHQ/meterian-github-action from 1.0.12 to 1.0.13 by @dependabot in #1025
  • build(deps): bump kubernetes-maven-plugin from 1.11.0 to 1.12.0 by @dependabot in #1024
  • build(deps): bump jacoco-maven-plugin from 0.8.8 to 0.8.9 by @dependabot in #1021
  • build(deps): bump jacoco-maven-plugin from 0.8.9 to 0.8.10 by @dependabot in #1059
  • build(deps): bump junit.jupiter.version from 5.9.2 to 5.9.3 by @dependabot in #1058

Full Changelog: 23.3.1...23.4.1

23.3.1

05 Apr 11:36
Compare
Choose a tag to compare

What's New

  • Engine

    • Implicitly create buckets for CREATE TYPE by @gramian in #926
    • Random delay in case of high concurrency on the same pages #924
    • Performance improvements with graph traversal #916
    • Refactoring of AsyncResultsetCallback interface #984
  • GraphQL

    • Support of RIDs in GraphQL #945
  • Studio

    • Visual suggestion: Turning Actions list from bullet points to buttons #950
    • Default Graph (gremlin) not available through studio #662
  • Console

    • Add analog of INFO CLASS command #888
  • MongoDB Protocol

  • Security

  • Misc

    • Removed warning when starting console inside container #908
    • Display OS and JDK name and version at server startup #909

What We Fixed

  • SQL

    • Make LIKE case sensitive by @gramian in #989
    • Method fails in filtering schema:types #991
    • null (Schema) arguments to (map) function in projection #861
    • Property constraint notnull not working correctly #885
    • SQL Script doesn't work with replicated databases #910
    • BACKUP DATABASE not working #898
    • default constraint for STRING and DATETIME #905
  • Gremlin

    • Unexpected exception triggered by quering "size()" in gremlin statement #912
  • Cypher

    • Cypher query returns 0 rows #444
  • Security

    • Fix issue with group set only on second start by @gramian in #990
    • defaultDatabases user is not allowed to read records #974
    • User password not hidden in studio server setting listing #975
  • HTTP API

    • HTTP-API: exists endpoint should return metadata #968
  • Importer

  • Misc

Dependencies Updated

  • build(deps): bump maven-failsafe-plugin from 3.0.0-M8 to 3.0.0-M9 by @dependabot in #875
  • build(deps-dev): bump mockito.version from 5.1.1 to 5.2.0 by @dependabot in #933
  • build(deps): bump jline-terminal.version from 3.22.0 to 3.23.0 by @dependabot in #932
  • [Snyk] Upgrade io.undertow:undertow-core from 2.3.3.Final to 2.3.4.Final by @arcade-player in #923
  • build(deps-dev): bump logback-classic from 1.4.5 to 1.4.6 by @dependabot in #939
  • build(deps): bump maven-failsafe-plugin from 3.0.0-M9 to 3.0.0 by @dependabot in #938
  • build(deps): bump maven-surefire-plugin from 3.0.0-M8 to 3.0.0 by @dependabot in #937
  • [Snyk] Upgrade io.dropwizard.metrics:metrics-jmx from 4.2.15 to 4.2.16 by @snyk-bot in #922
  • build(deps): bump maven-compiler-plugin from 3.10.1 to 3.11.0 by @dependabot in #918
  • build(deps): bump metrics.version from 4.2.15 to 4.2.17 by @dependabot in #901
  • build(deps): bump versions-maven-plugin from 2.14.2 to 2.15.0 by @dependabot in #900
  • build(deps): bump maven-assembly-plugin from 3.4.2 to 3.5.0 by @dependabot in #902
  • build(deps): bump maven-javadoc-plugin from 3.4.1 to 3.5.0 by @dependabot in #874
  • build(deps): bump kubernetes-maven-plugin from 1.10.1 to 1.11.0 by @dependabot in #872
  • build(deps): bump undertow-core from 2.3.3.Final to 2.3.4.Final by @dependabot in #876
  • build(deps-dev): bump mockito-core from 4.11.0 to 5.1.0 by @dependabot in #815
  • build(deps): bump MeterianHQ/meterian-github-action from 1.0.10 to 1.0.12 by @dependabot in #957
  • build(deps): bump slf4j.version from 2.0.6 to 2.0.7 by @dependabot in #955
  • build(deps): bump metrics.version from 4.2.17 to 4.2.18 by @dependabot in #954
  • build(deps): bump postgresql from 42.5.3 to 42.6.0 by @dependabot in #953
  • [Snyk] Security upgrade io.undertow:undertow-core from 2.3.4.Final to 2.3.5.Final by @snyk-bot in #983
  • build(deps): bump maven-deploy-plugin from 3.1.0 to 3.1.1 by @dependabot in #980
  • build(deps): bump license-maven-plugin from 4.1 to 4.2 by @dependabot in #979
  • build(deps-dev): bump mockito-core from 5.1.0 to 5.2.0 by @dependabot in #956
  • build(deps): bump maven-resources-plugin from 3.3.0 to 3.3.1 by @dependabot in #976
  • [Snyk] Upgrade de.bwaldvogel:mongo-java-server from 1.41.0 to 1.42.0 by @arcade-player in #672
  • update maven wrapper, maven version by @robfrank in #949

New Contributors

Full Changelog: 23.2.1...23.3.1

23.2.1

01 Mar 02:57
e8f512f
Compare
Choose a tag to compare

What's New

  • Tools

    • Support for JSON Importer #841
  • Query Languages

    • Add SQL sqrt Function with Tests by @gramian in #890
    • Support for SQL functions in default values #863
    • SQL: allow to change the bucket selection strategy from ALTER TYPE command #827
    • Gremlin and Cypher: using the new faster Java native parser #837
  • Console

    • Support for automatic transaction batch #833
    • Support for asynchronous execution of commands #834
  • Security

What We Fixed

  • SQL

    • Listing indices via SELECT FROM schema:indexes errors #884
    • Linebreaks matter in projection, content (and maybe other places) #848
    • Create index if not exists is not ignored when index exists #840
    • LET variable changes at repeated access #828
  • Cypher and Gremlin

    • Unable to connect with Gremlin #869
    • Issue with collect in Cypher #860
  • Console

    • Fix console.bat not handling spaces in the path by @shasaur in #852
    • Escaping characters in the loaded script from console #843
    • Assignment of (boolean) custom attributes are cast to strings when done from console #859
  • Postgres Driver

    • Running queries occasionally causes ArcadeDB to get stuck at 100% CPU usage #846
    • (Windows + Golang PQ driver + Cypher) Database rows containing null values are sometimes not returned #824
  • Tools

    • Export fails #851
    • Importing basic Neo4j data fails #853
  • API

    • RemoteDatabase.exists() sends invalid POST request #826

Chores and Misc

  • Refactoring of BasicDatabase.execute() into the existent .command() supporting scripts #836
  • Network pom with an empty line at the end to get checks green by @gfinger in #823
  • Deprecate execute in RemoteDatabase. by @gfinger in #835
  • Unit tests for the RemoteDatabase by @gfinger in #850
  • Update README, change "minuted" to "minutes" by @SamMakesThings in #899
  • Fix license header by @gramian in #891
  • Failed to compile the local build of ArcadeDB #864

Dependencies Updated

  • chore(deps): bump maven-deploy-plugin from 3.0.0 to 3.1.0 by @dependabot in #858
  • chore(deps): bump netty-transport from 4.1.87.Final to 4.1.88.Final by @dependabot in #857
  • chore(deps-dev): bump mongo-java-driver from 3.12.11 to 3.12.12 by @dependabot in #856
  • [Snyk] Upgrade org.graalvm.sdk:graal-sdk from 22.3.0 to 22.3.1 by @arcade-player in #849
  • [Snyk] Upgrade org.jline:jline-terminal from 3.21.0 to 3.22.0 by @snyk-bot in #847
  • chore(deps): bump postgresql from 42.5.1 to 42.5.3 by @dependabot in #838
  • build(deps): bump jline-terminal.version from 3.21.0 to 3.22.0 by @dependabot in #791
  • build(deps): bump graalvm.version from 22.3.0 to 22.3.1 by @dependabot in #790

New Contributors

Full Changelog: 23.1.2...23.2.1

23.1.2

02 Feb 22:39
Compare
Choose a tag to compare

What's New

  • Geospatial

    • New geospatial functions in #797
  • SQL

    • SQL add & remove from lists and maps with + and - operators #822
    • Supported SQL function eval() #563
  • Console

    • Support for absolute local paths in Console by @gfinger in #787
  • DevOps

    • Added docker-compose config by @psytron in #781
    • Support ALIGN DATABASE from Studio Cluster panel #784 and #749
    • Export Database should allow filtering which types to export #788
    • Support for SSL on ArcadeDB HTTP server #775
    • Display Database and Server settings in Studio #776
  • API

    • RemoteDatabase and EmbeddedDatabase should share a basic interface #817

What We Fixed

  • SQL

    • Issues with the recent introduction of date classes with support up to nanosecond #608 and #794
    • IF function does not work #564
    • Collection attributes min and max can be negative #800
    • Insert embedded document #778
    • SELECT with comparison between indexed DATETIME_MICROS values does not work as expected #809
    • UPDATE statement corrupts Composite unique index on (STRING, INTEGER) properties #812
    • SQL UPDATE - REMOVE does not remove the property but set it to null #805
  • HTTP

    • Custom Http Handlers don't work anymore with latest v23.1.2-SNAPSHOT #798
    • RequestClusterConfiguration in RemoteDatabase sends erroneous POST-request #820
  • Replication

    • Replication Error #779
  • Studio

    • Studio doesn't show errors from duplicated key #786
    • Standard Cypher mode: types created automatically from Studio #697
    • Cypher columns are returned in the wrong order #818
    • Cypher: " cypher.null" has leading spaces in it #804
    • ORDER BY has no effect in results table panel #785
  • Security

    • [Snyk] Fix for 10 vulnerabilities by @snyk-bot in #811
    • User security groups are ignored #806
  • Misc

    • Regular expression property attribute regexp not working #799

Dependencies Updated

  • build(deps): bump maven-surefire-plugin from 3.0.0-M7 to 3.0.0-M8 by @dependabot in #772
  • build(deps): bump netty-transport from 4.1.86.Final to 4.1.87.Final by @dependabot in #771
  • build(deps): bump maven-failsafe-plugin from 3.0.0-M7 to 3.0.0-M8 by @dependabot in #770
  • build(deps): bump junit.jupiter.version from 5.9.1 to 5.9.2 by @dependabot in #769
  • build(deps): bump gson from 2.10 to 2.10.1 by @dependabot in #747
  • build(deps): bump undertow-core from 2.3.2.Final to 2.3.3.Final by @dependabot in #746
  • build(deps-dev): bump assertj-core from 3.23.1 to 3.24.2 by @dependabot in #783

New Contributors

Full Changelog: 23.1.1...23.1.2

23.1.1

16 Jan 18:57
Compare
Choose a tag to compare

What's New

  • Support for new Java Time Date API + precision up to nanosecond in #608, #765 and #773
  • Console
  • Studio Web Tool
    • new query history #708 and #709
    • new SQL command profiling in #720
    • added event to the text field in create-database input box to allow confirm via enter key. by @gramian in #727
  • SQL
    • UPSERT on buckets #719
  • Gremlin
    • new execution timeout in #713
  • Performance
    • speedup read access to records from the query in #758
    • speedup query execution by removing not necessary operations in #712

What We Fixed

  • HA/Replication

    • replication does not work when the server has a NAT address (AWS, clouds) in #764
    • replication should not take localhost #755
  • Console

    • ignores arcadedb.server.databaseDirectory setting #752
    • unify console commands with path argument by @gramian in #724
    • does not show property column in SELECT result if returned property values are null #731
    • ignores the value of server.databaseDirectory property #704
    • connect Issues: Exit and Error #599
    • drop database via console or endpoint #579
  • HTTP Server

    • remote server refuses longer HTTP POST requests #760
    • SHUTDOWN console command and HTTP Endpoint #722
  • Studio Web Tool

    • special characters in password breaks ArcadeDB web tool login #750
    • add server POST endpoint and remove document endpoints on API page by @gramian in #754
    • update studio API page by @gramian in #756 and #762
    • export to CSV/Excel truncates String values longer than 30 characters #721
    • start-up message displayed also when the server is in production mode #622
  • SQL

    • ALTER PROPERTY ... CUSTOM attribute does not work (anymore) #736
    • ORDER BY @Rid ASC adds spurious _$$$ORDER_BY_ALIAS$$$_0 column to SELECT results when @Rid is explicitly included in list of fields #725
    • latest snapshot showing date in a numeric format, not date format #743
    • exception thrown when using @Rid < ? in prepared statement and providing rid value as String #741
    • order of properties returned by SELECT does not match order specified #726
    • SQL Division by NULL #566
    • SQL Select NULL #565
  • Cypher

    • delete query causes "groovy.lang.MissingMethodException" error #734
    • query returns Internal Error without any details of the actual error #696
    • returned edges (serialized) are not filtered by query #673
  • Engine

    • index lookup returns partial data while compaction is running #757
  • Misc

    • chore: Rework starting scripts for Windows by @littleli in #738
    • chore: Save the banner on Windows by @littleli in #740
    • Error on creating a database from Studio when the cluster is running #753
    • Documentation update: ResultSet.countEntries() consumes ResultSet iterator #728

Dependencies Updated

  • Bump versions-maven-plugin from 2.14.1 to 2.14.2 by @dependabot in #707
  • Bump graalvm.version from 21.3.4 to 22.3.0 by @dependabot in #706
  • Bump metrics.version from 4.2.13 to 4.2.15 by @dependabot in #705
  • Bump eclipse-temurin from 11 to 19 in /package/src/main/docker by @dependabot in #549
  • build(deps-dev): bump mockito-core from 4.10.0 to 4.11.0 by @dependabot in #732
  • build(deps): bump actions/checkout from 3.2.0 to 3.3.0 by @dependabot in #748
  • [Snyk] Upgrade org.graalvm.sdk:graal-sdk from 21.2.0 to 21.3.4 by @snyk-bot in #703

New Contributors

Full Changelog: 22.12.1...23.1.1

22.12.1

23 Dec 22:02
Compare
Choose a tag to compare

What's New

  • Custom functions in #349
  • Order edges in descending order in #689
  • New HTTP /ready API to get is the server is running in #665
  • User management via API and console in #574
  • Importer: support additional settings in #666
  • SQL include and exclude methods in #664

What is fixed

  • Calculator SELECT via query endpoint problem in #580
  • SQL first and last functions return empty value for non multi-value types in #663
  • Console fixes and extensions by @gramian in #693
  • Double dash comment fix (mostly) by @gramian in #669
  • Fixed autofocus of login by @gramian in #676
  • Fixed escaped characters in strings? by @gramian in #680
  • Fixed Not connected edges from OrientDB import in #688
  • OrientDB Import: embedded maps are not imported in #692
  • Minor fixes in static studio pages by @gramian in #674
  • Cypher query returns Internal Error without any details of the actual error in #696
  • Postgresql: parsing errors are not propagated to the postgres layer in #677
  • Postgres driver: error on creating non-string properties in #691
  • Custom Property Attributes should be returned as a map instead of list of entries in #651
  • Support validation with Gremlin "addVertex" through Postgres driver in #690

Updated Dependencies

Full Changelog: 22.11.1...22.12.1

22.11.1

07 Dec 23:48
Compare
Choose a tag to compare

What's New

  • SQL: IS Comparison -> new <=> operator (null-safe comparison operator) by @gramian in #652
  • Console: allows execution of commands in languages other than SQL in #656
  • SQL: toDate and toDateTime should get custom format in #606

Problems fixed

  • Custom Property Attributes Structure in #651
  • HTTP /exists should return a boolean, not a string in #647
  • Error: "java.nio.file.NoSuchFileException: .\log\arcadedb.log.0.lck" on simple Scala code in #620
  • Multiple execution of "CREATE INDEX IF NOT EXISTS ON eltdev (SN) UNIQUE" results in IllegalArgumentException in #634
  • dumpConfigAtStartup to write config to log file in #624
  • Console: case sensitive commands in #615
  • Wildcard escape % produces error in #603

Updated dependencies

New Contributors

Full Changelog: 22.10.1...22.11.1