Posts Tagged ‘Mysql’

Getting statistics by period using mysql

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.

10 things you should know when switching from Mysql to PostgreSQL

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 [...]