Cadago Change Log

planned features/fixes

recipe voting system
increased recipe list odetails
item (and quantity) recognition and optimization
rename saved grocery lists
browse recipes still needs improvement
numerous interface tweaks

2010.01.25

centered boxes
save quick grocery lists
numerous bug fixes

2009.12.24

reorganized layout
subtle improvements to recipe browsing

2009.11.12

added depth to look

2009.11.7

recipes browsable by tags
auto logouts were happening too quick

2009.11.5

renamed to Cadago
remember, remember the 5th of november

2009.10.23

send list as text message (sms) implemented
improved grocery list building process

2009.10.09

More UI tweaks, mostly polishing and loose ends
Recipes add to grocery list along side additional items

2009.10.07

UI tweaks of all kinds.
Logic tweaking as well.

2009.09.30

Made recipe lists pretty. Numerous random small bug fixes/functionality tweaks.

2009.08.27

Perfecting and tweaking how the system handles users.

2009.08.10

Rewriting Glipper with CakePHP.

v2008.11.08

added saving phone number & carrier to profile
fixed phone number cleanup

v2008.10.31

added phone number cleanup

v2008.10.30

added sending list to phone

v2008.10.29

fixed list change glitches

v2008.10.28

added change log & versioning
added clear grocery list

(default) 13 queries took 13 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	1
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	1
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 13 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