PHP MySQL prepared statement vs SQL statement

I should confess - I am already using MySQL prepared statements for some time, but very rarely and mainly because they can make certain scripts more readable. As many of us I have read a lot of articles about coolness of prepared statements and that I should use them because of security and speed improvements. Finally my сuriosity won and I decided to test prepared statements against ordinary SQL statements myself. Friendly speaking I was impressed by the results I got....

Read complete article: PHP MySQL prepared statement vs SQL statement

Scaling MySQL database with partitioning & subpartitioning

Many of us sooner or later have to scale our web applications. When we are talking about scalability we are always talking about the data and data storage. There are many options for data storage nowdays as relational databases, key-value storages and document oriented storages , but great part of web applications are using MySQL relational database as the main data storage maibly because of its flexebility. This article describes one of the MySQL scaling approaches - partitioning.

Read complete article: Scaling MySQL database with partitioning & subpartitioning

Twitter & facebook bookmarklets update

Today I am just want o anounce a bug fix update of Twitter and Facebook bokkmarklets. To explain a little to the people who are not using them yet. This bookmarklets allowing to select the texts on any web page and post it to the selected social network - twitter or facebook relatively.

Read complete article: Twitter & facebook bookmarklets bugfix update