Control, Flexibilty and Smarter Queries: What's New in Memgraph 3.5

Memgraph 3.5 introduces several enhancements designed to provide users with increased control, flexibility, and efficiency in managing graph databases. The update focuses on user management through the new USER PROFILE feature, enabling administrators to impose session and memory limits per user, and introduces multiple roles per user for better security and SSO integration. The STRICT_SYNC replication mode ensures data safety during failovers in high-availability clusters, while Cypher query enhancements include KShortest path traversal, existential subqueries, and timezone-aware datetimes. Operational improvements such as new SHOW commands, text indexing on property subsets, successful snapshot creation, and replication lag visibility aim to streamline daily operations. Additionally, the MAGE 3.5 library and Lab 3.5 tools offer new functions for query optimization and schema design, enhancing user experience for both production environments and experimental setups.