RayQL

A schema and query language for SQLite

Meet RayQL

The schema and query language for your next side-project

Features:

  • Written in Rust
  • Clean and familiar syntax
  • Online editor
  • VS Code extension for syntax highlighting

Try it out

Example

# Enum for user types

enum user_type {
    admin
    developer
    normal
}

# Model declaration for 'user'

model user {
    id: int primary_key auto_increment,
    username: str unique,
    email: str unique, # this is an inline comment
    phone_number: str?,
    user_type: user_type default(user_type.normal)
}

# Model declaration for 'post'

model post {
    id: int primary_key auto_increment,
    title: str default('New Post'),
    content: str,
    author_id: int foreign_key(user.id),
    created_at: timestamp default(now()),
}