Show all posts
Subscribe

Show all posts

August 29, 2022

Release v1.0.0-beta.7

  • Add support for Objects and Arrays as Record IDs
  • Add support for querying records using Record ID ranges
  • Add SQL session functions for retrieving session variables
  • Make --ns and --db arguments optional in command-line REPL
  • Return an error when the specified datastore is not able to be initiated
  • Enable root authentication for client libraries using WebSocket protocol
  • Ensure math::sum() returns a number instead of a NONE value, when called on a non-array value
  • Add ACID compliant, persistant, on-disk storage implementation, with multiple concurrent writers using RocksDB

Complex Record IDs

SurrealDB now supports the ability to define record IDs using arrays and objects. These values sort correctly, and can be used to store values or recordings in a timeseries context.

// Create a record with a complex ID using an array
CREATE temperature:['London', '2022-08-29T08:03:39'] SET
    location = 'London',
    date = '2022-08-29T08:03:39',
    temperature = 23.7
;
// Create a record with a complex ID using an object
CREATE temperature:{ location: 'London', date: '2022-08-29T08:03:39' } SET
    location = 'London',
    date = '2022-08-29T08:03:39',
    temperature = 23.7
;
// Select a specific record using a complex ID
SELECT * FROM temperature:['London', '2022-08-29T08:03:39'];

Record ID ranges

SurrealDB now supports the ability to query a range of records, using the record ID. The record ID ranges, retrieve records using the natural sorting order of the record IDs. With the addition of complex record IDs above, this can be used to query a range of records in a timeseries context.

// Select all person records with IDs between the given range
SELECT * FROM person:1..1000;
// Select all temperature records with IDs between the given range
SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..['London', '2022-08-29T08:09:31'];

https://surrealdb.com/releases

     

Other blog posts

No. 1 GitHub trending repository!

August 24, 2022

No. 1 GitHub trending repository!

Absolutely shocked and honoured to reach the No. 1 trending public repository on GitHub worldwide. Thank you to everyone who has shown interest in SurrealDB and helped us reach 2500 GitHub stars!

3500 thank yous

August 30, 2022

3500 thank yous

⭐ Thank you, thank you, thank you!!! Thank you to our SurrealDB stargazers for helping us pass 3500 GitHub stars! ⭐

To stay up-to-date with new blog articles, future product releases, and documentation updates, subscribe to our email newsletter below, follow us on Twitter, or follow us on Dev.

Join the SurrealDB newsletter