Cadago Faq

who?

Adam, Bobbie, Dan

what?

Cadago, a site to help create/maintain grocery lists, as an individual or group.
The name will most likely change.

when?

October 2008 and beyond.

why?

To help us, and we feel like sharing.

where?

http://armware.net/
Geographically speaking, Omaha Nebraska.

how?

At first, brainstorming and doodling on paper with colored pencils Can you guess the only color we had?

(default) 13 queries took 15 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	1
3	DESCRIBE `aros_acos`	7	7	1
4	DESCRIBE `users`	9	9	2
5	DESCRIBE `groups`	4	4	1
6	DESCRIBE `grocery_lists`	4	4	1
7	DESCRIBE `recipes`	12	12	1
8	DESCRIBE `tags`	4	4	1
9	DESCRIBE `recipes_tags`	2	2	1
10	DESCRIBE `votes`	2	2	2
11	SELECT `User`.`id`, `User`.`username`, `User`.`phone_number`, `User`.`phone_carrier`, `User`.`password`, `User`.`group_id`, `User`.`active`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` IS NULL LIMIT 1	0	0	1
12	SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1	13	13	1
13	SELECT `Recipe`.`id`, `Recipe`.`user_id`, `Recipe`.`name`, `Recipe`.`servings`, `Recipe`.`description`, `Recipe`.`directions`, `Recipe`.`ingredients`, `Recipe`.`tags`, `Recipe`.`created`, `Recipe`.`updated`, `Recipe`.`votes`, `Recipe`.`rating`, `RecipesTag`.`recipe_id`, `RecipesTag`.`tag_id` FROM `recipes` AS `Recipe` JOIN `recipes_tags` AS `RecipesTag` ON (`RecipesTag`.`tag_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13) AND `RecipesTag`.`recipe_id` = `Recipe`.`id`) WHERE 1 = 1	5	5	1

(default) 13 queries took 15 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `users`

DESCRIBE `groups`

DESCRIBE `grocery_lists`

DESCRIBE `recipes`

DESCRIBE `tags`

DESCRIBE `recipes_tags`

DESCRIBE `votes`

SELECT `User`.`id`, `User`.`username`, `User`.`phone_number`, `User`.`phone_carrier`, `User`.`password`, `User`.`group_id`, `User`.`active`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` IS NULL LIMIT 1

SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1

SELECT `Recipe`.`id`, `Recipe`.`user_id`, `Recipe`.`name`, `Recipe`.`servings`, `Recipe`.`description`, `Recipe`.`directions`, `Recipe`.`ingredients`, `Recipe`.`tags`, `Recipe`.`created`, `Recipe`.`updated`, `Recipe`.`votes`, `Recipe`.`rating`, `RecipesTag`.`recipe_id`, `RecipesTag`.`tag_id` FROM `recipes` AS `Recipe` JOIN `recipes_tags` AS `RecipesTag` ON (`RecipesTag`.`tag_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13) AND `RecipesTag`.`recipe_id` = `Recipe`.`id`) WHERE 1 = 1