ReifyDB$ReifyDB
[Home][Contact][Support]
[> Book a Call]
  • Introduction
  • Installation
  • Quick Start
  • Connect
    • Build Your First App
    • Live Dashboard
    • Real-Time Chat
    • Task Manager
    • SQL Databases
    • MongoDB
    • Redis
    • Firebase / Firestore
  • Overview
  • Data Model
  • Data Types
  • Namespaces & Schemas
  • Transactions & ACID
  • Materialized Views
  • Real-Time Subscriptions
  • Storage Engines
  • Consistency Model
  • Error Handling
  • Embedded vs. Server Mode
  • Basics
    • Overview
    • Filter
    • Sort
    • Map
    • Extend
    • Aggregate
    • Distinct
    • Take
    • Join
    • Match
    • Patch
    • Overview
    • Operators
    • Conditionals
    • Literals
    • Field Access
    • Pagination
    • Hierarchical Data
    • Time-Series Queries
    • Text Search
    • Dynamic Queries
  • Overview
    • Namespaces
    • Tables
    • Enums
    • Dictionaries
    • Drop & Cleanup
    • Constraints
    • Indexes
    • Tables
    • Ringbuffers
    • Series
    • Insert
    • Update
    • Delete
    • Upsert
    • Batch Operations
    • Overview
    • Deferred Views
    • Transactional Views
    • Overview
    • Parameters & Control Flow
    • Overview
    • Handlers
    • Dispatch
  • Testing
  • Migrations
  • Subscriptions
  • Access Control
  • Overview
    • Users & Auth
    • E-Commerce
    • IoT & Sensor Data
    • Content Management
    • Multi-Tenancy
    • Relationships
    • Live Queries
    • Reactive Views
    • Event Sourcing
    • Notifications
    • Unit Testing
    • Integration Testing
    • Test Fixtures & Seeding
    • Soft Deletes
    • Audit Trail
    • State Machines
    • CQRS
    • Computed Fields
    • Data Versioning
  • Overview
    • Quick Start
    • Connection
    • Queries
    • Mutations
    • Subscriptions
    • Transactions
    • Type Safety
    • Error Handling
    • API Reference
    • Quick Start
    • Embedded Mode
    • Client Mode
    • API Reference
    • Quick Start
    • Connection
    • Queries
    • API Reference
    • Quick Start
    • Connection
    • Queries
    • API Reference
  • Overview
  • Volcano Execution Model
  • Types & Expressions
  • Storage Engine
  • Incremental Maintenance
  • Transaction Engine
  • Wire Protocol
  • Overview
  • Authentication
  • Authorization & Roles
  • Row-Level Security
  • Encryption
  • Audit Logging
  • TLS & Network Security
  • Configuration
    • Standalone
    • Embedded
    • Docker
    • Kubernetes
    • Systemd
    • Overview
    • Snapshots
    • Point-in-Time Recovery
    • Overview
    • Metrics
    • Logging
    • Health Checks
  • Upgrades
  • Scaling
  • Overview
  • Query Optimization
  • Indexing Strategies
  • EXPLAIN & Query Plans
  • View Tuning
  • Memory Management
  • Benchmarks
    • Overview
    • Command Reference
    • Scripting with CLI
    • Overview
    • Query Editor
    • Schema Browser
  • Online Playground
  • Overview
    • Overview
    • Authentication
    • Query Endpoint
    • Mutation Endpoint
    • Subscription Endpoint
    • Error Codes
  • Webhooks
  • Change Data Capture
    • React
    • Next.js
    • Svelte
  • Overview
    • b58
    • b64
    • b64url
    • hex
    • utf8
    • advance
    • now
    • set
    • add
    • age
    • day
    • day_of_week
    • day_of_year
    • days_in_month
    • diff
    • end_of_month
    • format
    • is_leap_year
    • month
    • new
    • now
    • quarter
    • start_of_month
    • start_of_year
    • subtract
    • trunc
    • week
    • year
    • add
    • age
    • date
    • day
    • day_of_week
    • day_of_year
    • diff
    • epoch
    • epoch_millis
    • format
    • from_epoch
    • from_epoch_millis
    • hour
    • minute
    • month
    • nanosecond
    • new
    • now
    • quarter
    • second
    • subtract
    • time
    • trunc
    • week
    • year
    • add
    • days
    • format
    • get_days
    • get_months
    • get_nanos
    • hours
    • millis
    • minutes
    • months
    • negate
    • scale
    • seconds
    • subtract
    • trunc
    • weeks
    • years
    • id
    • anonymous
    • none
    • root
    • some
    • type
    • array
    • object
    • serialize
    • pretty
    • abs
    • acos
    • asin
    • atan
    • atan2
    • avg
    • ceil
    • clamp
    • cos
    • e
    • exp
    • floor
    • gcd
    • lcm
    • log
    • log10
    • log2
    • max
    • min
    • mod
    • pi
    • power
    • round
    • sign
    • sin
    • sqrt
    • sum
    • tan
    • truncate
    • type
    • ascii
    • char
    • concat
    • contains
    • count
    • ends_with
    • format_bytes
    • format_bytes_si
    • index_of
    • length
    • lower
    • pad_left
    • pad_right
    • repeat
    • replace
    • reverse
    • starts_with
    • substring
    • trim
    • trim_end
    • trim_start
    • upper
    • add
    • age
    • diff
    • format
    • hour
    • minute
    • nanosecond
    • new
    • now
    • second
    • subtract
    • trunc
  • Overview
  • Common Errors
  • Connection Issues
  • Slow Queries
  • Transaction Conflicts
  • View Issues
  • FAQ
  • Changelog
  • Roadmap
  • Glossary
  • Contributing
  • Community
  • Release Notes
[DRAFT]This page is not published. Only visible in development mode.

Functions

RQL comes with built-in function modules for the operations you use most. Call them with the :: syntax.

Available Modules

blob

Binary encoding and decoding: b58, b64, b64url, hex, utf8.

clock

System clock access: now, set, advance.

date

Work with dates: year, month, day, quarter, week, add, subtract, diff, format.

datetime

Full datetime manipulation: extraction, construction, arithmetic, epoch conversion, formatting.

duration

Create and manipulate durations: years, months, days, hours, minutes, seconds.

identity

Record identifier functions: id.

is

Type and value checking: some, none, type, root, anonymous.

json

Build and serialize JSON: array, object, serialize, pretty.

math

Numbers and aggregations: sum, avg, min, max, count, abs, round, trig, logarithms.

meta

Value metadata inspection: type.

text

String operations: lower, upper, trim, contains, replace, pad, format.

time

Time-of-day functions: hour, minute, second, add, subtract, diff, format.

Syntax
Call any module function with module::function(args). For example: text::lower(name).
# product
  • >Documentation
  • >Blog
  • >FAQ
# resources
  • >Contact
  • >Support
  • >Book a Call
# community
  • >GitHub
  • >X (Twitter)
  • >Discord
© 2026 ReifyDB. All Rights Reserved.
License: Apache-2.0