Complete worked examples, from basic selection to multi-constraint problems. Each one creates sample data, writes a query, and walks through the result.
Select items to maximize value while staying within a weight limit. The classic optimization problem.
Determine how many units of each product to manufacture within capacity constraints.
Select items matching specific criteria and ranges using BETWEEN and IN clauses.
Select meals to minimize cost while meeting nutritional requirements for protein, carbs, and fat.
Assign workers to tasks with multiple decision variables per row and equality constraints.
Pull constraint bounds from a configuration table, and apply per-category rules with WHEN.
Select assets to maximize expected return while respecting risk limits and diversification rules.
Assign resources to time slots across multiple tables using JOIN with decision variables.
Find a valid shift assignment with no objective. Demonstrates that DeciDB solves constraint satisfaction problems, not just optimization.
Enforce a separate constraint per department using PER, generating one constraint per distinct column value without hardcoding any group names.
Make one decision per entity across a join using DECIDE Table.var, ensuring consistent retain/release choices even when a nurse appears in many shift rows.
Ship supplies from depots to regions across a three-way join, charging each depot's opening cost once with a relation-qualified reducer, SUM(D: expr).
Check out the documentation for the complete syntax reference and learn more about the project.