Definitions#

The example stores a query definition and executes it with different variables. It then changes the query ordering and updates the people that the query selects.

Example#

Run stored definitions by path#

promote := stardust.mutation(db, "people/promote") or_return
defer stardust.close(&promote)

commit := stardust.run(promote) or_return
defer stardust.close(&commit)

query := stardust.query(db, "people/by_role") or_return
defer stardust.close(&query)

rows := stardust.run(query) or_return
defer stardust.close(&rows)

result := stardust.next(rows) or_return
defer stardust.close(&result)

Definition versions#

A transaction records each committed change to a stored definition.

• An open definition handle identifies its stored path, so later calls can select the applicable version.
• To read a specific historical version, use the as_of rules below.

Stored query and mutation plans#

The plan operation below reads and controls the accepted plan for a stored query or mutation. It works without a planner plugin. Mutation selections use the query planner and report selection feedback. Background trials of a mutation execute its selection only. They do not apply its patch.

The adaptive planner can retain separate plans for exact parameter values. Values without a retained plan use the shared fallback plan. Measured repeated-use savings must justify the lookup, trial and storage costs within the database memory budget. Optional anchor probes can improve estimates when their measured cost justifies the work. An incomplete probe supplies a lower bound and cannot prove that a query is empty.

Use explain for the current accepted state and its paged revision history. Use status for the current state alone, or history for a history page. Each history entry includes the plan version, source and reason for the change. Trial reasons report the candidates and their measured outcomes.

The pin action prevents automatic replacement for every parameter value. The unpin action permits learning again. The replan action rebuilds the fallback plan and clears specialized parameter plans. It preserves the global pin. The revert action restores a complete historical state, including its pin and parameter plans. Revert requires the exact plan transaction and the same authored definition revision.

Explicit changes compare both authored and accepted plan revisions inside the commit. A concurrent definition or plan change reports conflict. Every returned plan document owns its buffers and remains readable after the database closes.

Operations#

definition#

definition :: proc(
	db: Database,
	kind, path: string,
	as_of: builtin.i64 = 0,
	allocator := context.allocator,
) -> (
	Document,
	Error,
)

Parameters#

Errors#

Examples#

Read a stored query definition#

result := stardust.definition(db, "queries", "people/by_role") or_return
defer stardust.close(&result)

C exports: stardust_db_definition_get, stardust_result_take_document, stardust_result_error, stardust_result_release

plan#

plan :: proc(
	db: Database,
	kind, path, action: string,
	argument: builtin.i64 = 0,
	page_size: builtin.i64 = 0,
	max_bytes: builtin.i64 = 0,
	allocator := context.allocator,
) -> (Document, Error)

Parameters#

Errors#

Examples#

Pin a plan and explain its revision history#

pinned := stardust.plan(db, "queries", "people/by_role", "pin") or_return
stardust.close(&pinned)
result := stardust.plan(db, "queries", "people/by_role", "explain", 0, 16, 1 << 20) or_return
defer stardust.close(&result)

C exports: stardust_db_plan, stardust_result_take_document, stardust_result_error, stardust_result_release

definitions#

definitions :: proc(
	db: Database,
	kind: string,
	pattern := "",
	allocator := context.allocator,
) -> (
	Document,
	Error,
)

Parameters#

Errors#

Examples#

database/definitions#

result := stardust.definitions(db, "queries", "people/.*") or_return
defer stardust.close(&result)

database/definitions#

result := stardust.definitions(db, "queries", "people/.*") or_return
defer stardust.close(&result)

database/definitions#

result := stardust.definitions(db, "queries", "people/.*") or_return
defer stardust.close(&result)

database/definitions#

result := stardust.definitions(db, "queries", "people/.*") or_return
defer stardust.close(&result)

C exports: stardust_db_definition_list, stardust_result_take_document, stardust_result_error, stardust_result_release

patch_definition#

patch_definition :: proc(
	db: Database,
	kind, path: string,
	patch: Document,
	allocator := context.allocator,
) -> (
	Commit,
	Error,
)

Parameters#

Errors#

Examples#

database/patch_definition#

definition_text holds this document:

patch := stardust.parse(definition_text, .TRON) or_return
defer stardust.close(&patch)

commit := stardust.patch_definition(db, "queries", "people/by_role", patch) or_return
defer stardust.close(&commit)

result := commit

C exports: stardust_db_definition_patch, stardust_db_result_commit_info, stardust_result_error, stardust_result_release