{"id":104730,"date":"2022-07-29T15:37:11","date_gmt":"2022-07-29T13:37:12","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-relyaczionno-grafovoj-subd-edgedb-2-0"},"modified":"2022-07-29T15:37:11","modified_gmt":"2022-07-29T13:37:12","slug":"vypusk-relyaczionno-grafovoj-subd-edgedb-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/vypusk-relyaczionno-grafovoj-subd-edgedb-2-0","title":{"rendered":"Release of EdgeDB 2.0 Relational-Graph Database","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

The release of EdgeDB 2.0 has been presented, implementing a relational-graph data model and the EdgeQL query language, optimized for working with complex hierarchical data. The code is written in Python and Rust (for the parser and performance-critical parts) and is distributed under the Apache 2.0 license. The project is developed as an extension of PostgreSQL. Client libraries are available for Python, Go, Rust, and TypeScript\/Javascript. A command-line toolbox is provided for managing the database and for interactively executing queries (REPL). <\/p>\n

Instead of a table-based data model, EdgeDB employs a declarative system based on object types. Instead of foreign keys to define relationships between types, it uses links (one object can be used as a property of another object). <\/p>\n

type Person { required property name -> str; } type Movie { required property title -> str; multi link actors -> Person; } <\/p>\n

Indexes can be used to speed up query processing. Features such as strict property typing, property value constraints, computed properties, and stored procedures are also supported. Among the features of EdgeDB's object storage schema, which somewhat resembles ORM, are the ability to mix schemas, link properties from different objects, and integrated JSON support. <\/p>\n

Built-in tools for storage schema migration are provided \u2014 after changing the schema defined in a separate esdl file, simply execute the command «edgedb migration create» and the DBMS will analyze the schema differences and interactively generate a script for transitioning to the new schema. The history of schema changes is automatically tracked. <\/p>\n

For forming queries, both GraphQL and EdgeDB's own query language, which is an adaptation of SQL for hierarchical data, are supported. Instead of lists, query results are presented in a structured form, and instead of subqueries and JOIN operations, it allows specifying one EdgeQL query as an expression within another query. Transactions and loops are supported. <\/p>\n

select Movie { title, actors: { name } } filter .title = 'The Matrix' insert Movie { title := 'The Matrix Resurrections', actors := ( select Person filter .name in { 'Keanu Reeves', 'Carrie-Anne Moss', 'Laurence Fishburne' } ) } for number in {0, 1, 2, 3} union ( select { number, number + 0.5 } ); <\/p>\n

In the new version: <\/p>\n