Logship Documentation
Open Logship
  • Prerequisites
  • Single Node Deployment
  • Push Your First Event
  • Query
  • Advanced
  • Next Steps
  • Logship Database
  • Install
  • Database Configuration
  • Blob storage durability
  • Identity providers and SSO
  • Indexed file V5 encodings
  • Table declarations and blob references
  • Logship Agent
  • Getting Started
  • Install
  • Config
  • Platform Guides
    • Agent installation on openwrt
  • Overview
  • Install logsh
  • Terminal UI (logsht)
  • Overview
  • Install
  • Frontend Configuration
  • System Settings
  • Account Settings
  • Grafana Datasource Plugin
  • Dashboards
  • Public query embeds
  • Operations
  • Administration Account
  • Incident Management
  • Group Management
  • Security
    • Firewall & Network Hardening
    • Token revocation
  • Basics
  • Language
    • Functions
      • Aggregate Functions
        • Agg Avg
        • Agg Expavg
        • Agg Max
        • Agg Min
        • Argmax
        • Argmin
        • Avg
        • Count
        • Dcount
        • First
        • Join
        • Make List
        • Make Set
        • Percentile
        • percentiles
        • Stdev
        • Sum
        • Variance
      • Scalar Functions
        • Abs
        • Acos
        • Acos2
        • Ago
        • Asin
        • Asin2
        • Atan
        • Atan2
        • Bin
        • Case
        • Ceil
        • Coalesce
        • Concat
        • Cos
        • Countof
        • Datetime Add
        • Datetime Diff
        • Datetime Part
        • Datetime Utc To Local
        • Degrees
        • Exp
        • Extract
        • Floor
        • Format Datetime
        • Hash
        • Iff
        • Indexof
        • Isempty
        • Isnotempty
        • Isnull
        • Json
        • Log
        • Log10
        • Log2
        • Math
        • Max
        • Min
        • Newid
        • Now
        • Parse Json
        • Pi
        • Pow
        • Prev
        • Radians
        • Rand
        • Round
        • Sign
        • Sin
        • Split
        • Sqrt
        • Str
        • String Transform
        • Strlen
        • Substring
        • Tan
        • Todouble
        • Toguid
        • Toint
        • Toreal
        • Tostring
        • Trim
        • Trim End
        • Trim Start
        • Type Conversion
    • Management Commands
      • .create table
      • .create-merge table
      • .drop column
      • .drop table
      • .show table
      • .show tables
      • .truncate table
      • Table retention policy
    • Tabular Operators
      • Count
      • Datatable
      • Distinct
      • Extend
      • Join
      • Limit
      • Make-Streams
      • multi-project
      • Parse
      • Project
      • Range
      • Render
      • Sort
      • Summarize
      • Table
      • Take
      • Time-Bound
      • Union
      • Where Filter
    • Chart settings reference
    • Expressions
    • Types
  • Multiple query results
  • Query

Database v0.0.1

The database combines Logship's storage engine with backend services for ingestion, querying, and administration. It can run as a single node or distribute service roles across machines. Start with Logship Database for the architecture, follow Install and Database Configuration to deploy it, then use the table and blob storage guides when defining data and managing binary content.

Pages

Logship Database

Understand the storage engine, backend services, and options for separating service roles.

Install

Install and run the database backend in your environment.

Database Configuration

Configure backend services, storage paths, endpoints, and deployment roles.

Blob storage durability

Configure the blob storage role, durability replicas, and recovery behavior.

Identity providers and SSO

Configure Google, Microsoft, Keycloak, and custom OpenID Connect sign-in.

Indexed file V5 encodings

Table declarations and blob references

Declare table column types and attach binary content through blob references.