ArcaneDB

Language Reference and User Guide

---

Contents:

• Introduction
• Core Concepts
  • Buckets
  • Data Types
  • Transactions
  • The Internal Hash Field
• Bucket Management
  • Creating Buckets
  • Dropping a Field
  • Truncating a Bucket
  • Inspecting a Bucket
  • Listing All Buckets
• Inserting Data
  • Single-Row Insert
  • Positional Insert
  • Batch Insert
• Querying Data
  • Basic Retrieval
  • Head and Tail Retrieval
  • Filtering with WHERE
  • Ordering Results
  • Retrieving the Internal Hash
• Updating Data
• Deleting Data
• String Functions in Queries
• Aggregate Functions
• Transactions
  • Implicit Transactions
  • Explicit Transaction Blocks
• Exporting Data
• The ANALYZE Statement
  • Stream Analysis
  • Time Series Analysis
  • Descriptive Statistics
  • Correlation Analysis
  • Percentile Analysis
  • Window Functions
• The PRINT Statement
• Comments
• Complete Example Scripts
  • Sales Analysis
  • Transactional Writes with Rollback
  • Product Catalogue Management
• Statement Quick Reference