Technical stuff Requirements are like water. They're easier to build on when they're frozen.

Archive for the ‘Quick and dirty’ Category

Quick UML diagrams, on the fly

07.20.2009 · Posted in Quick and dirty

You go to the yUml site and throw some data in the text box offered Press “Generate the Diagram!” Voila! And here’s an example, as well: [sourcecode] http://yuml.me/diagram/scruffy;scale:60/usecase/[Admin]^[User Free], [Admin]^[User Premium], [Admin]-(note: Most privileged user), [User Free]-(note: No costs), [User Premium]-(note: Monthly subscription), [User Free]-(Login), [User Free]-(Logout) , [User Premium]-(Login), [User Premium]-(Logout) , (Login)<(Reminder) , ...

mySQL: find out distinct values of a column and the number of their occurrences

06.20.2009 · Posted in Quick and dirty, Software, testing

So, we need to find out different values of a column and the number of their occurrences. Let’s set up a small test first: -- Step #1: prepare the ground CREATE DATABASE IF NOT EXISTS `test`; DROP TABLE IF EXISTS `test`.`test_count_distinct`; CREATE TABLE `test`.`test_count_distinct` ( `id` INT(11) NOT NULL auto_increment PRIMARY KEY, `title` VARCHAR(50) NOT ...