Skip to main content

High-Performance Lightweight Python ORM designed for RayforceDB

Documentation Coverage Release Python Version

Python ORM for RayforceDB, a high-performance columnar database designed for analytics and data operations. Core is written in pure C with minimal overhead - combines columnar storage with SIMD vectorization for lightning-fast analytics on time-series and big data workloads.

Full Documentation: https://py.rayforcedb.com/

Features

  • Pythonic API - Chainable, convenient, intuitive and fluent query syntax
  • High Performance - One of the fastest solutions available, minimal overhead between Python and RayforceDB runtime via C API
  • Lightweight - Core is less than 1 MB footprint
  • 0 dependencies - Library operates without dependencies - pure Python and C
  • Rapid Development - Continuously expanding functionality

RayforcePy Benchmarks

Benchmarks run on: macOS M4 32GB, 100 groups, 20 runs (median), 5 warmup runs. H2OAI

Quick Start

>>> from datetime import time
>>> from rayforce import Table, Column, Vector, Symbol, Time, F64

>>> quotes = Table({
        "symbol": Vector(items=["AAPL", "AAPL", "AAPL", "GOOG", "GOOG", "GOOG"], ray_type=Symbol),
        "time": Vector(
            items=[
                time.fromisoformat("09:00:00.095"),
                time.fromisoformat("09:00:00.105"),
                time.fromisoformat("09:00:00.295"),
                time.fromisoformat("09:00:00.145"),
                time.fromisoformat("09:00:00.155"),
                time.fromisoformat("09:00:00.345"),
            ],
            ray_type=Time,
        ),
        "bid": Vector(items=[100.0, 101.0, 102.0, 200.0, 201.0, 202.0], ray_type=F64),
        "ask": Vector(items=[110.0, 111.0, 112.0, 210.0, 211.0, 212.0], ray_type=F64),
    })

>>> result = (
        quotes
        .select(
            max_bid=Column("bid").max(),
            min_bid=Column("bid").min(),
            avg_ask=Column("ask").mean(),
            records_count=Column("time").count(),
            first_time=Column("time").first(),
        )
        .where((Column("bid") >= 110) & (Column("ask") > 100))
        .by("symbol")
        .execute()
    )
>>> print(result)
┌────────┬─────────┬─────────┬─────────┬───────────────┬──────────────┐
 symbol  max_bid  min_bid  avg_ask  records_count  first_time   
├────────┼─────────┼─────────┼─────────┼───────────────┼──────────────┤
 GOOG    202.00   200.00   211.00   3              09:00:00.145 
├────────┴─────────┴─────────┴─────────┴───────────────┴──────────────┤
 1 rows (1 shown) 6 columns (6 shown)                                
└─────────────────────────────────────────────────────────────────────┘

Installation

Package is available on PyPI:

pip install rayforce-py

This installation also provides a command-line interface to access the native Rayforce runtime:

~ $ rayforce
Launching Rayforce...
  RayforceDB: 0.1 Dec  6 2025
  Documentation: https://rayforcedb.com/
  Github: https://github.com/RayforceDB/rayforce
 (+ 1 2)
3

Built with ❤️ for high-performance data processing | MIT Licensed | RayforceDB Team

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

rayforce_py-2.2.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (4.5 MB view details)

Uploaded CPython 3.14manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

rayforce_py-2.2.0-cp314-cp314-macosx_11_0_arm64.whl (1.9 MB view details)

Uploaded CPython 3.14macOS 11.0+ ARM64

rayforce_py-2.2.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (4.5 MB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

rayforce_py-2.2.0-cp313-cp313-macosx_11_0_arm64.whl (1.9 MB view details)

Uploaded CPython 3.13macOS 11.0+ ARM64

rayforce_py-2.2.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (4.5 MB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

rayforce_py-2.2.0-cp312-cp312-macosx_11_0_arm64.whl (1.9 MB view details)

Uploaded CPython 3.12macOS 11.0+ ARM64

rayforce_py-2.2.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (4.5 MB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

rayforce_py-2.2.0-cp311-cp311-macosx_11_0_arm64.whl (1.9 MB view details)

Uploaded CPython 3.11macOS 11.0+ ARM64

File details

Details for the file rayforce_py-2.2.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 c4a99e707d4d6b8225b5785721d7ff2f6048b69e74f7d1daf060ad7a620758a6
MD5 49ce21797842ccbc5baff6dcd0f2b4fb
BLAKE2b-256 9c410ab9a9ea9aa48bfbc71eeda2d46fb9596b7838e4f8bb1a09965c4c0dcd02

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp314-cp314-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp314-cp314-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 3eaa2ac8086b0c239b028a4b288a86668440924610a70ce787ee17dbd7bfb4be
MD5 1d32ae7b5c49d86af06c0b4ffcb726a8
BLAKE2b-256 a70c1642f85de25a93a1640e05aecac134e852a317e15e467df7803a79325402

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp314-cp314-macosx_11_0_arm64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 cea7d23a4167a3ebf093542a4c471ba26f631fcbd0ddfd69c48d484cdf35bf12
MD5 5bb723ae1330710b28db4f5cec272084
BLAKE2b-256 ee1f723a24f261d28b7640b4ab6e1d4730ce3019a7a774edb48c9f9b8469153e

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp313-cp313-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp313-cp313-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 fd98d4bb73b325c227c381c9986ab79ddf2e1b00d3876f7930665c5a0722af9a
MD5 961235004acc1bed5e569c5a305cdeac
BLAKE2b-256 d571b4e7c04eabef60ed4c091887db78c082af92e7f9d81dd17167441bc37c9d

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp313-cp313-macosx_11_0_arm64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 189883f54dca0a783af3a38f266f00d902f4629f46ae9b8e81363354587dba64
MD5 17ca8843c96d9a4a8966f223ff7c9df8
BLAKE2b-256 44c8cd6ce4fe1a6b60f8c7f8fb8e07edec75ce0b3ce16ba04fa39409d8716eba

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp312-cp312-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp312-cp312-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 d1790723af286cf8a0bfcc34319b66715d7c9ddf5c135e86190ad3b570f88845
MD5 d46bec5300a489afacd46c2b253c6d45
BLAKE2b-256 58f8dda50a95b043f19d6adefb3acbcbecd17c2994ede5fef26b89b3c188a2e7

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp312-cp312-macosx_11_0_arm64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
Algorithm Hash digest
SHA256 3ed9bc0df57a69df02655e2d821e1fd823a0444b714823a3f7aa60f04c976f0e
MD5 5f3bca1742db32783c800191716a1007
BLAKE2b-256 0c0981b5b1443bca1a149353a80c33ecc6a658ea1b1d91327dac184846b8e252

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file rayforce_py-2.2.0-cp311-cp311-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for rayforce_py-2.2.0-cp311-cp311-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 57ab0acecebe0f3d9a4f53cb0e8fad612e66a999067565a2a14a85fddecc21f3
MD5 2a095cda065c9eba29d48c198582bbd3
BLAKE2b-256 f408105f7f6c3350ccd56841f3ccab36c3b950a83dc3885e211a36b82bf3f9bd

See more details on using hashes here.

Provenance

The following attestation bundles were made for rayforce_py-2.2.0-cp311-cp311-macosx_11_0_arm64.whl:

Publisher: build-wheels.yml on RayforceDB/rayforce-py

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page