Explore the models / 8DB

Tables & records

Familiar rows. More context within reach.

Work with structured records and selected fields alongside documents, relationships and time-based observations.

Filter · sort · project
Model / TablesConceptual diagram
tables representation: conceptual diagramIDOBSERVATIONSTATE01020304ROWS → FILTER → SELECTED FIELDS
Rows share a structure. A query selects the fields and records relevant to the question.

Start with the operations
your question needs.

  • Typed rows and record identity
  • Filtering, sorting and projections
  • Point and range reads on supported paths

Documented product scope, reviewed 17 September 2026. The underlying build and deployment must be qualified for your application.

A relational representation is not a claim of full SQL or PostgreSQL compatibility. Check joins, transactions, aggregations, null handling and connectors against the exact supported query surface.
Connected native models

Keep the next question within reach.

The opportunity is to carry row identity into the rest of a mixed-data question. A table can remain a useful projection while the application follows richer context beyond its columns.

These connections show the models involved in the application design. Compare the supported combination and full workflow with a realistic alternative.

Input → usable value / interactive design example

Build an evidence-backed operations report

tables representation: conceptual diagramIDOBSERVATIONSTATE01020304ROWS → FILTER → SELECTED FIELDS
Step 1 / Tables

Ingest operational records and stable identifiers

Rows share a structure. A query selects the fields and records relevant to the question.

Next: Select rows

Conceptual application workflow. Qualify the supported operations, external tools, protection and persistence for the complete path. These diagrams are explanatory, not measured results.

Read the complete workflow and comparison scope
  1. Ingest operational records and stable identifiers
  2. Filter the relevant assets and inspection dates
  3. Resolve relationships and source documents
  4. Inspect associated readings or spatial context
  5. Produce a report whose rows lead back to evidence

Measure preparation, indexing, query and result assembly. A fast selected SQL-like operation does not establish faster analytics across every workload.

Compare a realistic alternative.

DuckDB is an embedded analytics alternative with an extension ecosystem. Compare required expressions, formats and deployment alongside the value of connected native representations.

DuckDB extensions

Compare equivalent outputs and required guarantees, including the simplest single-product alternative where one exists. A specialist may remain the better fit when its operators, ecosystem or operational maturity are decisive. Combining native models becomes valuable when your actual question crosses them.

Modality performance / Evidence reviewed 18 September 2026

Analytical work on approximately 100 million rows.

Cross-campaign contextMay–September 2026 references
milliseconds · filtered count Lower is better · linear scale from zero
8DB18
May 2026 · specialized server handler
ClickHouse1
September 2026 published reference
DuckDB41
May 2026 published reference
Apache Doris50
May 2026 published reference
StarRocks59
September 2026 published reference

c6a.4xlarge machine class; dates, settings and timing boundaries differ. This selected count is not the full ClickBench suite or evidence of SQL compatibility. ClickHouse is faster in the shown reference.

Read the results, comparison and methods →
01Correct query outputs
02Scan / aggregation latency
03Ingest & index readiness
Include memory, storage, energy and hardware writes

Record build-time and serving memory separately, original and derived stored bytes, measured joules per completed job, and physical writes including indexing, compaction and recovery. A smaller representation does not by itself prove lower energy or longer device life.

Match correctness, freshness, durability and protection across alternatives. Encryption, authorization, adapters, network setup and output delivery belong in the complete-job comparison wherever required. No universal zero-overhead claim follows from these results.

Choose the path that fits your deployment.

Verify the supported API/SDK, data format, persistence and indexing behaviour for the release you plan to use. Match the operation-by-modality protection profile and device qualification to the workload.

Post-quantum protection · Plan a workload evaluation

Related articles

Take the next step into the thinking.

Reference / Reviewed 17 September 2026

Readable, shareable and traceable.

This reference explains 8DB’s public modality description with an explicit workload and selection criteria. It is a documentary review, not fresh execution of every operator or platform.

Public sources: 8DB modality scope; DuckDB extensions; the related articles above. Internal source leads and outstanding release checks remain in the editorial record.

Download this reference

Evaluate the question
your application needs to answer.

Bring the data shapes, input state, expected output and the systems you use today. Define a comparison around that complete job.

Discuss your workload