April 2023 Summaries

The blog post provides a comprehensive guide on setting up a distributed SurrealDB cluster using a TiKV cluster architecture to enhance scalability and reliability for data operations. By leveraging different Key-Value storage engines like RocksDB for single deployment and TiKV or FoundationDB for distributed storage, the setup aims to improve data read and write operations while maintaining operations during node failures. The tutorial outlines the use of LXC, a lightweight Linux container system, to simulate fully-fledged computing nodes, emphasizing that this setup, which simplifies deployment using SSH and a known password, is not recommended for production due to security concerns. The process involves configuring and launching multiple TiKV and PD instances, deploying SurrealDB nodes, and balancing the connections across the PD node pool to ensure minimal disruption and data integrity in case of node failures. The guide concludes with a demonstration of executing basic SQL operations using SurrealDB and encourages further exploration of its scalability and application.

A recent SurrealDB Stream featured a discussion on SurrealQL, a SQL-like language, led by co-founder Tobie Morgan Hitchcock, data evangelist Alexander Fridriksson, and software engineer Micha de Vries. The session explored why SurrealQL was developed as a SQL-like language rather than adopting a custom language such as MongoQL or Cypher, delving into the history of SQL and the reasons for diverging from the ANSI SQL standard. The stream included demonstrations of both fundamental and advanced SurrealQL concepts, along with a Q&A segment addressing community inquiries about SurrealDB and SurrealQL. The event is part of the broader effort to engage users with tutorials and updates on database technology, emphasizing enterprise security compliance with certifications like SOC 2 Type 2, GDPR, Cyber Essentials Plus, and ISO 27001.

The text explores the evolution and fundamental concepts of databases, highlighting the transition from physical to digital information storage and sharing. It introduces the CRUD model—Create, Read, Update, and Delete—as essential for interacting with data and traces the development of databases from the relational model pioneered by Edgar F. Codd to the advent of SQL for practical implementation. The discussion expands to include document databases, which emerged with the internet's rise, and graph databases, which better suit complex networks typical of social media and e-commerce. The piece culminates with the introduction of SurrealDB, a multi-model database that integrates various database models to offer flexibility and simplicity, adapting to the evolving technological landscape.

SurrealDB's beta 9 release introduces significant new features, performance improvements, and bug fixes, largely influenced by user contributions. One notable user, Brian, suggested simplifying SELECT statements by returning single field values as a string array, leading to the implementation of the SELECT VALUE syntax. Another user, Sebastian, proposed creating custom functions for reusable code across the database, resulting in the ability to define global functions with typed arguments and custom logic. Tom advocated for handling complex expressions directly within SurrealDB, leading to the addition of code blocks that support multiple statements, such as LET and RETURN, to facilitate advanced data operations. These community-driven enhancements demonstrate the collaborative development spirit of SurrealDB and reflect its flexibility to accommodate user needs, with ongoing discussions and future updates planned.