Database

Learn three components, and you know EdgeDB: how to work with schema, how to write queries with EdgeQL, and what's available to you in our standard library. Start in those sections if you're new to EdgeDB. Move over to our reference when you're ready to dive deep into the internals, syntax, and other advanced topics.

module default {
  type Book {
    required title: str;
    release_year: int16;
    author: Person;
  }
  type Person {
    required name: str;
  }
}

db> 
... 
... 
... 
... 
... 
... 

select Book {
  title,
  release_year,
  author: {
    name
  }
} order by .title;

{
  default::Book {
    title: '1984',
    release_year: 1949,
    author: default::Person {
      name: 'George Orwell'
    }
  },
  default::Book {
    title: 'Americanah',
    release_year: 2013,
    author: default::Person {
      name: 'Chimamanda Ngozi Adichie'
    }
  },

Standard library

EdgeDB comes with a rigorously defined type system consisting of scalar types, collection types (like arrays and tuples), and object types. It also includes a library of built-in functions and operators for working with each datatype, alongside some additional utilities and extensions.

db> 

select count(Book);

{16}

db> 
... 
... 
... 

select Book {
  title,
  title_length := len(.title)
} order by .title_length;

{
  default::Book {
    title: 'Sula',
    title_length: 4
  },
  default::Book {
    title: '1984',
    title_length: 4
  },
  default::Book {
    title: 'Beloved',
    title_length: 7
  },
  default::Book {
    title: 'The Fellowship of the Ring',
    title_length: 26
  },
  default::Book {
    title: 'One Hundred Years of Solitude',
    title_length: 29
  },
}

db> 

select math::stddev(len(Book.title));

{7.298401651503339}

EdgeDB comes with a rigorously defined type system consisting of scalar types, collection types (like arrays and tuples), and object types. It also includes a library of built-in functions and operators for working with each datatype, alongside some additional utilities and extensions.