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.
Use scalar subqueries and CASE expressions to compute constraint bounds dynamically.
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.
Check out the documentation for the complete syntax reference and learn more about the project.