Quiver DB

Quiver DB is a schema-first SQLite wrapper for decision support models. Define your schema in plain SQL, and Quiver gives you typed collections with scalars, vectors, sets, and time series — plus parameterized queries, CSV import/export, transaction control, and built-in migration support. Implemented in C++ with bindings for Julia, Dart, Python, and embedded Lua scripting.

Features

• Schema-first — define tables in .sql files, Quiver introspects them at runtime
• Typed collections — integer, float, and string scalars with automatic type marshaling
• Vectors and sets — first-class array and set attributes per element
• Time series — multi-column time series with dimension ordering
• Parameterized queries — type-safe positional ? parameters
• CSV import/export — round-trip data with enum resolution and date formatting
• Transaction control — explicit begin/commit/rollback with nest-aware RAII
• Lua scripting — run Lua scripts with full database access
• Multi-language — consistent API across C++, Julia, Dart, Python, and Lua

Quick Start

C++

#include <quiver/database.h>
#include <quiver/element.h>

auto db = quiver::Database::from_schema("my.db", "schema.sql");

quiver::Element el;
el.set("label", std::string("Item 1")).set("value", int64_t{42});
db.create_element("Collection", el);

auto values = db.read_scalar_integers("Collection", "value");
// values == {42}

Julia

using Quiver

db = Quiver.from_schema("my.db", "schema.sql")

Quiver.create_element!(db, "Collection"; label="Item 1", value=42)

values = Quiver.read_scalar_integers(db, "Collection", "value")
# values == [42]

Quiver.close!(db)

Dart

import 'package:quiverdb/quiverdb.dart';

final db = Database.fromSchema('my.db', 'schema.sql');

db.createElement('Collection', {'label': 'Item 1', 'value': 42});

final values = db.readScalarIntegers('Collection', 'value');
// values == [42]

db.close();

Python

from quiverdb import Database

db = Database.from_schema("my.db", "schema.sql")

db.create_element("Collection", label="Item 1", value=42)

values = db.read_scalar_integers("Collection", "value")
# values == [42]

db.close()

Lua (embedded)

db:create_element("Collection", { label = "Item 1", value = 42 })

local values = db:read_scalar_integers("Collection", "value")
-- values == {42}