One of the most common client request is to display statistics per day/week/month or other periods of time. This statistics might mean clicks, article views, user registered etc.
Let’s see how can we display statistics of article views by day, week and month using php and mysql.
Posts Tagged ‘Databases’
Getting statistics by period using mysql
June 16th, 2010
No Comments
10 things you should know when switching from Mysql to PostgreSQL
May 29th, 2010
1 Comment
1) Vacuum frequently
You must do that especially after adding or deleting a large number of rows in a table.
2) || means concatenation in PosgreSql
(as opossed to Mysql where it ment OR)
3) PostgreSQL doesn’t know unsigned.
SMALLINT, INTEGER, BIGINT types doesn’t have an unsigned option, as it is in mysql
4) PostgreSQL is case-sensitive for string comparasions
So if [...]
