Show a count of new installs per day
February 11, 2009
Everytime we launch a new application in a social network, after a few weeks it’s important to know if we have upward growth.
The only thing I can think that demonstrates this is more installs per day. In our databases we capture full timestamps of the new installed user.
To turn this into something I can look at and understand, I have to run this query.
SELECT date_format( date_added, ‘%Y-%m-%d’ ) , count( * )
FROM fb_user
GROUP BY date_format( date_added, ‘%Y-%m-%d’ )
ORDER BY date_format( date_added, ‘%Y-%m-%d’ ) ASC
I am going to try to make a graph to view this in flex… first time Flex graphing đŸ™‚ I’ll post an update when it works..
MySQL / PHPMyAdmin Trigger Syntax
November 12, 2008
Ok this was extremely annoying but figure it out (again ) this time I am documenting what I did, to help me ( cause I know I’ll forget how I did it ) and for anyone else having the same issue.
Trying to insert a trigger through the phpmyadmin web interface.
- Ensure your SQL on it’s own is correct
- Ensure your MySQL trigger syntax is correct
- change the delimiter ( in the text field) to something like % ( see diagram )
- put the new delimiter at the end of the entire statement
- Pray for mercy !
Here is a diagram to really simplify it.