July 2022 Summaries

On July 28, 2022, EdgeDB announced the release of version 2.0. This update brings a range of new features including a built-in admin UI, a top-level GROUP statement in EdgeQL, object-level security, range types, and an official Rust client library. The EdgeDB team also highlighted its commitment to open source development and the use of Postgres under the hood. They also announced plans for future releases including features like EXPLAIN command, user-defined error types, support for splats in EdgeQL shapes, role-based access control, full-text search support, and a preview of EdgeDB Cloud, a fully-managed hosted EdgeDB service.

EdgeDB 2.0 introduces significant advancements to the database, enhancing its capabilities and user experience with features like a built-in admin UI, a new top-level GROUP statement in EdgeQL, object-level security, and range types, along with an official Rust client library. This update continues to build on EdgeDB's goal of bridging the object-relational gap by allowing for intuitive data modeling and querying without the need for ORMs or middleware, thereby simplifying the software stack and improving performance. The new version supports a modern query language, a robust migration system, and global variables that facilitate context-aware access control at the schema level. Additionally, the release includes improvements to the binary protocol, support for efficient local development, and plans for future enhancements like EXPLAIN commands, role-based access control, and EdgeDB Cloud, a managed service for easy deployment. These features underline EdgeDB's commitment to rapid innovation and community engagement, aiming to transform how developers interact with relational databases.

The text discusses the design and implementation of a TypeScript query builder that can express queries of arbitrary complexity while automatically inferring return types. It is based on EdgeQL, an object-oriented query language designed as a spiritual successor to SQL. The query builder provides the best of both worlds: the type safety of an ORM coupled with the expressive power of a full-fledged query language. Key features include inserting objects, nested inserts, selecting objects, adding computed properties, filters, ordering and pagination, updating objects, self-referential updates, and composing queries. The text also compares the query builder to ORMs and highlights its superior expressive power and functionality.

The text details the development and capabilities of a query builder for TypeScript, designed to facilitate complex query constructions while automatically inferring return types. Utilizing modern JavaScript features alongside TypeScript's advanced capabilities, the builder offers the type safety of an ORM paired with the expressiveness of a query language, specifically targeting EdgeQL, the object-oriented query language of EdgeDB. This tool is positioned as a successor to SQL, addressing significant usability issues and enabling users to perform operations like nested inserts, object selection, filtering, ordering, and pagination. It allows for compositional query writing, parameterization, and self-referential updates, enhancing its utility over traditional ORMs. The query builder supports advanced features like computed properties and schema modeling, offering a robust alternative for database operations and is described as production-ready and compatible with EdgeDB 2.0. Moreover, the tool is highlighted as a powerful resource for building complex queries, integrating seamlessly with EdgeDB's features, and offering a more intuitive API for developers.